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 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 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.