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?
A.
Remove the NON EMPTY clauses.
B.
Replace the CHAPTERS axis with the ROWS axis.
C.
Replace the CHAPTERS axis with the SECTIONS axis.
D.
Rewrite the query to display the Order Quantity on the COLUMNS axis, the Calendar
Year on
the ROWS axis, and the Category data on the PAGES axis.
Explanation: