Forum Discussion

Rev's avatar
Rev
New Contributor II
3 years ago

Combo Box Multiselect parameter list - Advanced requirement

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

dashboards

3 Replies

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    3 years ago

    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:

     

     

  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor
    3 years ago

    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

  • EricOsmanski's avatar
    EricOsmanski
    Icon for OneStream Employee rankOneStream Employee
    3 years ago

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