Creating a quick filter

Sometimes you want to take out of the cube view certain values, for example, you don't want to see all values below 1000. Clicking on this menu option, will display a dialog that will let you do exactly this:

With this dialog you can:

  • Disable filter: to disable a previous filter, no longer a filter will be applied.
  • Operator: let you choose what comparison you want to do. You can choose from = Equal, > Greater than, >= Greater or equal to, < Less than, <= Less or equal to and <> Different. Also is possible to query for empty or non empty cells.
  • Value: The value you wish to use in the comparison.
  • OK: Applies the filter to the cube view.
  • Cancel: Exits this dialog without applying any filter.

(if you want to modify this filter or create more complex filters, see page Filters of the cube options dialog.)

With the dialog, you will be able to pass from this data:

to this: