MicroStrategy ONE
Filtering data in Query Builder reports with qualifications
You cannot use existing filters in a Query Builder report; however, you can filter report data by including a qualification that will be used in either the WHERE or HAVING clause of the SQL statement. The Conditions pane (the middle pane on the right) of the Query Builder Editor allows you to create filter qualifications for your queries.
If a qualification does not contain an aggregated column expression, it is included in the WHERE clause and appears at the top of the Conditions pane. Qualifications within the WHERE clause of a SQL statement are evaluated before any aggregation is performed.
If a qualification contains an aggregated column expression, it is included in the HAVING clause and appears at the bottom of the Conditions pane. Qualifications within the HAVING clause of a SQL statement are evaluated after any aggregation statement is performed.
You can also include security filter qualifications in your Query Builder reports. Including security filter qualifications allows you to adhere to your system security policies for viewing data. For steps to insert a security filter qualification in a Query Builder report, see Steps to insert a security filter qualification in Query Builder.