2012年6月25日
表 颜色 隔行变换
摘要： =iif(RowNumber(Nothing) Mod2,"Green","White"). 阅读全文
posted @ 2012-06-25 12:35 chunshen 阅读(163) 评论(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 阅读(237) 评论(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 阅读(287) 评论(0) 推荐(0)