参数范围的选择
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]