Skip to main content
R
Rev
February 8, 2023

Combo Box Multiselect parameter list - Advanced requirement

  • February 8, 2023
  • 3 replies
  • 0 views

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

N
NicolasArgente
February 8, 2023

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

E
EricOsmanski
February 8, 2023

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

J
JackLacava
February 8, 2023

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

 

 

Terms & ConditionsAccessibility statement