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. 

Your request could not be processed due to a server error" occurs while adding recipients to an e-mail subscription in MicroStrategy Web 10.x

In MicroStrategy Web 10.x, users may get an error message while creating or editing email subscriptions.  This document explains a possible cause of this issue and how it can be resolved.

Email Subscription.png

This is a known issue in MicroStrategy 10.x.  The issue occurs because there are contacts referencing users who have been deleted from the metadata.  When a user presses the To button, an Access Control List (ACL) check is run to get the possible contacts.  Contacts inherit their ACL from the user they are linked to, so since the user associated with the contact has been deleted, the ACL check fails

Deleting the invalid contacts will resolve the issue.  If assistance is needed in identifying the invalid contacts, please contact MicroStrategy Technical Support.