Value filtering

Here you will be able to define a search criteria that will be applied to the cube cells. For each cell, if the cell value will fall in an expected value, the cell will be shown in the view.

The criteria can be applied either to the vertical or horizontal axis and it can rotate with the cube axis.

You have to use the Add, Edit and Remove buttons to add or modify your search criteria. The defined search will be store in the dialog grid, and this grid have the following fields:

  • And: You have to choose either an And or an Or when defining more than one condition. If an And is used, all the condition must be met for the cell to be shown, with Or, only one of the condition have to be true.
  • Or: Joins two conditions with an Or.
  • (: You can use open and close parenthesis to group several conditions together. Their value will be use in the general search as a single value.
  • Neg : Let you negate this criteria.
  • Search fields: You can choose a default value or one or more cube fields whose value will be used in the search criteria.
  • Operator: Operator to use for the comparison. There are = Equal, > Greater than, >= Greater or equal to, < Less than, <= Less or equal to and <> Different. You can also use __ Is empty to ask for empty cells.
  • Value: The value which will be used in the comparison. You can use a numeric value or a cube field.
  • ): Closing parenthesis, see above.

In the image above, the search criteria means: bring the cells whose value in 1998 is greater than it's value in 1997.

When the Add or Edit button is pressed, a dialog for filter definition is shown:

This dialog have the following properties:

  • Type: This will let you choose which cube fields to use in the search definition. Use the Default values to do not use an specific filter. The Measure shown will be use as a search field.
  • Operator: Operator to use for the comparison. There are = Equal, > Greater than, >= Greater or equal to, < Less than, <= Less or equal to and <> Different. You can also query if a cell is empty or not.
  • Value Type: You can choose a Numeric value or a Cube field to use as a value.
  • MDX: Press this button if you would like to enter a custom MDX filtter. See the MDX Direct dialog for information.
  • OK: Creates or modifies this search criteria.
  • Cancel: Closes this dialog without affecting the current search criteria.