Exam 70-466 topic 1 question 70 discussion

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.)
Select and Place:

Suggested Answer:
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
1. In the Report Data pane, right-click on a dataset created from a SQL Server Analysis Services data source type, and then click Query. The MDX query designer opens in Design mode.
2. Drag a dimension to the filter area and drop it on the first cell in the Dimension column.
3. In the Hierarchy column, choose a value from the drop-down list.
4. In the Operator column, choose an operator for the drop-down list.
5. In the Filter Expression column, select individual values from the drop-down list, or click the All member to choose all values.
6. In the Parameters column, select the check box to create a report parameter.
7. Click Run.
8. After you run the query, click Design on 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. Click Design to 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 click Add Dataset. The Query page of the Dataset Properties dialog box opens.
2. In Name, 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.
✑ Select Text to write a query using the query language of the data source.
✑ Select Table to return all the fields in a relational database table.
✑ Select StoredProcedure to run a stored procedure by name.
1. 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.
2. 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.
3. 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.
4. Click OK.
5. 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)