Skip to main content

Pentaho+ documentation is moving!

The new product documentation portal is here. Check it out now at docs.hitachivantara.com

 

Hitachi Vantara Lumada and Pentaho Documentation

Analyzer Filters

Filters are used to restrict or limit data in a report, building the report to show only the information you want to view.

Filter Operators

Within each dimension, you can have String, Date, and Numeric level filters, and Measure value filters.

Filter on String/Date/Numeric Levels

The following filter types and operators are supported on levels: 

String Levels

  • Include and Exclude
  • Contains and Does Not Contain

Date Levels

  • Include and Exclude
  • Before, After, and Between
  • All relative time filters such as 'Current Year' or '3 Years Ago' 

Numeric Levels

  • Include and Exclude
  • Contains and Does Not Contain
  • Greater Than (or Equals), Less Than (or Equals), and Between

Operator IDs:

  • EQUAL
  • NOT_EQUAL
  • CONTAIN
  • NOT_CONTAIN
  • BEFORE
  • AFTER
  • BETWEEN
  • TIME_AGO
  • TIME_AHEAD
  • TIME_YAGO
  • TIME_RANGE_PREV
  • TIME_RANGE_NEXT
  • NUMERIC_LESS_THAN
  • NUMERIC_GREATER_THAN
  • NUMERIC_LESS_THAN_EQUAL
  • NUMERIC_GREATER_THAN_EQUAL
  • NUMERIC_BETWEEN

Filter on Measure Values

The following filter types and operators are supported on measure values: 

  • Top N
  • Greater Than/Less Than filters

Operator IDs:

  • LESS_THAN
  • GREATER_THAN
  • LESS_THAN_EQUAL
  • GREATER_THAN_EQUAL
  • EQUAL
  • NOT_EQUAL
  • BETWEEN
  • IS_NOT_EMPTY
  • TOP
  • BOTTOM
  • TOP_BOTTOM

The UI labels for these operators can be translated in the message.properties file. These labels appear in the filter dialog, filter summary and on the last page of exported reports.

Filter Logic

Each dimension is filtered independently and the results are logically AND'd together. Level filters are always applied before measure value filters and the two groups of filters are AND'd together. Within level filters, the following operators are OR'd together: Include, Contains, Before, After, Between and relative time filters. These filters are then AND'd together with the Exclude and Does Not Contain operators.

Here's a visual representation:

(
  Include OR Contain OR Before OR After OR Between OR Any Time Filter
) AND (
  Exclude AND Not Contain
)

The above filters are then AND'd with any numeric filters:

AND (Top 10 AND Greater Than)

Within a Contain or Not Contain operator, the individual expressions are OR'd together.