You are developing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database and a SQL Server Analysis Services (SSAS) cube. The cube contains a date dimension and…

Build reports

Question

You are developing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database and a SQL Server Analysis Services (SSAS) cube. The cube contains a date dimension and other dimensions. The report design includes two report parameters named StartDate and FinishDate as shown in the following diagram. The Data Type property of the parameters is set to Date/Time. You need to create the dataset based on the SSAS cube. You also need to ensure that the dataset is filtered by the existing report parameters. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Exhibit

Explanation

The correct sequence of actions is: 1. Create a data source using the Microsoft SQL Server Analysis Services connection type. 2. Create a dataset with a parameterized filter using a hierarchy from the date dimension that uses the Range (Inclusive) operator. Do not close the Dataset Properties window. 3. Select the Parameters page and then assign an expression to the parameter value to convert the report parameter values to the appropriate date dimension hierarchy member keys.

Topics

#SSAS data source#MDX dataset#report parameters#date filtering

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice