MicroStrategy ONE
View filters versus report filters
While they both share some filtering capabilities, view filters and report filters also offer their own unique filtering features that fit different filtering requirements.
The main difference between report filters and view filters is how they are evaluated by the system.
Report filters are a standard MicroStrategy reporting feature that enable you to filter the data retrieved from the data source. Since report filters are evaluated by querying the data source, report filters can perform various types of advanced qualifications, use prompts in qualifications, filter on objects not included in the report, and so on. For more information on report filters in general, refer to About filtering data on-the-fly in a report and Creating a filter within a report.
View filters are an OLAP Services feature that enable you to filter the data available on a report after its data has been retrieved from a data source. View filters are evaluated without having to query the data source. While this enables view filters to be evaluated without the overhead of querying the data source, it also means that view filters only have access to the data available on the report. Due to this limited access to data, view filters cannot perform all of the advanced qualifications possible with report filters.
The table below compares the available features and feature requirements of view filters and report filters:
|
Features and Feature Requirements |
Available in View Filters |
Available in Report Filters |
|---|---|---|
|
Attribute element and attribute form qualifications |
Yes |
Yes |
|
Simple metric qualifications |
Yes |
Yes |
|
Relationship qualifications |
No |
Yes |
|
Joint element list qualifications |
No |
Yes |
|
Custom expression qualifications |
No |
Yes |
|
Can define filtering at report run time by including a prompt in a qualification |
No |
Yes |
|
Can filter on objects not included in the Report Objects pane |
No |
Yes |
|
Can filter on objects included in the Report Objects pane, but not included in the report |
Yes |
Yes |
|
Evaluated without re-executing SQL and querying the data source |
Yes |
No |
|
Requires OLAP Services license |
Yes |
No |
|
Can be saved as a stand-alone object and used in multiple reports |
No |
Yes |
|
Can quickly switch the level at which the qualification is evaluated from report level to the level of attributes displayed on the report |
Yes |
No |
|
Can be modified while viewing the report data |
Yes |
No |
For design considerations and examples of using view filters versus report filters, see the In-memory Analytics Help .