Security Filter

                              

                                    Security Filter

A security filter is a filter object that you assign to users or groups to restrict the result set when they execute reports or browse elements.

Security filters enables you at MicroStrategy level, What warehouse data users can see.

Criteria specified by the security filter is added to the where clause of every SQL pass.

Example: Two regional manager have their own security filters, according to the region that they manage. One with Northeast and other with southeast..

 If these two users with different security filters run the same report, they may get different results based on the criteria defined in their security filters.

Prerequisites

•The security filter you want to assign to a user or group must already exist in MicroStrategy Developer.

•To assign security filters, you must have the necessary privileges.

Lets run a report without security filter.

                 

How to create security filter-->

• Go to the project where you want to create security filter.

• Go to Project Objects and click on MD security filters.All security filter should be placed in this folder.

• Create New and choose security filter.

             

• Below window will appear.

• Apply filter on the attribute on which you want to create filter.

• Choose the region whose data you want to show to the user/group.

• Go to user manager then search the user/group to which you want to assign security filter and edit the user/group.

• Drag the required security filter to the right hand side.

• Now execute the same report with security filter of Northwest and see the difference.