Actions on filters

For the Ad-hoc Analysis widget, filters are displayed below the toolbar. For other widget types, filters are displayed under the toolbar when you are in Show Data mode.

To enable actions on filters, click the expand button, or the text.

Actions on filter hierarchies

You can drag and drop the hierarchies on the row and column axes. When you drop a hierarchy on a plus (+) icon on a row or column axis, the hierarchy is added to the axis. When you drop the filter hierarchy on any horizontal or vertical hierarchy of the data table, the new hierarchy replaces the hierarchy from the data table axis.

When you click on any hierarchy in the filter section, these actions are available:

  • Move To Row Axis: Moves the hierarchy from the filter area to the row axis.
  • Move To Column Axis: Moves the hierarchy from the filter area to the column axis.
  • Change Hierarchy: Each dimension in a cube is represented by its hierarchy. Only one hierarchy can be displayed for each dimension at a time. When working with a dimension that contains multiple hierarchies, the default hierarchy that is associated with the dimension is selected. To select an alternate hierarchy from the same dimension, click the Change Hierarchy option and select a different hierarchy. Alternatively, drag and drop a hierarchy on another hierarchy to exchange their position, or drag and drop it on the white hierarchy header with the plus (+) icon.
  • Select Display Type: You can change the attribute that is displayed for the hierarchy in the filter area.
  • Select elements: Selects elements for a particular hierarchy.