参数范围的选择

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]

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