Skip to Content
Author's profile photo Former Member

Multi-selection of parameters in Dashboards

In one of the ongoing BO implementation projects, we had a peculiar requirement of allowing users to select multiple parameters. In our case, we had to select multiple planners and filter dashboard data accordingly.

Apart from the List Builder component, there is not much scope in the default Xcelsius components to satisfy this requirement. List Builder has its own pros and cons. The user is not very motivated to use List Builders because of the real estate it occupies and its design. 

We bundled some standard components and created a multi-select. It looks like this:


We have used a combination of multiple check boxes put inside a canvas. This canvas “drops-down” when the “Select Planner” button is clicked and “hides” when the cross button is clicked. We have driven the dynamic visibility of the canvas on the button interactions.

Individual checkboxes are capable of data insertion. These inserted values can be used to drive the excel logic further. An “ALL” checkbox is provided at the top of the stack that supersedes all the other selections.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Kailas Kurup
      Kailas Kurup

      Nice and clean way of multi-selection. Looks very clean. Keep blogging these kind of work around.

      This will come handy when you know the actual number of check boxes to be used. If the number of check boxes is dynamic or random, is there a way we can handle it?

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hey Kailas,

      Flex development seems to be the answer for dynamic number of check boxes. 🙂 I have not tried it though..



      Author's profile photo Former Member
      Former Member

      Thank you for the post, Prasanna, very interesting.

      Is it possible to for you to publish the sample .xlf that demonstrates this technique?

      Would be great to see how it's done.



      Author's profile photo Suman Thangadurai
      Suman Thangadurai

      Major hurdle i have faced in dashboard during development against the multiple selection, lot of people have already raised voice on this to SAP in Idea place

      More selectors that support multiple selections : View Idea, still no answers from them. This is nice and good workaround, provide us the sample xlf which can help to understand the design.

      Keep Rocking!!! 😎

      Author's profile photo Former Member
      Former Member

      Dear Sir (Prassanna)

      I would be thankful if you could please provide the XLF file for the same.