You need to ensure that the report displays data filtered by the user-entered value

You are modifying a SQL Server Reporting Services (SSRS) report for a SQL Server Analysis Services (SSAS)
cube.
The report defines a report parameter of data typeDate/Time with which users can filter the report by a single
date.
The parameter value cannot be directly used to filter the Multidimensional Expressions (MDX) query for the
dataset.
You need to ensure that the report displays data filtered by the user-entered value.
You must achieve this goal by using the least amount of development effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are modifying a SQL Server Reporting Services (SSRS) report for a SQL Server Analysis Services (SSAS)
cube.
The report defines a report parameter of data typeDate/Time with which users can filter the report by a single
date.
The parameter value cannot be directly used to filter the Multidimensional Expressions (MDX) query for the
dataset.
You need to ensure that the report displays data filtered by the user-entered value.
You must achieve this goal by using the least amount of development effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A.
Edit the dataset query parameter. Change the Value property of the report parameter to an expressionthat
uses the same format as the date dimension member key value.

B.
Edit the dataset query parameter. Change the Nameproperty of the dataset query parameter so that it
points to a name value for each date dimension member.

C.
Edit the dataset query parameter. Create a subcube subquery that uses the StrToSet MDX function and
accepts the report parameter value.

D.
Change the dataset query to Transact-SQL (T-SQL).Use the OPENROWSET function to query the cube.
Output the cube results to the T-SQL query and use a Convert function to change the report parameter
value into the same format as the date dimension member.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


MicrosoftAnswer

MicrosoftAnswer

OK