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?

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?

Accepted Answer

B. You should select the ROWS axis

Answer

A. You should delete the NON EMPTY clauses.

Answer

C. You should select the CHAPTERS axis

Answer

D. You should select the SECTIONS axis

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…

Question

Options

How the community answered

Community Discussion