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]