Security filters in MicroStrategy are useful in implementing data-level security in MicroStrategy but they are applied globally across a project. This tends to be a challenge because sometimes there are exceptions or use cases where the security filter should not be applied.
For example, if you want to provide benchmark metrics that are at higher levels in the organizational hierarchy than that of the security filter, as illustrated in the graphic below:
What would you do if you have a requirement like this? The dashboard screenshot below shows an implementation where I achieved that functionality and was able to bypass the security filter by using a workaround.
Here is the procedure I followed to achieve the security filter bypass:
1. I defined Level Metrics for the level higher than the security filter level at which I wanted to display the metrics at. In this case it’s Zone level.