Filtering

The Dashboard allows you to filter a query of the SQL Data Source or apply filtering to a specific data-aware dashboard item.

This topic describes how to enable and reset filtering.

Apply Filtering

To configure filtering, select the target dashboard item and do one of the following.

  • If you are using a Ribbon menu, click the Edit Filter button in the Data tab.

    DataShaping_Filtering_EditFilterButton

  • Right-click a dashboard item and select Edit Filter from its context menu.

    DataShaping_Filtering_EditFilterMenuItem

This will invoke the Filter Editor dialog. Use this dialog to build filter criteria with a convenient tree-like interface.

DataShaping_Filtering_FilterEditor

You can use hidden dimensions within the Filter Editor dialog, allowing you to filter data based on their values.

Clear Filtering

To clear filtering in the Designer, select the target dashboard item and do one of the following.

  • If you are using a Ribbon menu, click the Clear button in the Data tab.

    DataShaping_Filtering_ClearFilterButton

  • Right-click a dashboard item and select Clear from its context menu.

OLAP Filtering Specifics

You cannot apply filtering by building complex filter criteria in OLAP mode. Instead, you can filter dimension attributes and hierarchies by manually selecting the values you wish (or do not wish) to include in the dashboard.

For dimension attributes, the Filter Editor contains a list of all values. You can select the values that you wish to display.

ProvidingData_OLAP_Filter_Standard

For hierarchies, a tree is displayed instead, allowing you to filter individual values at any hierarchy level.

ProvidingData_OLAP_Filter_Hierarchical