Editing Dimension

In regular reports:

In the web application select the Dimension > Edit item in the dimension element's context menu on the selection panel.
In the desktop application:

Select the Dimension > Edit item in the dimension element's context menu in the Selection group of tabs on the side panel.
Click the Edit button in the Dimension group on the Hierarchy ribbon tab.

In express reports and dashboards:

Select the Dimension > Edit item in the dimension element's context menu in the Selection group of tabs on the side panel.
Click the Edit button in the Dimension group on the Hierarchy ribbon tab.

The Original Dimension area displays dimension elements before editing, the Total Dimension area displays dimension elements after editing.

To add an element to dimension:

Select one or several elements in the Original Dimension area. To select multiple elements one by one, hold down the CTRL key; to select all element starting from the currently selected one to the N element, hold down the SHIFT key.
Click the Add to Dimension button.

After executing the operations the selected elements are added to the total dimension.

Adding a calculated element is available only in the Edit Dimension dialog box.

To add a calculated element:

Select the Element > Add New item in the element's context menu.
Click the Add button.

To set up a dimension element, use the expression editor. A new dimension element is added to the dimension, which tab is opened in the Selection group of tabs on the side panel.

A new calculated element cannot be added:

If global cache.
If a group of elements is applied in dimension.
If aggregated data is drilled down.
If a cube is a data source:

In table or calculated dictionary of which there are no indexes.
Which dictionary attribute is used as alternative hierarchy and is included in data source structure of regular report as a child element.

If combine dimension is used.

To reorder elements in the level, use the Move Up and Move Down buttons.

To move elements between levels, use the Move One Level Up and Move One Level Down buttons. It is available only in the Edit - <dimension name> dialog box.

When the element is moved between levels, child elements are moved with the parent element.

When the element is moved one level down, it becomes a child for the element located at the upper level:

Renaming an element is available only in the Edit Dimension dialog box.

To rename an element:

Open element name for edit:

Select the Element > Rename item in the element's context menu.
Select the element and click the Rename button.

Enter a new element name and press the ENTER key.

After executing the operations the element is renamed.

Editing element formula is available only in the Edit Dimension dialog box.

To edit element formula:

Select the Edit Formula item in the element's context menu.
Select the element and click the Edit Formula button.

After executing the operations the expression editor opens to set the formula of calculated element.

To delete an element:

In regular reports:

In the web application click the Delete button.
In the desktop application:

Select the Element > Delete item in the element's context menu.
Select the element and click the Delete button.

In express reports and dashboards:

Select the Element > Delete item in the element's context menu.
Select the element and click the Delete button.

After executing the operations the element is deleted. In the web application before deleting the element the system requests to confirm the operation.

NOTE. Deleting of calendar dictionary elements is unavailable.

Editing Source Dictionary

To edit the source dictionary corresponding to dimension, execute one of the operations: