PrepAway - Latest Free Exam Questions & Answers

Which is the correct answer to create a Matrix report by using the [Change Count] measure in the Details field

You are developing a SQL Server 2008 Reporting Services (SSRS) report for Company.com.

You should create the report basing on the multidimensional data from a Microsoft SQL Server 2005 Analysis Services (SSAS) cube.
In order to create a Matrix report by using the [Change Count] measure in the Details field.

You should utilize the Report Wizard
Which is the correct answer?

PrepAway - Latest Free Exam Questions & Answers

A.
You should use the expression of SELECT EMPTY { [Measures].[Change Number] } ON ROWS, DIMENSION PROPERTIES MEMBER_CAPTION { [Measures]. [Change Count] } ON COLUMNS

B.
You should use the expression of SELECT NON EMPTY { [Measures].[Change Count] } ON COLUMNS, DIMENSION PROPERTIES MEMBER_CAPTION { [Measures]. [Change Count] } ON ROWS

C.
You should use the expression of SELECT DIMENSION PROPERTIES MEMBER_CAPTION { [Measures].[Change Number] } ON ROWS

D.
You should use the expression of SELECT DIMENSION PROPERTIES MEMBER_CAPTION { [Measures].[Change Count] } ON COLUMNS


Leave a Reply