Implementing Access to SQL Server Analysis Services 2008 by Parameterization feature on SQL Server Reporting Services 2008

This posting, I would like to show you how you could create report parameter on SQL Server Reporting Services using SQL Server 2008 product. I meet most report commonly access to OLTP database and now with great integration between reporting services and analysis services, it is very possible and very easy to parameterize value to query cube.

For purpose demo of this sample, I use Sales Reason Comparison report, you can download from Codeplex. After downloading, you extract the zip files to a particular location (let’s say : c:\ SqlServer2005_SP2). Then go to C:\SqlServer2005_SP2\ Report Samples\AdventureWorks Sample Reports, and double click report sample project.