Wednesday, 19 October 2016

Dropdown selectors with multi-select checkboxes

This is a very common requirement from the users but unfortunately this feature is not available in Microstrategy till version 10.2. As this was a critical requirement for the business we tried different ways to implement this with the help of some workarounds. Finally one particular implementation was very similar to the actual requirement and the client also liked the idea.  Steps are as follows

1.         Create a simple textbox and named it after the required filter field.

2.         Create a panel stack and marked it as information window. Information window is an in-built functionality in MSTR. It’s exactly like normal panel stack but it’s not visible by default. We have to target this information window from some other object like textbox, grid, graph etc so that when user clicks the object the panel stack appears as a pop-up.

3.         Add the required checkbox filter inside the information window.

4.         Target the information window from the text box created in step 1.

Now when the user clicks on the filter text box a popup appears containing the multi select checkbox filter.

We can also utilize the additional space we got in the pop-up by adding multiple related filters in it. 

No comments:

Post a Comment