Interview Questions

FILTERS

Types of filters

In the reporting environment, when you design a report, it queries the database against all the data stored in the data warehouse. By applying a filter, you can narrow the data to consider only the information that is relevant to answer your business question. The previous, Reports, discussed the following three ways to restrict data to generate reports:

  • A report filter that is a criterion used to select the data to calculate the metrics in the report.
  • A report limit that specifies a set of criteria used to restrict the data returned in the report data set after the report metrics are calculated. Because it is based on the report’s metric values, a limit is applied after all metrics are calculated.
  • A view filter that is an additional filter applied in memory to the report data set. It affects only the view definition. This focuses on report filters and expands on their advanced capabilities.

Pragna Meter
Next Chapter  
e-University Search
Related Jobs