Which three actions should you perform in sequence?

DRAG DROP
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.)

Answer: See the explanation.

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 mode
2. In the Report Data pane, right-click on a dataset created from a SQL Server Analysis
Services data source type, and then clickQuery. The MDX query designer opens in Design
mode.
3. Drag a dimension to the filter area and drop it on the first cell in theDimensioncolumn.
4. In theHierarchycolumn, choose a value from the drop-down list.
5. In theOperatorcolumn, choose an operator for the drop-down list.
6. In theFilter Expressioncolumn, select individual values from the drop-down list, or
click theAllmember to choose all values.
7. In theParameterscolumn, select the check box to create a report parameter.
8. ClickRun.
After 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. ClickDesignto toggle back to Design mode.
9. Click OK.
* To create a dataset
1. In the Report Data pane, right-click the name of the data source, and then clickAdd
Dataset. TheQuerypage of theDataset Propertiesdialog box opens.
2. InName, type a name for the dataset or accept the default name.
3. In Data source, select the name of an existing shared data source, or click New to
create a new embedded data source.
4. Select a Query type option. Options vary depending on the data source type.
1. Select Text to write a query using the query language of the data source.
2. Select Table to return all the fields in a relational database table.
3. Select StoredProcedure to run a stored procedure by name.
5. In Query, type the query, stored procedure, or table name. Alternatively, click Query
Designer to open the graphical or text-based query designer tool, or Import to import the
query from an existing report.
In 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.
6. In Timeout, type the number of seconds that the report server waits for a response
from the database. The default value is 0 seconds. When the time out value is 0 seconds,
the query does not time out.
7. Click OK.
The dataset and its field collection appear in the Report Data pane under the data source
node.
Reference: 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)