Use numeric filters in the cube viewer

You can now filter rows and columns based on cell values in a cube in Planning Analytics Workspace.

Two new filters have been added to Planning Analytics Workspace: Filter by count and Filter by value.

To use these new filters, right-click on a row or column header, and select Filter. Then select Filter by count or Filter by value.

Note: You can only have one Filter by value or Filter by count filter active at the same time. If you apply another filter of the same type to the same view, the first filter will be removed.
Filter options in the filter menu

Filter by count to filter members in a row or column to show the top or bottom members of a specified count type.

Filter by count options

You can choose the following criteria when creating the filter:
  • You can select if you want the filter to show the top or bottom members of your specified count type.
  • You can choose the number of members you want to see included in the filter results. This value must be numeric.
  • You can select the type of count you want to filter for. You can choose Items, Percent, or Sum.
  • You can add an additional set of criteria for the filter. You can add a total of two sets of criteria in each filter.

Filter by value to filter the members in a row or column based on a selected value.

Filter by value options

You can choose the following criteria when creating the filter:
  • You can select a comparison operator for the filter. You can choose = (equal to), > (greater than), >= (greater than or equal to), < (less than), or <= (less than or equal to).
  • You can choose the number you want the comparison operator to filter by. This value must be numeric.
  • Select how you want the filter to match your criteria. Select Match all of the following if you want the filter to only include members that match all of the criteria you set. Select Match any of the following if you want the filter to include members that match any of the criteria you set.
  • You can add an additional set of criteria for the filter. You can add a total of three sets of criteria in each filter.

A row or column with a filter applied has the filter icon Filter icon.

You can use filters and sorting capabilities simultaneously. To learn more about sorting, see Sort rows and columns.

For more information on filtering rows and columns, see Filter rows and columns based on cell value.