Data Visualization on Report Sheet

To display the Dimensions area on the Sources side panel:

1. Click the Source button on the tab panel. The Sources side panel opens.

2. Select the slice, table or chart of the selected data source on the panel.

1. Select the table cell or chart.

2. Click the Selection Control Panel button on the View toolbar tab.

To select the selected dimension layout option:

• Using Drag&Drop.

• Select the context menu item in the Dimensions area.

• Select item in the drop-down menu of the Actions button in the Dimensions area.

• Select the item in the drop-down menu of the Actions button on the selection control panel. Button color depends on the dimension location: if the dimension is in row, the button is blue, if the dimension is in column, the button is green.

Available dimension layout options:

• To Columns. Specify the dimension that will be displayed in columns.

• To Rows. Specify the dimensions that will be displayed in rows.

• To Fixed. Specify the dimensions that will be excluded from rows and columns, that is, will be fixed.

Dimension fixation is used to hide a dimension from the rows and columns, based on which data views are created.

• Filter in Source. Specify the dimensions that will not be used in building a data view:

This layout option is available:

1. For all data sources, except for the sources having two or more cubes.

2. For source cubes with enabled method of fact aggregation.

3. For all dimensions, except for facts dimensions.

When source cubes are added with enabled aggregation method to a report, the Filter in Source layout option is used for dimensions if dimensions are excluded from rows and columns:

If aggregation is disabled in the cube, the Fixed position option is applied for these dimensions.

Determine the optimal view for analyzed data by experimenting with dimension positions.

The option is available if data sources contain several shared dimensions.

A private dimension can be created based on a shared dimension.

To create a private dimension based on a shared one:

1. Select the shared dimension.

2. Execute one of the operations:

• Select the To Private context menu item.

• Select the To Private item in the drop-down menu of the Actions button.

To set up selection of the selected dimension:

• In the Dimensions area on the Sources side panel:

• Select the Selection context menu item.

• Select the Selection context menu item in the drop-down menu of the Actions button.

• On the selection control panel select the Selection item in the drop-down menu of the Actions button. Button color depends on the dimension location: if the dimension is in row, the button is blue, if the dimension is in column, the button is green.

The selection panel opens.

To view selection of the selected dimension, hover the cursor on the dimension. A tooltip is displayed:

• [Dimension_name] (All). Full selection.

• [Dimension_name] (No selection). No selection.

• [Dimension_name] ([Number of selected] of [Total]). Partial selection.

• [Dimension_name] ([Element_name]). Single selection.

For details see the Working with Dimension Elements section.

To reorder displaying of dimensions, use Drag&Drop.

To add a control for the selected dimension in the Dimensions area on the Sources side panel:

• Select the Control context menu item.

• Select the Control item in the drop-down menu of the Actions button.

For details about setting up controls see the Adding Interactive Report Contents Controls section.

NOTE. If the visualizer uses several data sources, adding a control is available only for shared dimensions.

To search for a dimension:

1. Click the Search button in the upper part of the Dimensions area on the Sources side panel.

2. Enter the searched text to the search string. Search is executed automatically as the searched text is entered in the search string. The dimensions, which contain the specified substring, will be displayed in the Dimensions area according to their position.

To reset the search results, click the Clear button.

To use dictionary attributes as separate dimensions, set up dimension visibility. The obtained additional dimension can be used as an alternative hierarchy.

As a data source, one should use a cube, which has an attribute-based alternative hierarchy configured for one or several dimensions. The data source should include one cube. The data sources that include two or more cubes do not support the setting. If these conditions are satisfied, the Dimensions area on the Sources panel displays the Set Up Dimension Visibility button:

To display the dimension, click the Set Up Dimension Visibility button, and the Set Up Dimension Visibility dialog box opens:

The dialog box displays all the dimensions, for which one can set up an alternative hierarchy. Each dimension has all the attributes configured for alternative hierarchy. Only the dimensions are selected by default.

Select checkbox of the attribute, by which an alternative hierarchy should be set, and click the Apply button.

As a result, new dimensions with the default names: Dimension name. Attribute name are added in the Dimension area.

The dimension that is the first one in the list of attributes is added to the same position as the main dimension. Other additional dimensions are located in fixed dimensions.

If additional dimensions are added for the dimension in filter, they are located in fixed dimensions.

If a control is added for the additional dimension, one should edit the control after deleting the additional dimension.

Constraints when working with additional dimensions in attribute:

• One cannot use alternative hierarchy.

• One cannot use custom hierarchy.

• One cannot use grouping.

To resize panel:

1. Put the cursor to the border between the Sources Dimensions areas. The mouse cursor changes to the two-headed arrow.

2. Hold down the mouse button and move drag the border to the required position.

1. Click the Source button on the tab panel. The Sources side panel opens.

2. Select the slice, table, or chart of the selected data source.

3. Execute one of the operations for the selected dimension/private dimension:

• Select the Selection context menu item.

• Select the Selection context menu item in the drop-down menu of the Actions button.

• Select the Selection item in the drop-down menu.

Custom hierarchy is an alternative hierarchy type obtained after editing the list of dimension elements.

To set up custom hierarchy, select the > Edit item in the dimension element's context menu on the selection panel.

The Edit - <Dimension name> dialog box opens:

Move/delete dimension elements in the Total Dimension area using the Move Up, Move Down, Move One Level Up, Move One Level Down, Delete buttons. The confirmation dialog box opens before element deletion.

When the element with child elements is moved by levels, it changes its position together with child elements.

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

To expand or collapse the hierarchy of a dimension elements list, select the Expand All or Collapse All item in the element's context menu.

To add the previously deleted element, select it in the Original Dimension area and click the Add to Dimension button.

To apply the custom hierarchy, click the Apply button. The dialog box closes, and the custom hierarchy is applied.

To restore the original dimension, select the Dimension > Restore item in the dimension element's context menu on the selection panel. Confirm the operation in the confirmation dialog box, and the custom hierarchy will be deleted.

NOTE. One cannot select custom hierarchy of the dimensions, for which displaying of additional dimensions is set up.

NOTE. It is available for data sources that include two or more cubes.

A private dimension can be moved to fixed/shared. To do this:

1. Select the private dimension.

2. Execute one of the operations:

• Select the To Fixed Private/To Shared context menu item.

• Select the To Fixed Private/To Shared item in the drop-down menu of the Actions button.

NOTE. When moving a private dimension to shared, the dimension layout remains the same (Columns, Rows or Fixed), in which private dimensions are located.

To search for dimension element:

1. Click the Search button.

2. Enter the searched text to the search string. Search is executed automatically as the searched text is entered in the search string. The elements containing the specified substring are displayed as a list with their parent and child elements.

To reset the search results, click the Clear button.

To resize panel:

1. Put the cursor to the right border of the selection panel. The mouse cursor changes to the two-headed arrow.

2. Hold down the mouse button and move drag the border to the required position.