Microsoft
70-448 · Question #79
70-448 Question #79: Real Exam Question with Answer & Explanation
The correct answer is B. You should use the expression of SELECT NON EMPTY { [Measures].[Change Count] } ON COLUMNS,. See the full explanation below for the reasoning.
Question
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?
Options
- AYou should use the expression of SELECT EMPTY { [Measures].[Change Number] } ON ROWS,
- BYou should use the expression of SELECT NON EMPTY { [Measures].[Change Count] } ON COLUMNS,
- CYou should use the expression of SELECT DIMENSION PROPERTIES MEMBER_CAPTION
- DYou should use the expression of SELECT DIMENSION PROPERTIES MEMBER_CAPTION
Community Discussion
No community discussion yet for this question.