Combo Box Multiselect parameter list - Advanced requirement

Rev
New Contributor

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

3 REPLIES 3

NicolasArgente
Valued Contributor

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

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.

EricOsmanski
Valued Contributor

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".

JackLacava
Community Manager
Community Manager

The first syntax works for me on v.7.2:

JackLacava_4-1675863491620.png

JackLacava_5-1675863652986.png

 

JackLacava_0-1675863205817.png

JackLacava_1-1675863248247.png

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:

JackLacava_2-1675863365148.png