使用SSAS和MDX在列和行上显示不同的尺寸
|
嗨，我是SSAS和MDX的新手，我需要根据OLAP多维数据集生成一个ssrs报告。
我不知道如何在列和行上显示不同的维成员。
维度是列和客户端上的等级和时间，行上的状态是这样的：
| a rated | b rated | c rated | Year-3 | Year-2 | Year-1 | Year* | Total|
good clients |
medium clients|
bad clients |
total clients |
status 1 |
status 2 |
status 3 |
total status |
----------------------------------------------------------------------------------------
没有找到相关结果
已邀请:
4 个回复
苏髓骗撩
可能有助于解决您的问题。喷乡顾沥沪
舜辉
壬驴拿歪竞
| topSeller | Bottom Seller | 2011| 2012 | Topcustomers | Bottomcustomers| North America | Europe | //create //SET [Adventure Works].[TopCustomers] AS TopCount(([Customer].[Customer].Members,[Sales Territory].[Sales Territory Country].[All]), 3,[Measures].[Internet Sales Amount]) //SET [Adventure Works].[BottomCustomers] AS bottomCount(([Customer].[Customer].Members,[Sales Territory].[Sales Territory Country].[All]), 3,[Measures].[Internet Sales Amount]) //SET [Adventure Works].[NorthAmerica] AS ([Customer].[Customer].[All],{[Sales Territory].[Sales Territory Country].&[United States],[Sales Territory].[Sales Territory Country].&[Canada]}) //SET [Adventure Works].[Europe] AS ([Customer].[Customer].[All],{[Sales Territory].[Sales Territory Country].&[France],[Sales Territory].[Sales Territory Country].&[Germany],[Sales Territory].[Sales Territory Country].&[United Kingdom]}) // //SET [Adventure Works].[TopSellers] AS TopCount(([Product].[Model Name].Members,[Date].[Calendar Year].[All]), 3,[Measures].[Internet Sales Amount]) //SET [Adventure Works].[BottomSellers] AS BottomCount(([Product].[Model Name].Members,[Date].[Calendar Year].[All]), 3,[Measures].[Internet Sales Amount]) //SET [Adventure Works].[2011] AS ([Product].[Model Name].[All],[Date].[Calendar Year].&[2011]) //SET [Adventure Works].[2012] AS ([Product].[Model Name].[All],[Date].[Calendar Year].&[2012]) // select { ([Measures].[Internet Sales Amount],[TopSellers]), ([Measures].[Internet Sales Amount],[BottomSellers]), ([Measures].[Internet Sales Amount],[2011]), ([Measures].[Internet Sales Amount],[2012]) } on columns, { ([TopCustomers]), ([BottomCustomers]), ([NorthAmerica]), ([Europe]) } on rows from [Adventure Works]