参数范围的选择

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], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,filter( [DAccount].[Parent].ALLMEMBERS

, [DAccount].[Parent].currentmember.name="管理费用" or  [DAccount].[Parent].currentmember.parent.name="管理费用") ON ROWS

FROM [XXX]

posted @ 2012-06-25 12:31  chunshen  阅读(228)  评论(0)  编辑  收藏  举报