MicroStrategy ONE

Creating a view filter

You can create a view filter by defining a condition that is based on any attribute or metric on your report. While attribute and metric qualifications both restrict the data displayed on the report, they are created and defined in slightly different ways.

You can create a view filter in any report, as long as you have an OLAP Services license. This includes reports connected to an Intelligent Cube, reports returning information directly from a data warehouse, Freeform SQL reports returning information from an Excel spreadsheet, and so on.

The following topics provide examples of using view filters on reports returning information directly from a data warehouse.

Refer to the following topics to create a view filter that contains attribute and/or metric qualifications:

  • Filtering data based on business attributes: Using view filters based on business attributes, you can view a subset of report data that focuses on the business data that you are interested in.

    When creating an attribute qualification for a view filter, you can either qualify on a list of attribute elements, or you can qualify on attribute forms:

  • Qualifying on a list of attribute elements is achievable by using the In list or Not in list operators and selecting from a list of attribute elements. For basic steps to filter on a list of attribute elements, see the procedure To create a view filter with an attribute qualification.

  • Qualifying on attribute forms is achievable by using the Where operator and selecting from available attribute forms. For information on qualifying on attribute forms, see Filtering based on attribute form qualifications.

  • Filtering data based on metrics: Using view filters based on metrics, you can view a subset of report data that focuses on the data values and ranges you are interested in.

  • Joining view filter qualifications with operators: When a view filter has multiple qualifications at the same output level, they are always joined by operators. When qualifications are joined, operators govern the interaction between the different filtering conditions.

  • For information about creating view filters in documents, see Creating view filters in Grid/Graphs on documents.