Microsoft
70-448 · Question #103
70-448 Question #103: Real Exam Question with Answer & Explanation
The correct answer is B. You should select the ROWS axis. See the full explanation below for the reasoning.
Question
You are creating a SQL Server 2008 Reporting Services (SSRS) report which utilizes a Multidimensional Expressions (MDX) query including a parameter to show products information for various product categories for Company.com. The codes listed below: SELECT NON EMPTY {[Measures].[Reseller Sales-Order Quantity] } ON COLUMNS, NON EMPTY {([Month.[Calendar Year].[Calendar Year].ALLMEMBERS * [Products].[Category]. [Category].ALLMEMBERS ) } ON CHAPTERS FROM (SELECT (STRTOSET(@Category,CONSTRAINED)) ON COLUMNS FROM [Adventure Works Cube]) You find out that the search produces an error when running. You should make sure that the query runs normally. Which is the correct answer?
Options
- AYou should delete the NON EMPTY clauses.
- BYou should select the ROWS axis
- CYou should select the CHAPTERS axis
- DYou should select the SECTIONS axis
Community Discussion
No community discussion yet for this question.