MicroStrategy ONE

Filtering data on the fly: view filters and metric filters

A view filter dynamically restricts the data being displayed on the report without re-executing the report against the warehouse. This is different from a report filter, which restricts how much data is retrieved from the data warehouse. View filters improve the response time of reports, and decrease database load.

It is important to note that you can use a report filter and view filter on the same report. The report filter returns a set of data for the report, which the view filter then restricts further. You should therefore avoid defining contradictory filtering criteria in both, otherwise you many encounter situations where no data is displayed.

For detailed information on view filters, see View Filters.