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