70-460 · Question #1
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…
The correct answer is A. Edit the dataset query parameter. See the full explanation below for the reasoning.
Question
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.)
Options
- AEdit the dataset query parameter.
- BEdit the dataset query parameter.
- CEdit the dataset query parameter.
- DChange the dataset query to Transact-SQL (T-SQL).
How the community answered
(60 responses)- A85% (51)
- B3% (2)
- C3% (2)
- D8% (5)
Community Discussion
No community discussion yet for this question.