参数格式

最新推荐文章于 2024-09-09 10:44:23 发布

weixin_30569153

最新推荐文章于 2024-09-09 10:44:23 发布

阅读量100

点赞数

原文链接：http://www.cnblogs.com/chunshen/archive/2012/06/25/2560901.html

版权

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