Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 Cascading Parameter in Reporting service using Cube

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-07-10 : 09:09:51
writes "Hi,

I would like to implment the Cascading parameter features in SQL server Reporting serivce 2005. The cascading should be run on OLAP Cube.

the business scenario is as follows:

I need to calculate the AFR(annual failure rate) on the based of Year,Month,Country and Product Line.

I have the dimension for each of them. Like From Time dimension we can have Year and Month.
For the Geography we can have Country name.
and from Product. we can have Product Line, and on the based of selected product Line we will get respective Product Family and so on.

I need the MDX code where I can use this features.

Can somebody help me on this.

Thanks
Sodi."
   

- Advertisement -