Microsoft® SQL Server® 2008 Reporting Services Step by Step

Chapter 7 Quick Reference

To	Do This
Create an Analysis Services shared data source	In Solution Explorer, right-click the Shared Data Sources folder, select Add New Data Source, name the data source, select Microsoft SQL Server Analysis Services in the Type drop-down list, click Edit, provide a server name, and select an Analysis Services database name.
Use the MDX query designer in Design Mode to build a query	In the Report Data window, select New, Dataset, Query Designer, expand folders in the Metadata pane, and drag items from the Metadata pane to the Data pane.
Filter the Analysis Services dataset	In the MDX query designer, in the Filter pane, select a dimension in the Dimension drop-down list, select a hierarchy in the Hierarchy drop-down list, ...