You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report is based on the multidimensional data from a Microsoft SQL Server 2005 Analysis Services (SSAS) cube. You need to use the Report Wizard to create a Matrix report by using the [Change Count] measure in the Details field. Which Multidimensional Expressions (MDX) query should you use?
A.
SELECT NON EMPTY { [Measures].[Change Count] } ON ROWS, DIMENSION PROPERTIES MEMBER_CAPTION { [Measures]. [Change Count] } ON COLUMNS
B.
SELECT NON EMPTY { [Measures].[Change Count] } ON COLUMNS, DIMENSION PROPERTIES MEMBER_CAPTION { [Measures]. [Change Count] } ON ROWS
C.
SELECT DIMENSION PROPERTIES MEMBER_CAPTION { [Measures].[Change Count] } ON ROWS
D.
SELECT DIMENSION PROPERTIES MEMBER_CAPTION { [Measures].[Change Count] } ON COLUMNS