Quick Filter enables you to reduce the number of data items displayed on dashboard grids without needing to understand the multi-dimensional aspect of the model. Quick Filter is available from the Quick Access toolbar, or from the context menu on rows and columns on dashboard grids.

You can:

  • Add a single Quick Filter to each column or row.
  • Show or hide all the blank cells in a column.
  • Show items based on the criteria that you specify.
  • Filter a row that displays a line item subset.
  • Apply a Quick Filter to a master dashboard or a personal dashboard and save that dashboard where Personal Saved Dashboards is enabled.
  • Create one Quick Filter for each valid selection.

On dashboard grids, List Filters are replaced by Quick Filters. The List Filter option in context menus is replaced by Quick Filter options. Existing List Filters are not converted to Quick Filters. Existing List Filters are available from the Filter dialog.

Rules

Quick Filters are independent of standard filters and a series of rules govern the way in which the number of visible cells is reduced. Quick Filters:

  • Support one filter per column or row.
  • Are always combined with Filters using AND logic, regardless of the way in which the standard filters are configured.
  • Cannot be disabled but you can use the Clear Quick Filters option.
  • Are cleared when you pivot a grid.
  • Can only be applied if there are no standard filters that are disabled. You must first clear or enable standard filters that are disabled.

When filtering a list-formatted line item, the standard filter always displays every item in that list. However, the list items displayed in Quick Filter are dependent on any choices made previously. For example, selecting EMEA from a list of regions will cause Quick Filter to display only those countries in that are in EMEA.

Valid selections for Quick Filters

You can't apply a Quick Filter to a column when rows contain line items. These are examples of valid selections:

  • A column containing the Time dimension when rows contain a lis
  • A row containing the Time dimension when columns contain a list.
  • A line item in a subsidiary view.

Quick Access toolbar

The Quick Filter dialog displays when you click the filter icon on the Quick Access toolbar. Select a column heading to display the Quick Access toolbar.

Quick Filters are always available regardless of whether standard filters are enabled in Menu Options in the Dashboard Designer.

Filter dropdown menu

Select the arrow next to the filter icon to display the filter dropdown menu.

Different options display in the Filter dropdown menu depending on the data type of the selected column. You can:

  • Create a Quick Filter to Show zeros or Hide zeros, if the selected column or row contains numerical data.
  • Create a Quick Filter to Show blanks or Hide blanks, if the selected column or row contains textual data.
  • Create a Quick Filter to Show true or Show false if the selected column or row contains checkboxes.
  • Display the Quick Filter dialog to Show items that match criteria you specify.
  • Select Clear Quick Filter to clear the Quick Filter on the selected column.
  • Clear All Quick Filters.
  • Select Filter Overview to display an overview of your Quick Filters for columns or rows.
  • Display the Filter dialog.

Quick filter dialog

Select the Filter icon to display the Quick filter dialog.

If you make an invalid selection for Quick Filter, a message notifies you that the selection is not valid. See Valid selections for Quick Filters.

In the Quick Filter dialog you can:

  • Create a Quick Filter.
  • View an existing Quick Filter.
  • Remove an existing Quick Filter.

Quick Filter icon

The Quick Filter icon provides these indications:

Icon

Indication

There are no Quick Filters applied.

Quick Filters are applied and either: no standard filters exist; or standard filters exist and are enabled.

If a Quick Filter is applied to column or row in a grid, a filter icon displays in the column or row header.

Quick Filter and large data sets

A Quick Filter only shows unique items for the first 100,000 cells in a grid. If the number of items exceeds this limit, and you create a quick filter, a message warns you that Quick Filter only shows unique items for the first 100,000 cells.

If you get this message and you need to filter your data on an item that's not in the dropdown, you can either:

Note: If your model contains a large amount of data, the items might take several seconds to display.

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.