Working with Controls

• Click on the element to invert the selection.

• Clicking the element while holding down the SHIFT key deselects all elements and selects elements (except for the collapsed ones), positioned between the focused element and the clicked one.

• Clicking while holding the CTRL key selects or deselects an element and all its child elements.

Select the required selection option in the context menu.

Choose the selection option on the Selection ribbon tab.

NOTE. The Selection ribbon tab is available on selecting the Selection group of tabs of the side panel.

NOTE. The feature is available only in the desktop application.

• Clicking the Down/Up key moves the focus.

• Clicking the Left or Right keys expands or collapses the focused element hierarchy.

• Pressing the SPACE key inverts the selection. Pressing the SPACE key the user can hold down the SHIFT or CTRL key.

• Pressing the SPACE key while holding down the CTRL key inverts selection of an element and of all its child elements.

NOTE. Navigating elements using arrow keys in single-selection lists (fixed dimensions) automatically selects and focuses the elements.

To select or deselect a dimension element, click the required element on the tab with the dimension.

To select all dimension elements, open the dimension tab on the side panel and:

• Click the Select All button on the Selection ribbon tab.

• Select the Select All item in the context menu of the dimension element on the side panel.

• Select the Select All item in the dimension menu on the side panel.

After executing one of the actions all dimension elements are selected.

To select all dimension elements, by which there is data in the source:

1. Go to the dimension tab on the side panel.

2. Click the Select All with Data button on the Selection ribbon tab.

NOTE. The option is available in the desktop application if data source caching.

To deselect all dimension elements, open the dimension tab on the side panel and:

• Click the Deselect All button on the Selection ribbon tab.

• Select the Deselect All item in the dimension element's context menu on the side panel.

• Select the Deselect All item in the dimension menu on the side panel.

After executing one of the actions all dimension elements are deselected.

To select a dimension level:

1. Go to the dimension tab on the side panel.

2. Select level in the drop-down menu:

• In the menu of the Select Level button on the Selection ribbon tab.

• In the Advanced Selection > Select Level item in the context menu of the dimension element on the side panel.

• In the Advanced Selection > Select Level item in the dimension menu on the side panel.

After executing the actions the chosen dimension element is selected.

NOTE. Level selection is available for the dimensions that have levels.

To select all descendants:

1. Go to the dimension tab on the side panel.

2. Select the Select Descendants by Level or Select All Descendants item:

To deselect all descendants:

1. Go to the dimension tab on the side panel.

2. Select the Deselect Descendants item:

NOTE. The feature is available only in the desktop application.

The user can copy and paste element selection between dimensions of a regular report, express report, or a time series database if these dimensions are based on the same data source.

To copy the selected dimension elements selection to the clipboard:

• Select the Copy item in the selection's context menu.

• Press CTRL + C or CTRL + INSERT.

After executing the command the chosen selection is copied to clipboard.

To paste the dimension element selection from the clipboard:

• Select the Paste item in the selection's context menu.

• Press CTRL + V or SHIFT + INSERT.

On executing the command the selection from the clipboard replaces the current selection in the dimension. To add more elements to the existing selection, hold down the CTRL key while executing the command.

NOTE. Dimension element selection can be pasted if the clipboard contains selection of the same dimension.

It is available to set multiple selection for the Value role.

To do multiple selection in fixed dimensions, go to the Selection side panel tab and select the dimension:

Select the type of cube data aggregation in the drop-down list of the Aggregation Method row:

• Sum. Source level elements are summed up

• Minimum. The minimum value is selected on the source level

• Maximum. The maximum value is selected on the source level

• Number of Non-Empty. The number of non-empty values is defined on the source level

• Number of Empty. The number of empty values is defined on the source level

• Number of All Children. The number of child elements is defined on the source level

• Arithmetic Mean. The arithmetic mean of the level elements is defined, considering empty values

• Actual Mean. The actual mean value of the level elements is defined, not considering empty values

• First Actual. The first actual value is found on the source level

• Last Actual. The last actual value is found on the source level

• Root-mean-square Deviation based on Sample. Root-mean-square deviation is defined for row by sample data

• Median. A median is defined for source level values

• Root-Mean-Square Deviation. A root-mean-square series deviation based on the entire population is defined

• Number of Different Values. The number of unique values is defined on the source level.

To create a dimension selection schema:

1. Go to the dimension tab on the side panel.

2. Select the Create a Schema by Selected Elements item in the drop-down menu of:

• The Selection Schema button on the Selection ribbon tab.

• The Advanced Selection > Apply Selection Schema item in the dimension element's context menu on the side panel.

• The Advanced Selection > Apply Selection Schema item in the dimension menu on the side panel.

The created selection schema will be applied to dimension elements.

NOTE. If a calculated element is in dimension, and alternative or custom hierarchy is set, selection schema cannot be created.

To apply a dimension selection schema:

1. Go to the dimension tab on the side panel.

2. Choose selection schema in the drop-down menu of:

• The Selection Schema button on the Selection ribbon tab.

• The Advanced Selection > Apply Selection Schema item in the dimension element's context menu on the side panel.

• The Advanced Selection > Apply Selection Schema item in the dimension menu on the side panel.

To apply the selected schema on report opening, select the When Opening a Report checkbox, to apply the selected schema on rebuilding the dimension, select the When Rebuilding a Dimension checkbox. Both checkboxes can be selected at the same time, in this case, the schema will be applied on report opening and on dimension rebuilding.

To disable the selection schema, select the Reset item.

On applying the selection schema on the dimension side panel the icon appears.

NOTE. The feature is available only in the desktop application.

To edit selection schema:

1. Go to the dimension tab on the side panel.

2. Select the Edit item in the drop-down menu of:

• The Selection Schema button on the Selection ribbon tab.

• The Advanced Selection > Apply Selection Schema item in the dimension element's context menu on the side panel.

• The Advanced Selection > Apply Selection Schema item in the dimension menu on the side panel.

In the Selection Schema dialog box that opens add primitives of the selection schema, according to which elements are selected.

To create a group of dimension elements:

1. Go to the dimension tab on the side panel.

2. Select the Create a Group by Selected Elements item in the drop-down menu of:

• The Select Group button on the Selection ribbon tab.

• The Advanced Selection > Select Group item in the dimension element's context menu on the side panel.

• The Advanced Selection > Select Group item in the dimension menu on the side panel.

Elements that are included into the created group are selected in the dimension.

NOTE. If a calculated element is in dimension, alternative or custom hierarchy is set, a group of elements cannot be created.

To select a a group of dimension elements:

1. Go to the dimension tab on the side panel.

2. Select a group of elements in the drop-down menu of:

• The Select Group button on the Selection ribbon tab.

• The Advanced Selection > Select Group item in the dimension element's context menu on the side panel.

• The Advanced Selection > Select Group item in the dimension menu on the side panel.

Application of the Element Groups selection deselects all elements and selects the group.

The Reset item is identical to the Deselect All item.

NOTE. The feature is available only in the desktop application.

To edit a group of elements:

1. Go to the dimension tab on the side panel.

2. Select the Edit item in the drop-down menu of:

• The Select Group button on the Selection ribbon tab.

• The Advanced Selection > Select Group item in the dimension element's context menu on the side panel.

• The Advanced Selection > Select Group item in the dimension menu on the side panel.

In the Groups of Elements dialog box that opens add primitives of a group of elements, according to which a set of elements will be created.