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.
ok
Best is to add filter in Dataset but this is not in available options so A is correct. mentioned in question to choose best from option