Show TOC

Operators used for filtering measuresLocate this document in the navigation structure

When defining filters by measure, you can create rules to get a list of data for a defined threshold value and rules to get ranked list of data.

To define threshold values, you can use the following operators:
  • Between / Not Between

    For these operators, you define a range of values that should be included or excluded in the list.

  • Greater Than / Less Than

    For these operators, you define a specific value to display members that are greater or less than this value.

  • Greater Than or Equal to / Less Than or Equal to

    For these operators, you define a specific value to display members that are greater or equal to or less or equal to this value.

  • Equal to

    For this operator, you define a specific value to display members that are equal to this value.

To define a ranked list of values, you can use the following operators:
  • Top N / Bottom N

    For these operators, you must enter a whole, positive number as the value. The ranked list is arranged according to the defined number.

    For example, if you want a list of the three customers with the strongest sales volume and the five customers with with the weakest sales volume, you create a Top 3 and a Bottom 5 rule in the filter definition.

  • Top% / Bottom %

    For these operators, you must enter a number between 0 and 100. The ranked list is arranged according to the defined percentage.

    For example, if you want a list of the strongest products in revenue until 25% of the total revenue is attained, you create a Top 25% rule for this measure with regard to products.

  • Top Sum / Bottom Sum

    For these operators, you can also enter a floating point number (15.7 for example). The ranked list is arranged according to the defined total value.

    For example, you want a list of products with the highest sales volume, whose combined sales volume totals EUR 20,000. All sales volumes are first sorted in descending order. The totals are calculated until the threshold value of 20,000 is exceeded. If the last value that need to be included to achieve EUR 20,000, causes the total to exceed 20,000, it is also included in the list. All products with a lower sales volume than this product are no longer displayed. Products that exceed the EUR 20,000 threshold remain in the list.

Note Do not use these operators for ranked lists for filtering hiearchies.