O'Reilly logo

Microsoft® SQL Server® 2008 Reporting Services Step by Step by Stacia Misner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required