分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识,造福人民,实现我们中华民族伟大复兴!
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.OrderDateKe