Creating Report Datasets from SQL Server Analysis Services (Report Builder 2.0)
Report Builder 2.0 provides a data processing extension that supports report data retrieval from a Microsoft SQL Server Analysis Services data source. This data processing extension retrieves dimensions, hierarchies, levels, key performance indicators (KPIs), measures, and attributes from a Microsoft SQL Server Analysis Services cube for use as report data.
After you have connected to an Analysis Services data source, you can define a dataset that specifies the report data to retrieve during report processing by building Multidimensional Expression (MDX) queries. You can use the MDX graphical query designer browse and selecting from the underlying data structures on the data source. After you build a query, you can run the query to see sample data in the results pane. The query results are automatically retrieved as a flattened rowset, ready to be used as report data.
The query designer analyzes the query to determine the dataset fields. You can also manually edit the dataset field collection in the Report Data pane. For more information, see How to: Add, Edit, or Delete a Field in the Report Data Pane (Report Builder 2.0).
The text-based query designer is read-only for this data source. You cannot import .mdx files and use them directly in a query. You can import queries from existing reports that use Analysis Services data sources. For more information, see How to: Retrieve Data from an Analysis Services Cube (MDX) (Report Builder 2.0).
For more information about the user interface, see Analysis Services MDX Query Designer User Interface (Report Builder 2.0).