参数格式

WITH

MEMBER [DAccount].[Parent].&[5].[营业利润] AS ([DAccount].[Parent].&[501],[Measures].[DAmount])-([DAccount].[Parent].&[502],[Measures].[DAmount])-([DAccount].[Parent].&[503],[Measures].[DAmount])

 

member [T1] as ANCESTOR([DAccount].[Parent].currentmember,[DAccount].[Parent].[Level 02]).name
member [T1S] as ANCESTOR([DAccount].[Parent].currentmember,[DAccount].[Parent].[Level 02]).properties('Number')

member [T2] as ANCESTOR([DAccount].[Parent].currentmember,[DAccount].[Parent].[Level 03]).name
member [T2S] as ANCESTOR([DAccount].[Parent].currentmember,[DAccount].[Parent].[Level 03]).properties('Number')

member [T3] as ANCESTOR([DAccount].[Parent].currentmember,[DAccount].[Parent].[Level 04]).name
member [T3S] as ANCESTOR([DAccount].[Parent].currentmember,[DAccount].[Parent].[Level 04]).properties('Number')

member [T4] as ANCESTOR([DAccount].[Parent].currentmember,[DAccount].[Parent].[Level 05]).name
member [T4S] as ANCESTOR([DAccount].[Parent].currentmember,[DAccount].[Parent].[Level 05]).properties('Number')

member [T5] as ANCESTOR([DAccount].[Parent].currentmember,[DAccount].[Parent].[Level 06]).name
member [T5S] as ANCESTOR([DAccount].[Parent].currentmember,[DAccount].[Parent].[Level 06]).properties('Number')

select
{T1,T1S,T2,T2S,T3,T3S,T4,T4S,T5,T5S,[Measures].[DAmount]} on 0
,{filter(filter([DAccount].[Parent].members,ANCESTOR([DAccount].[Parent].currentmember,[DAccount].[Parent].[Level 02]).name="损益" and IsLeaf([DAccount].[Parent].currentmember)<>0),([DAccount].[Parent].currentmember,[Measures].[DAmount])<>0)} on 1
from
(
    SELECT ( STRTOSET(@TimeYM, CONSTRAINED) ) ON COLUMNS
    FROM [XXX]
)
WHERE (
IIF( STRTOSET(@TimeYM, CONSTRAINED).Count = 1, STRTOSET(@TimeYM, CONSTRAINED), [Time].[YM].currentmember ))

转载于:https://www.cnblogs.com/chunshen/archive/2012/06/25/2560901.html