mdx介绍.docVIP

下面的内容经过完整的测试，结合了网上看到的其他文章，修改整理。 测试环境如下： windows 2003 sp2 mondrian-2687 jdk1.6 tomcat 5.5.23 LISTING 1: Determining Products Sold in Each State 说明：每个州（省）都在销售的产品 [en] with set [SoldInUSA] as Filter([Product].[Brand Name].Members, Not IsEmpty( ([USA], [Unit Sales]) )) member [Measures].[SoldInState] as iif( IsEmpty(([Product].CurrentMember, [Unit Sales], [Customers].CurrentMember)), No,Yes ) select [USA].children on COLUMNS, [SoldInUSA] on ROWS from Sales where ([Measures].[SoldInState]) [cn] with set [SoldInUSA] as Filter([Product].[Brand Name].Members, Not IsEmpty( ([美国], [Unit Sales]) )) member [Measures].[SoldInState] as iif( IsEmpty(([Product].CurrentMember, [Unit Sales], [Customers].CurrentMember)), No,Yes ) select [美国].children on COLUMNS, [SoldInUSA] on ROWS from Sales where ([Measures].[SoldInState]) LISTING 2: Determining Top 10 Product Categories 说明：列出销售额排名前十的产品类别 select {[Measures].[Unit Sales]} ON COLUMNS, TopCount([Product].[Product Category].Members, 10.0, [Measures].[Unit Sales]) ON ROWS from [Sales] Listing_03.Determining Brands Sold During the Past Three Quarters.txt 说明：列出过去三个季度里都存在销售量的商品销售记录 [en] with set [LastQuarter] as Tail(Filter([Time].[Quarter].Members, Not IsEmpty([Time].CurrentMember)),1) set [Last3Quarters] as [LastQuarter].item(0).item(0).Lag(2) : [LastQuarter].item(0).item(0) select [Last3Quarters] on COLUMNS, Non Empty Union(Descendants( [Food], [Product].[Brand Name] ), Descendants( [Drink], [Product].[Brand Name] )) on ROWS from Sales [cn] with set [LastQuarter] as Tail(Filter([Time].[Quarter].Members, Not IsEmpty([Time].CurrentMember)),1) set [Last3Quarters] as [LastQuarter].item(0).item(0).Lag(2) : [LastQuarter].item(0).item(0) select [Last3Quarters] on COLUMNS, Non Empty Union(Descendants( [食品], [Product].[Brand Name] ), Descendants( [饮用类], [Product].[Brand Name] )) on ROWS from Sales Listing_04.Determining Recent Trends for Best-Selling Brands.txt 说明：查出最近6个月销售趋势最好的前10个商品及销售量 with set [Ten