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 |
|
asqldeveloper
Starting Member
17 Posts |
 Posted - 2008-04-15 : 11:01:17
|
| HiI am doing report development against cube (OLAP) and I have several parameters. My second parameter is to be filtered based on the first parameter (kinda like cascading), but how do we achieve this in a cube environment? Lets say I have param1 and param2 in a dataset. I want Param2 to show the locations only based on what I select in Param1. Hope this helps. If you have questions, please let me know. |
|
|
pravin14u
Posting Yak Master
246 Posts |
Posted - 2008-04-16 : 05:51:45
|
| Some thing like this="WITH MEMBER [Measures].[Product_Key] AS '[Product].CurrentMember.Properties(""Key"")' " +"MEMBER [Measures].[Product_Name] AS '[Product].CurrentMember' " +" SELECT {[Measures].[Product_Key],[Measures].[Product_Name]}ON COLUMNS, " +"{DESCENDANTS([Product].[" +PARAMETERS!Sub_Product_Group.Value + "], [Product].[Product Desc] " +")} ON ROWS FROM [Stock Detail] "Prakash.PThe secret to creativity is knowing how to hide your sources! |
 |
|
|
|
|
|
Cascading Parameters in MDX