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

Creating an Analysis Services Dataset

Before you can create an Analysis Services dataset, you must define a data source that stores the connection information for the Analysis Services server and database. Then, when you create the dataset, you provide an MDX query either by using a graphical interface to construct the query or by typing the MDX query directly into the query designer.

Creating an Analysis Services Data Source

The process to create an Analysis Services data source is very similar to building any other data source. Most often, you will select the Microsoft SQL Server Analysis Services data source type. This provider allows you to use the MDX query designer, which simplifies the process of constructing an MDX query, particularly if ...

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