Develop Reporting Services reports using Analysis Services data; a SQL Server 2008 technical case study

By | June 25, 2010

For anyone who works with analysis services and reporting services the SQLCAT team has release a great whitepaper:

Providing strong customer service has helped this customer become the largest commercial bank in Thailand. Always looking for new ways to enhance the services it provides, the bank wanted to study its customer data to help it better determine customer needs, but a reporting system based on manual report development in spreadsheets by using mainframe data (provided in text files) proved cumbersome.  The customer wanted to implement a business intelligence solution on the Microsoft® SQL Server® 2008 BI suite, including SQL Server Analysis Services and SQL Server Reporting Services, to ensure the proposed solution could meet their customer requirements of the Balance Scorecard (a dynamically updated dashboard of Key Performance Indicators (KPIs)), dynamic reports, and dynamic security. The customer has gained a better view into its operations and deeper customer knowledge since deploying its BI solution.This document focuses on the technical concepts and techniques we used to implement reports with SQL Server 2008 Reporting Services, using an Analysis Services cube as the data source.

It has taught me a lot of new things i did not know .. and I work with this stuff almost every day .. it gives also a great example of how SSRS and SSAS are not really aligned together since you have to do a lot of manual work and change the default MDX to custom MDX.

Check it out here.