You work as a Database Administrator (DBA) at a company named ABC.com.
A Windows Server 2012 server named ABC-SSAS01 runs SQL Server 2012 Analysis
Services (SSAS). Another Windows Server 2012 server named ABC-SSRS01 runs SQL
Server 2012 Reporting Services (SSRS).
ABC-SSRS01 has a report that company users use to query a cube on ABC-SSAS01.
Users filter the report by a single date using Date/Time data type report parameter. The
Multidimensional Expressions (MDX) query for the dataset cannot be filtered by directly
using the report parameter.
You need to ensure that a value entered by the user can be used to filter the report data.
Which two of the following actions would require the least amount of development effort to
achieve this goal? (Choose two)
A.
Use the StrToSet MDX function that accepts the value of the report parameter in a subcube
subquery.
B.
Use the same format as the date dimension member key value in an expression and use that
for the report parameter Value property.
C.
Modify the dataset query Name property to point to a name value for each date dimension
member.
D.
Create a new dataset query using T-SQL (Transact-SQL).
E.
Modify the query parameter of the dataset.
F.
Query the cube using the OPENROWSET function and output the results to the T-SQL query
then modify the format of the report parameter using the Convert function.
Explanation:
B, E Correct