You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support.
According to the company requirement of the company CIO, you develop a SQL Server 2008 Reporting Services (SSRS) report.
You use a Multidimensional Expressions (MDX) query in the report. The query contains a parameter to display sales data for various product categories.
You write the following query.
SELECT NON EMPTY {[Measures].[Reseller Sales-Order Quantity] } ON COLUMNS, NON EMPTY
{([Date].[Calendar Year].[Calendar Year].ALLMEMBERS * [Product].[Category].[Category].ALLMEMBERS ) }
ON CHAPTERS FROM
(SELECT (STRTOSET(@ProductCategory,CONSTRAINED))
ON COLUMNS FROM [Adventure Works Cube])
You notice that when the query is executed, an error occurs. You must make sure that the query executes successfully. So what action should be performed?
A.
You should rewrite the query, making it display the Order Quantity on the COLUMNS axis, the Calendar Year on the ROWS axis, and the Category data on the PAGES axis
B.
Remove the NON EMPTY clauses should be removed.
C.
You should replace the CHAPTERS axis with the ROWS axis
D.
You should replace the CHAPTERS axis with the SECTIONS axis