02-08-2023 01:59 AM - last edited on 05-02-2023 10:37 AM by JackLacava
Hi. I've created a multiselect parameter where the selection will be passed into another parameter.
Param1 -> Multiselect combo box(Eg: Level 2 members selected as "US" and "ASIA")
Param2 -> Should be populated based on the Param1 selection(Eg: Level 4 members "NY","PH","AZ" of "US" and "IND,SG,TH" of "ASIA" should be listed)
Below options dint work.
U1#Root.List(|!Param1!|).Base
U1#|!Param1!|.Base
Need suggestions
02-08-2023 03:50 AM
Hi Rev,
To make it work with even more parameters, Try to put each parameter in its own dashboard page/frame and use the refresh. And add those embededed to your main. When you select the Param1 it shoudd refresh the param2 dashboard.
Cheers
02-08-2023 08:34 AM
Multi Select returns the result as "US,ASIA" so that is why the member filter being used in the 2nd parameter doesn't work. You should try passing the 1st parameter to an XFBR String which parses out "US,ASIA" and then returns "U1#US.Base,U1#ASIA.Base".
02-08-2023 08:38 AM - edited 02-08-2023 08:41 AM
The first syntax works for me on v.7.2:
the top component is a multiselect combobox. It's not visible in the screenshot, but the base members of 2019 also appear.
One thing to remember is that you need to refresh components (in this case a cubeview) to see them use the updated values, the system is not fully reactive. You can also refresh the page, which will also work: