Filters

No PostgreSQL specific customizations were made for this feature.

A filter is a MicroStrategy object that specifies the conditions data must meet to be included in report results. Using a filter on a report narrows the data to consider only the information that is relevant to answer your business question, since a report queries the database against all the data stored in the data warehouse. A filter is composed of at least one qualification, which is the actual condition that must be met for the data to be included on a report. Multiple qualifications in a single filter are combined using logical operators. A filter is normally implemented in the SQL WHERE clause. You could create stand-alone filter or report filter.

A stand-alone filter is a filter created as an independent MicroStrategy object. The stand-alone filter can then be used on many different reports, as well as on metrics and other objects. However, in MicroStrategy, filters can also be created as part of a given report, at the same time the report itself is being created. These kinds of filters are generically called report filters.

For example, this is a local filter defined inside of a normal report:

You could also create a stand-alone filter and add it to a report using the following workflow:

The filter is implemented by the SQL WHERE clause:

select a11.PS_SUPPKEY S_SUPPKEY,
(sum(a11.PS_AVAILQTY) + sum(a11.PS_SUPPLYCOST)) WJXBFS1
from PARTSUPP a11
where a11.PS_SUPPKEY = 1
group by a11.PS_SUPPKEY

See the Basic Reporting Help for more information.