MDX语句

 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]))