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. Activate the slice, table, or chart.

To select dimension position, use context menu commands of the selected dimension:

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

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

• 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. It is available for source cubes with enabled method of fact aggregation. Specify the dimensions that will be used to create data views.

When source cubes are added with enabled aggregation method to a report, the Filter in Source position 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.

To set up dimension selection, select the Selection item in the selected dimension's context menu in the Dimensions area of the Sources side panel. The selection panel opens.

For details see the Working with Dimension Elements section.

To add a control, select the Control item in the selected dimension's contents menu in the Dimensions area on the Sources side panel.

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

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.

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. Activate the slice, table, or chart.

3. Select the Selection item in the context menu of the selected dimension.

To set up dimension selection, execute one of the operations:

• Use the mouse to select or deselect the element.

• Select the required selection option in the dimension element's context menu:

• Select All. It selects all dimension elements.

• Deselect All. It deselects all dimension elements.

• Select Descendants by Level. It selects all elements on the same level with the specified dimension element.

• Select All Descendants. It selects all descendant elements.

• Deselect Descendants. It deselects all descendant elements.

• Select Level. It selects dimension level.

• Deselect Level. It deselects dimension level.

• Apply Selection Schema. It selects the selected selection schema in the drop-down list.

• Select Group. It selects the selected group of elements of dimension in the drop-down list.

To search for dimension element:

1. Click the Search button at the top part of the selection 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 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 expand or collapse hierarchy of a dimension elements list, select the Expand All or Collapse All item in the element's context menu.

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.