荣丰2008,《Microsoft SQL Server 2008 MDX Step by Step》学习笔记一：MDX查询第一课疯狂代码！

SQL Server 2008中SQL应用系列及BI笔记系列--目录索引
导读:本文介绍MDX查询的基础内容，已经了解的读者可以直接略过。
本文将包括以下内容：
■1、使用MDX查询编辑器构建并执行MDX查询。
本文所用数据库和所有源码，请到微软官网下载

1、SQL查询与MDX查询示例比较
在MdxStepByStep数据库中（后缀名为.SQL）查询

USE MdxStepByStep SELECT m.EnglishProductName, o.TotalSalesAmount FROM dbo.DimProduct m INNER JOIN ( -- TOP 10 PRODUCTS OF 2003 SELECT TOP 10 a.ProductKey, SUM(a.SalesAmount) AS TotalSalesAmount FROM ( SELECT x.productkey, x.salesamount FROM dbo.FactInternetSales x INNER JOIN dbo.DimDate y ON x.OrderDateKey=y.DateKey WHERE y.CalendarYear=2003 UNION ALL SELECT x.productkey, x.salesamount FROM dbo.FactResellerSales x INNER JOIN dbo.DimDate y ON x.OrderDateKey=y.DateKey WHERE y.CalendarYear=2003 ) a GROUP BY a.ProductKey ORDER BY TotalSalesAmount DESC ) n ON m.ProductKey=n.ProductKey LEFT OUTER JOIN ( --PRODUCT SALES IN 2004 SELECT a.ProductKey, SUM(a.SalesAmount) AS TotalSalesAmount FROM ( SELECT x.productkey, x.salesamount FROM dbo.FactInternetSales x INNER JOIN dbo.DimDate y ON x.OrderDateKey=y.DateKey WHERE y.CalendarYear=2004 UNION ALL SELECT x.productkey, x.salesamount FROM dbo.FactResellerSales x INNER JOIN dbo.DimDate y ON x.OrderDateKey=y.DateKey WHERE y.CalendarYear=2004 ) a GROUP BY a.ProductKey ) o ON m.ProductKey=o.productkey ORDER BY n.TotalSalesAmount DESC /* EnglishProductName TotalSalesAmount Mountain-200 Black, 38 1327957.4077 Mountain-200 Black, 42 1139429.4872 Mountain-200 Silver, 38 1136622.4928 Mountain-200 Black, 46 1011074.3685 Mountain-200 Black, 38 NULL Mountain-200 Silver, 42 1011486.1762 Touring-1000 Blue, 60 835290.1559 Road-350-W Yellow, 48 897217.9635 Mountain-200 Silver, 46 1029170.7639 Road-350-W Yellow, 40 840970.6467 */

而在维度数据库中对应的MDX查询（后缀名为.MDX）如下：

WITH MEMBER [Measures].[Total Sales Amount] AS ([Measures].[Internet Sales Amount]) + ([Measures].[Reseller Sales Amount]) SET [Top 10 Products of 2003] AS TOPCOUNT( {[Product].[Product].[Product].Members}, 10, ([Measures].[Total Sales Amount], [Date].[Calendar Year].[CY 2003]) ) SELECT {([Measures].[Total Sales Amount])} _disibledevent=>2、 用MDX 查询编辑器实现一个最简单的MDX的编写。 </strong> <br/> 在SSMS界面登录Analysis Services，选择MDX Step By Step数据库：<br/> 对于MDX新手来说，最令人鼓舞的莫过于大部分MDX查询都可以借助拖拽来实现。<br/> <img src="http://09yuxg.blu.livefilestore.com/y1p5P710_Co3468JtifYyFf34PvjYMxNcoWiuXSxet8Wdj_bicd0sl7ubPBkHTcpeQQpAigA2b01EL3QGZZe6EIuw8WMMPWlZZv/2011-6-12%2017-09-43.png?psid=1" alt="邀月工作室" width="718" height="257" /> <br/> <img src="http://09yuxg.blu.livefilestore.com/y1pvIgoxV_Wr22vznZX203S5RmbQbdv6AKjuPHLL_hhttj28Cl-4MQ-Pd91vSYdUEPVOpyE7DEDrbp71ApA7_rj8IP-ppIF5UBe/2011-6-12%2017-18-35.png?psid=1" alt="邀月工作室" width="716" height="496" /> <br/> <img src="http://09yuxg.blu.livefilestore.com/y1pvIgoxV_Wr23WbObsR7nByj1fao86ehOp27r0DymBxtuG00fj90PexbaR5D7E67_J9BqF4ODMHy0ikFoMY7497vK4pZktE-4L/2011-6-12%2017-21-24.png?psid=1" alt="邀月工作室" width="857" height="499" /> <br/> <img src="http://09yuxg.blu.livefilestore.com/y1pNxtD1IDqD_VUzmBQOkkN-iAE7xe_eG2eNxAKSRoqwCNCYudNRZYS0mrBtxJnkKb0Oc9WH4BmYOPuxgvpxcZoEPJxyjcNag21/2011-6-12%2017-24-49.png?psid=1" alt="邀月工作室" width="856" height="484" /> <br/> <img src="http://09yuxg.blu.livefilestore.com/y1pPNH_Q0K_klPYJ8PWu-i07OhWn-JMMoh1-UXEU_BpUWkX0-e3SwJCFu0YO7DR6qsRTk0SHCFTJKzEaF66mgQWflhQCrrN0S63/2011-6-12%2017-28-38.png?psid=1" alt="邀月工作室" width="854" height="597" /> <br/> <img src="http://09yuxg.blu.livefilestore.com/y1p_ItuBQbviBhcBcBuXETZeOt1c7kiMBoZ658osrmMXmT7h_EFK19DkEGQ2NelTZINBsGRftONqnpC3rr5dUQN12HlCrW8v5ZH/2011-6-12%2017-30-07.png?psid=1" alt="邀月工作室" width="541" height="388" /> <br/> 参考资源：<br/> 1、MDX官方教程（http://msdn.microsoft.com/zh-cn/library/ms145506.aspx ）<br/> 邀月注：鉴于读者提出意见，本系列尽量简明，方便读者阅读。<br/> <strong>邀月注：本文版权由邀月和CSDN共同所有，转载请注明出处。 <br /> 助人等于自助!  </strong> 3w@live.cn   <strong><br/> </strong> 
				<div>                                                                                                                                                                                                                                      </div>
			<div id="entry-tags"><span>Tags:</span> 	<a href='/Tag/Digital-Master-2008-225974/Index.html'>数码大师2008</a> <a href='/Tag/96565/Index.html'>腾讯qq2008</a> <a href='/Tag/Wing-Fung-2008-225973/Index.html'>荣丰2008</a> </div>
			<script language="javascript">
				showSns();
			</script>			
			<h3 class="related_post_title">延伸阅读</h3>
			<ul class="related_post"> 
			
					<li><span>2011-6-13</span>-- <a href="/Bo-abstracts-selected/Article180529.html">荣丰2008,《Microsoft SQL Server 2008 MDX Step by Step》学习笔记二：理解元数组（Tuples）</a></li>
				
					<li><span>2011-6-12</span>-- <a href="/Bo-abstracts-selected/Article180526.html">荣丰2008,《Microsoft SQL Server 2008 MDX Step by Step》学习笔记二：理解元数组（Tuples）</a></li>
				
					<li><span>2009-9-2</span>-- <a href="/QQ/Article67575.html">腾讯qq:腾讯QQ 光环褪尽显丑陋！</a></li>
				
					<li><span>2009-9-2</span>-- <a href="/QQ/Article67744.html">腾讯qq:谁来阻击腾讯QQ?</a></li>
				
					<li><span>2009-9-2</span>-- <a href="/QQ/Article67661.html">腾讯qq:腾讯打响QQ密码保卫战</a></li>
				
					<li><span>2009-9-2</span>-- <a href="/QQ/Article67601.html">腾讯qq:一场虚惊?腾讯QQ有病毒传闻不实</a></li>
				
					<li><span>2009-9-2</span>-- <a href="/QQ/Article67823.html">腾讯qq:教你WindowsXP中彻底封杀腾讯QQ广告</a></li>
				
					<li><span>2009-9-2</span>-- <a href="/QQ/Article67825.html">腾讯qq:让你的腾讯QQ回归自然本色</a></li>
				
			</ul>							
		</div> 
		</div>
<div class="list-y">
	<ul class="list">
		
	</ul>
</div>

验证码点击图片更换

荣丰2008,《Microsoft SQL Server 2008 MDX Step by Step》学习笔记一：MDX查询第一课

赞助商广告

随机更新

热门标注

最近更新

最新标注