It is available to set up the appearance of each dimension displayed in the Selection group of tabs on the side panel and in the report working area by:
Setting the type of displaying of element names.
Displaying of group of elements.
Using alternative hierarchy.
Using element sorting.
Group of Elements is a repository object, which is used in dictionaries to limit a list of available elements.
To display a group of elements:
Go to the dimension tab on the side panel.
Select a group of elements in the drop-down menu of:
The Group of Elements button in the View group on the Hierarchy ribbon tab.
The Group of Elements item in the dimension element's context menu on the side panel.
The Group of Elements item in the dimension menu on the side panel.
To show all dimension elements, select the Reset item.
When working with dimension elements, it is available to create a group by selected elements.
NOTE. If a calculated element is in the dimension, alternative or custom hierarchy is set, a group of elements cannot be created.
Alternative hierarchy is a hierarchy of any other dictionary linked with the hierarchy of the main dictionary for element mapping or a custom hierarchy created on editing dimensions or adding a new calculated element.
When alternative hierarchy is used, dimension displays elements of alternative dictionary mapped by element indexes.
NOTE. Alternative hierarchy cannot be applied if global cache was created for the current dimension.
To use alternative hierarchy:
Go to the dimension tab on the side panel.
Select the alternative hierarchy in the drop-down menu of:
The Alternative Hierarchy button in the View group on the Hierarchy ribbon tab.
The Alternative Hierarchy item in the dimension element's context menu on the side panel.
The Alternative Hierarchy in the dimension menu of the side panel.
NOTE. The item is available if alternative hierarchy is used.
To show main dimension hierarchy, select the Reset item.
To sort dimension elements displayed on the dimensions tabs in the Selection group on the side panel, select sorting method in the drop-down list:
The Sorting button in the View group of the Hierarchy ribbon tab.
Sorting in the context menu of dimension element on the side panel.
Sorting in the dimension menu on the side panel.
Available sorting methods:
Ascending.
Descending.
By attribute. Select a dimension attribute to sort by in the drop-down list.
The order of dimension elements is applied only to hierarchy of the dimension displayed on the side panel and is not saved with the report.
IMPORTANT. The order of dimension elements in the table is not synchronized with the order of dimensions on the side panel. For detailed description of dimension element order setup see the Sorting section.
To show dimension elements with default sorting, select the Reset item.
Combination of dimensions enables the user to combine several dimensions into one and display its elements as a time series tree.
To combine dimensions, click the Combine button on the Hierarchy ribbon tab.
NOTE. Combination of dimensions is available only in the Dashboards and the Analytical Queries (OLAP) tools.
See also: