web analytics

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 type Date/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 expression
that uses the same format as the date dimension member key value.
B. Edit the dataset query parameter. Change the Name property 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.
Answer: A