MicroStrategy ONE
Security filter qualifications in Query Builder
With the Query Builder Security Filter Dialog you can create security filter qualifications to insert into the Query Builder definition. These security filter qualifications allow Query Builder to recognize security filters applied to users and user groups qualifying on certain attributes. Follow the procedure in, Steps to access the Query Builder Security Filter Dialog to access this interface.
Security filters are not detected and do not function with Query Builder in the same way that security filters work with normal reports. Before you begin creating security filter qualifications in Query Builder, you should be familiar with the information on security filters in Query Builder addressed in the Advanced Reporting Help.
The Query Builder Security Filter Dialog includes the following panes:
-
Object Browser: You can use the drop-down list and the folder list below to browse the project and select the attributes to include as an attribute mapping or an ignored attribute.
You can also use the Find drop-down list to enter or select keywords to search for attributes in the project. For example, you can enter "Customer" to return a list of all attributes containing the string "Customer" in their names.
-
Attribute Mapping: The Attribute Mapping pane is located on the upper right side of the Query Builder Security Filter Dialog. This is where you map attributes to columns in the query to connect to security filter qualifications. For every attribute qualification to be recognized in security filters, you need to provide the following:
-
Attribute: The attribute you select to be connected to a Query Builder column and recognized in security filters. For example, if your project has security filters for the attribute Customer, select the Customer attribute.
-
Form: The attribute form type such as ID, DESC, and so on to qualify on. For example, if security filters qualify on the Customer ID column, select ID from the Form drop-down list.
-
Table: The table in the query to locate the attribute form column. You can choose from any table that is included in your query. For example, if you selected the Customer attribute and the LU_CUSTOMER table is included in your query, select LU_CUSTOMER from the Table drop-down list.
-
Column: The column from the table selected to map to the attribute form. For example, if you have selected the ID form of the Customer attribute, select CUSTOMER_ID from the Column drop-down list.
-
Ignored Attributes: The Ignored Attributes pane is located below the Attribute Mapping pane in the Query Builder Security Filter Dialog. This is where you specify attributes that may be ignored by the Engine when the report is being generated, even if they appear in a security filter qualification. This option can be useful if your Query Builder report does not include attributes that are included in security filters. By ignoring attributes that are not included in the Query Builder report, it allows security filters to apply qualifications for mapped attributes without creating any security holes.
Select the Allow security filters with Top and Bottom levels to be evaluated based on the select level of this report check box to explicitly define the Select Level of the report (displayed in the line just above this option) as the true level of the data that is retrieved for the report when Top and Bottom criteria are evaluated.