The Filters Area

The Filters Area provides the ability to select and apply dimension filters to the current view.

The Tree section displays a hierarchical view of the dimension values in the current cube view. Clicking a value will cause it to be displayed in the Filters section and immediately applies that filter to the data in the currently selected views. To remove a dimension from the filters, click on the value in the Filters section.

The Hierarchical Filtering icon, , is used to toggle between hierarchical and non-hierarchical selection mode. In hierarchical mode, clicking a dimension value at any level in the tree will automatically populate the filters with the related higher level dimension values. In non-hierarchical mode, only the selected dimension value is added as a filter.

Use the expand and collapse icons, , to quickly expand the tree, one level at a time, below the currently selected dimension value or collapse the entire level.