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

Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.