Actions on axis hierarchies

Hierarchies form vertical and horizontal axes of your data table.

When you click the hierarchy in the data table, these actions are available:

Select Elements: You can search for and select elements from the hierarchy that you want to display in your chart or analysis. You can also select additional elements from the same hierarchy.
Add Selections: This option is available only if more than one dimension is used on axis. You can add specific selections to your data table.; For example, you have created a view of Gross Profit based on Actuals for 2017 and 2018 in your ad-hoc analysis. You want to add Budget 1 data for 2019, without adding Budget 1 data for 2017/2018, and Actuals for 2019 to your data table. You can add the 2019 and Budget 1 selections with one step, so that only one additional column is added to the view of your data table.
Select Level: You can select which level of the hierarchy is shown.; For example, All Years, Quarters, or Months can be selected for the Period hierarchy.
Select Range: With this option, you first select the level and then select two values that define the range to be displayed.; For example, you can select the level as quarter and select to display values from 4th quarter of 2007 to 3rd quarter of 2009 for the hierarchy.
Select Attributes: Depending on your data content, you can display multiple attributes, for example, unique ids, code names, or labels that have been translated to other languages.; The attributes are displayed as additional rows or columns, respectively.
Sort Ascending
Sort Descending: Select one of these options to sort a column in increasing or decreasing order, respectively. You can sort any column, including the attribute column.
Break Hierarchy: Enabling this option sorts the elements regardless of the hierarchy of the dimension. The Break Hierarchy option is enabled when you select sorting.; Disable this option if you want to preserve the hierarchy and its levels when sorting the dimension.; For example, you select the Month level in the Period hierarchy and you sort the Period hierarchy in ascending order. As a result, the break hierarchy option is automatically enabled and months are listed alphabetically. To list the months in a chronological order, disable the break hierarchy option.
Aggregation Setting: With this option you can display aggregation calculations. Select one of these aggregation options: None, Sum, Average, Minimum, Maximum. To change the aggregation settings, you can also click on the aggregated row and select a different aggregation option.
Note: The aggregation settings option is only available for the ad-hoc analysis.
Move to Column Axis
Move to Row Axis: If there are multiple hierarchies selected for the row or column axis, you can move any of those hierarchies to the other axis.
Remove: Adds the hierarchy to filters. This option is only available if there are multiple hierarchies selected for the axis.
Swap Table Axes: Exchanges the table axes.; Note: This option is not available in chart and analysis types where a fixed number of columns is required.
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. Use this option to select an alternate hierarchy from the same dimension. 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.
Ranking: Provides ranking of the data. The ranking options include: None, Top Count, Top Sum, Top Percent, Bottom Count, Bottom Sum, Bottom Percent.
Remove Ranking: Removes the ranking and shows all filtered data.
Select Display Type: Changes the display type of all elements of a hierarchy. The default display type is the caption. You can replace the caption with an attribute.