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.
| Author |
Topic |
|
Vulcanoro
Starting Member
1 Post |
 Posted - 2006-09-07 : 03:01:14
|
| I have a multivalue parameter ( indented to look like a hierarchy ) based on a Time Dimension ( Year, HalfYear, Quarter, Month, Week, Day ) and a matrix with columns based on the same Time Dimension - 6 columns based on the each level from the Time Dimension. The columns from the matrix have the drill down functionality implemented. It is possible to hide upper levels from the matrix, based on the selection of the parameter and in the same time keep the drill down functionality ? I give an example: if the user selects Quarter 1 and Quarter 3, i want to hide the columns Year and HalfYear from the matrix and i want to be able to drill down on the selected values ( Quarter 1, Quarter 3 ). |
|
|
|
|
|
Hide columns matrix based on parameter selectio