mdx question

I have 2 dimension tables :students and classes related through a fact table that contains the keys of these tables in addition to other keys such as academic year and other stuff. the classes dimension has an attribute called class_department.

what is the statement in mdx to get the class_department for a student in students table?

thanks

Christina

I guess you want the MDX query? Since I don't know the naming of your dimensions/members/measures, I will just give it a shot with some similar names. I assume that you have one measure in your fact table - a count measure.

SELECT {[Measures].[Count]} ON 0,

{[Classes].[Class_department].members} ON 1

FROM [YourCube]

WHERE {[Student].[Student Name].[John Doe]}