Develop Reporting Services reports using Analysis Services data; a SQL Server 2008 technical case study
Summary: 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.
Writers: Nicholas Dritsas, Nopparat Leelavanich
Contributors: Artich Asawachaiyawong, Sairung Inlert
Technical Reviewers: Carl Rabeler, Robert Bruckner
Published: June 2010
Applies to: SQL Server 2008, SQL Server 2008 Analysis Services, and SQL Server 2008 Reporting Services