Forum Discussion

Ashlee's avatar
Ashlee
New Contributor III
12 months ago

How do I take an existing combo box and make it multi-select?

We have a combo-box for entity selection on a dashboard however, it only allows a user to select 1 entity at a time. How do I make that comb-box open to multi-select 2 or more entities? I do not see a multi-select true or false option on the combo box form.

Parameter:

Combo Box:

In Dashboard:

 

 

 

 

  • sameburn's avatar
    sameburn
    Contributor II

    Hi. Please check formatting section of the combo box component (click Display Format ellipsis).  There is a multi select option there e.g True or False 

    • sameburn's avatar
      sameburn
      Contributor II

      Hi. As JackLacava  said we don't know your setup. So a lot of variables at play here.

      However from a theoretical point of view you can pass the resukt of that parameter into a list e.g E#Root.List([|!parameterValue!|]) and then pass that into your CV rows / columns

  • Ashlee's avatar
    Ashlee
    New Contributor III

    Thank you! The multi-select is there. When I select multiple entities the data disapears from the report. Do I need to add a business rule that tells the report to add values together as multiple entities are selected? 

     

    • JackLacava's avatar
      JackLacava
      Honored Contributor

      Chances are that your report is simply placing that Parameter in the Cube View POV. You cannot have multiple members there, so it breaks.

      You will probably have to restructure the Cube View, at a minimum placing Entities on rows or columns, maybe adding some calculated rows for totals (look up CVC and CVR functions). No Business Rule required.

      A more complex alternative is to use a Pivot Grid instead of a CV, but you will need to create a Data Adapter to feed it, and that is a bit more complicated (not necessarily requiring rules, but you'll need to know your way around Data Adapters).