SELECT {[Measures].[XX度量]} ON COLUMNS,
{nonempty(EXCEPT([A维度].[A].[A].ALLMEMBERS,{[A维度].[A].&[-1],[A维度].[A].[All].UNKNOWNMEMBER}))
*except([B维度].[B].[B].ALLMEMBERS,{[B维度].[B].&[-1],[B维度].[B].[All].UNKNOWNMEMBER})
* except([C维度].[C].[CC].ALLMEMBERS,{[C维度].[C].&[-1],[C维度].[C].[All].UNKNOWNMEMBER})}
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM (select strtoset(@ParameterA) on columns
FROM (SELECT Strtomember(@ParameterB):Strtomember(@ParameterC) ON COLUMNS
FROM [CUBE]))
{nonempty(EXCEPT([A维度].[A].[A].ALLMEMBERS,{[A维度].[A].&[-1],[A维度].[A].[All].UNKNOWNMEMBER}))
*except([B维度].[B].[B].ALLMEMBERS,{[B维度].[B].&[-1],[B维度].[B].[All].UNKNOWNMEMBER})
* except([C维度].[C].[CC].ALLMEMBERS,{[C维度].[C].&[-1],[C维度].[C].[All].UNKNOWNMEMBER})}
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM (select strtoset(@ParameterA) on columns
FROM (SELECT Strtomember(@ParameterB):Strtomember(@ParameterC) ON COLUMNS
FROM [CUBE]))