O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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

Using MDX with SSRS and PerformancePoint Server

MDX is an important part of any serious data warehousing application. However, in the world of fancy dashboards and reports, MDX is only as valuable as the reporting tools that support it. Reporting Services and PerformancePoint Server are two popular tools for producing end-user output in a data warehousing environment, and both support the incorporation of MDX to produce a truly flexible reporting experience. At this point, let’s take a quick look at how you can use MDX with the two tools.

Using MDX with SSRS 2008

SSRS 2008, like its predecessor (SSRS 2005), allows report authors to create reports against SSAS OLAP cubes. In some instances, you can use the built-in graphical query tool to design ...

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