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?
A.
You should delete the NON EMPTY clauses.
B.
You should select the ROWS axis
C.
You should select the CHAPTERS axis
D.
You should select the SECTIONS axis