Cascading Parameter setting in SSRS using MDX
Hi,
We have a requirement to display Time values as cascaded values based on a Time selection filter as explained below :
1) "Time Selection" is a custom parameter that will hold values Year, Month and Week
2) When 'Year' is selected, another parameter namely "Time" must display 2 completed years i.e., 2011 and 2010.
Similarly if 'Month' is selected, "Time" must display 24 completed months and for Time Selection = Week, 52 completed weeks must appear for selection in the "Time" filter.
Please note that we are sourcing a cube in our reports and hence we will want to populate both parameter value and parameter caption. Also, there is no hierarchy built in the cube for these members.
Kindly help me approach this requirement.
In addition, is it possible to change the name of filter "Time", i.e, display filter name as Year/Month/Week based on the Time Selection? As far as my knowledge in SSRS goes, the name of the filter cannot be changed dynamically. Please correct
me if otherwise.
Thanks in advance.
Regards,
Bhavana
July 2nd, 2011 12:49pm


