//Bypassing Security Filters In MicroStrategy – Display Comparatives Across Hierarchy Levels

Bypassing Security Filters In MicroStrategy – Display Comparatives Across Hierarchy Levels

Security filters in MicroStrategy are useful in implementing data-level security but they are applied globally, which can be a challenge. In this blog post, I explain how to bypass security filters to access the functionality you need in Microstrategy.

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:

Security Filters In MicroStrategy

 

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.

Security Filters In MicroStrategy

 

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.

Security Filters In MicroStrategy

Security Filters In MicroStrategy

 

2. Then I created a report using those level metrics and the report level as per the dashboard requirements.

 

Security Filters In MicroStrategy

 

3. Next, I configured the Data Mart settings on that report to have it export the result to a database table.

Security Filters In MicroStrategy

 

4. Then I created a Freeform SQL Report to read that exported data. You need to have a compatible level on the report to be able to do this.

Security Filters In MicroStrategy

Security Filters In MicroStrategy

 

5. Finally, I used that Freeform SQL Report as an additional data source for the dashboard along with other normal reports that the dashboard is based upon.

Security Filters In MicroStrategy

 

Since this is a freeform SQL report with no link to the attribute used in the security filter, the security filter logic does not get applied to this report. Hence enabling me to create the dashboard where the comparative metrics are shown at a higher-level in the organizational hierarchy than the security filter allows.

Do you have a request for a MicroStrategy tip? Send us your request and you may see it featured here! View older MicroStrategy blog posts here.

By | 2017-02-10T15:33:27+00:00 June 14, 2016|Categories: Business Intelligence|Tags: |

Receive more posts just like this, right in your inbox!

↓ Sign up for emails with the latest from Smartbridge.

Sign up for emails
Or add this feed URL to your favorite blog reader.