Microsoft
70-448 · Question #287
You develop a SQL Server 2008 Reporting Services (SSRS) report. A Multidimensional Expressions (MDX) query used in the report contains a parameter to display sales data for various product…
The correct answer is B. Replace the CHAPTERS axis with the ROWS axis. See the full explanation below for the reasoning.
Question
You develop a SQL Server 2008 Reporting Services (SSRS) report. A Multidimensional Expressions (MDX) query used in the report contains a parameter to display sales data for various product categories. You write the following query. You discover that the query generates an error when executed. You need to ensure that the query executes successfully. What should you do?
Exhibit
Options
- ARemove the NON EMPTY clauses.
- BReplace the CHAPTERS axis with the ROWS axis.
- CReplace the CHAPTERS axis with the SECTIONS axis.
- DRewrite the query to display the Order Quantity on the COLUMNS axis, the Calendar Year on the
How the community answered
(25 responses)- A8% (2)
- B84% (21)
- C4% (1)
- D4% (1)
Community Discussion
No community discussion yet for this question.