Background: 如果你想要在row上同時使用兩個Group的Corss join,此時會報錯,怎麼解?
關鍵,原本的Hierachy是:
[Product].[Product Hierarchy].[Product Category].members, [Product].[Product Hierarchy].[Product Subcategory].members
但如果是要顯示兩個set從同一個Hierachy來,則要想成
[Product].[Product Category].[Product Category].members * [Product].[Product Subcategory].[Product Subcategory].members
SELECT
{ [Date].[Calendar].[Year].&[2013] } ON COLUMNS ,
{ NONEMPTY(
{[Product].[Product Category].[Product Category].members}*{[Product].[Product Subcategory].[Product Subcategory].members}
* { [Measures].[Sales], [Measures].[COS] } , { [Date].[Calendar].[Year].&[2013] }
) } ON ROWS
FROM [Cube]
Reference:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/89e24084-4161-4bc9-8536-32e0be13fb4c/mdx-query-2-hierarchy-levels-on-1-axis?forum=sqlanalysisservices
Share on Twitter Share on FacebookSQL Server Analytics Service 1
SEO(1) Github(2) Title Tag(2) ML(1) 李宏毅(1) SQL Server(18) Tempdb(1) SSMS(1) Windows(1) 自我成長(2) Excel(1) python Flask(1) python(5) Flask(2)
Max Chen (159)
Comments
There are currently no comments
New Comment