Introduction This article is aimed at report developers who are used to develop reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Server Reporting Services 2008 with data coming from an OLAP cube running on SQL Server Analysis Services 2008. The OLAP [...]
Click here to see the original post

For this example I’ll be using the Adventure Works cube running on SQL Server Analysis Services 2008 and Reporting Services 2008. In case you don’t have the AdventureWorks databases and cubes yet, they’re available at CodePlex. Scenario The sales department has asked for a report that displays the number of product items sold during a selected period.  As [...]
Click here to see the original post