2012 年 6月 25 日随笔档案 - chunshen

2012年6月25日

摘要： =iif(RowNumber(Nothing) Mod2,"Green","White"). 阅读全文

posted @ 2012-06-25 12:35 chunshen 阅读(160) 评论(0) 推荐(0) 编辑

摘要： WITH MEMBER [Measures].[ParameterCaption] AS [DAccount].[Parent].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [DAccount].[Parent].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [DAccount].[Parent].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption. 阅读全文

posted @ 2012-06-25 12:31 chunshen 阅读(232) 评论(0) 推荐(0) 编辑

参数格式

摘要： 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 阅读全文

posted @ 2012-06-25 11:13 chunshen 阅读(276) 评论(0) 推荐(0) 编辑