O'Reilly logo

Microsoft® SQL Server® 2008 MDX Step by Step by C Ryan Clay Bryan C Smith and Hitachi Consulting

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

Designing the Dataset

With the connection to a data source defined, Reporting Services can now retrieve data for use in a report. In Reporting Services, the linking of a query to a particular data source and metadata about the data returned is referred to as a dataset.

Regardless of the data source employed, all Reporting Services datasets utilize a standardized structure for making data available within a report. The process of translating an Analysis Services cell set into this standard dataset structure is loosely referred to as data flattening.

The mechanics of data flattening are not as important as the constraints this process imposes on your MDX queries. For data flattening to work, MDX queries must employ either one or two axes. The first ...

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