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.)
Select and Place:
Answer: 
Explanation:
Box 1:
Box 2:
Box 3:
Note:
* In Reporting Services, a dataset is based on an existing a data source. A dataset specifies a
query, query parameters, filters, and a field collection. You can also specify data options, such as
case, collation, kanatype, width, and accent, for the data retrieved from the data source. For more
information, see Understanding Report Datasets.
To create a dataset, you must have defined an embedded or shared data source.
* When you deploy Reporting Services, a set of data processing extensions are automatically
installed and registered on both the report authoring client and on the report server to provide
access to a variety of data source types . SQL Server 2008 Reporting Services (SSRS) installs the
following data source types: Microsoft SQL Server, Microsoft SQL Server Analysis Services,
Oracle, SAP NetWeaver BI, Hyperion Essbase, Teradata, OLE DB, ODBC, and XML.
* To define a query parameter in MDX in Design modeAfter you run the query, clickDesignon the
toolbar to toggle to Query mode to view the MDX query that was created. Do not change the query
text in Query mode if you want to continue to use Design mode to develop the query. ClickDesign
to toggle back to Design mode.
* To create a datasetIn a few cases, the field collection specified by the query can only be
determined by running the query on the data source. For example, a stored procedure may return
a variable set of fields in the result set. Click Refresh Fields to run the query on the data source
and retrieve the field names that are needed to populate the dataset field collection in the Report
Data pane. The field collection appears under the dataset node after you close the Dataset
Properties dialog box.
The dataset and its field collection appear in the Report Data pane under the data source node.
How to: Create a Dataset (Reporting Services); How to: Define Parameters in the MDX
Query Designer for Analysis Services (Report Builder 3.0 and SSRS)
