关于SSAS MDX 计算成员使用的问题，新手求教，谢谢先!

0

为了尽量描述清楚，用EXCEL编了以下数据集（实际中较为复杂）

一、写查询：

 WITH  

	MEMBER [班级].[班级].[1-2班] AS sum({[班级].[班级].&[1],[班级].[班级].&[2]},[Measures].CurrentMember)

	MEMBER [班级].[班级].[2-3班] AS sum({[班级].[班级].&[2],[班级].[班级].&[3]},[Measures].CurrentMember)

	SET [两组班级] as {[班级].[班级].[1-2班],[班级].[班级].[2-3班]}

 SELECT 

	[Measures].[成绩] ON 0,

	[两组班级] ON 1

 FROM [班级CUBE]

得到结果类似：

但写查询：

 WITH  

	MEMBER [班级].[班级].[1-2班] AS sum({[班级].[班级].&[1],[班级].[班级].&[2]},[Measures].CurrentMember)

	MEMBER [班级].[班级].[2-3班] AS sum({[班级].[班级].&[2],[班级].[班级].&[3]},[Measures].CurrentMember)

	SET [两组班级] as {[班级].[班级].[1-2班],[班级].[班级].[2-3班]}

 SELECT 

	[Measures].[成绩] ON 0,

	[两组班级] * [学生].[学生].members ON 1

 FROM [班级CUBE]