How-to Passing parameter for Analysis Services using MDX from Reporting Services

In order to navigate from one report to another report that with parameter (Create a report with parameter) the developer will add a link by performing the following steps:

1. Right click the Textbox on the report –> Properties

2. Choose the Navigation tag -> Select the report under Jump to report:

3. Click the Parameters button

4. Choose the Parameter Name and Parameter Value in the Parameters dialog

You can now preview the report and navigate to the report that you created with parameter.

This will be fine if the report that you wish to navigate to is not extracted from OLAP Analysis Services. If the parameterized report is created using OLAP Analysis Services then the parameter may not be functioning well or not functioning at all.

How to give this resolve then? Well, this is what you need to do. You still perform the same steps as above except you need to type in the full Dimension like this:

="[Dim Time].[Calendar Year].&[" + Fields!Calendar_Year.Value + "]"

In order to learn more about Analysis Services go to Analysis Services Developer InfoCenter.

The solution is in page 250 of the Microsoft Press SQL SERVER 2005 Analysis Services Step by Step.

Company that provides full Business Intelligence solutions:
NewsPage Pte Ltd
http://www.newspage.com.sg

About these ads