PrepAway - Latest Free Exam Questions & Answers

Which Multidimensional Expressions (MDX) query should you use?

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?

PrepAway - Latest Free Exam Questions & Answers

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


Leave a Reply