Selecting Data Sources and Working with Them

Click the Sources button on the tab panel.

NOTE. The Sources button on the tab panel is available only when a regular report is opened for edit.

Click the Add Source button at the top or central part of the Sources panel.

NOTE. The Add Source button in the central part of the Sources panel is available if no data source is added.

Execute the following operations:

1. Select the required repository object in the repository object tree. Multiple selection is available.

2. Click the Apply button.

To create and add a data source including two or more cubes:

1. Toggle the Combine Sources switch to active state.

2. Select two or more cubes in the repository object tree.

3. Click the Apply button.

After executing the operations, a virtual cube is created.

NOTE. The Combine Source switch is inactive by default.

To set up displaying of repository objects in the Add Source dialog box:

1. Click the Display Object button.

2. Select one of the display versions in the drop-down menu:

1. Name. Objects are displayed with their names. Default value.

2. Identifier. Objects are displayed with their identifiers.

3. Name and Identifier. Objects are shown with their names, object identifiers are shown in brackets.

To rename the data source, select the Rename item in the selected data source's context menu. After executing the command enter a new name and press the ENTER key.

To delete a data source, select the Remove Delete item in the selected data source's context menu. After executing the command the operation confirmation dialog box opens. Clicking the Yes button deletes the selected data source.

Deleting the data sources deletes all child objects. All slices, tables and charts based on these data slices are deleted for the data source.

To quickly select data source use search. Enter the text to be searched in the search string. Search is executed automatically as the searched text is entered into the search string. The list will display only the data sources, which names contain the entered text.

To reset search results, click the Clear button.

1. Hover the cursor on the cube on the Sources panel. The Set Up Data Source button is displayed.

NOTE. The Set up Data Source button is available for cubes with a single data slice.

2. Click the Set Up Data Source button.

NOTE. The Set Up Data Source button is always displayed for combines data sources.

To add cubes to a combined data source:

1. Click the Add button. The Add Source dialog box opens.

2. Select the required repository object in the repository object tree. Multiple selection is available.

NOTE. The data source should include two or more cubes.

3. Click the Apply button.

As a result, the selected cubes are displayed in the list of cubes, of which the data source consists, in the Set Up Source dialog box.

Cubes are displayed in the list in the order of their adding. If the cubes were added at the same time, their order is the same as in the object navigator.

To remove a cube from data source:

1. Select the cube in the list of data source cubes. Multiple selection is available.

2. Click the Remove button.

NOTE. The data source should include two or more cubes.

To set displaying of the list if data source cubes:

1. Click the Display Object button.

2. Select one of the display versions in the drop-down menu:

1. Name. Cubes are displayed with their names. Default value.

2. Identifier. Cubes are displayed with their identifiers.

3. Name and Identifier. Cubes are displayed with their names, and their identifiers are displayed in brackets.

To rename a data source, set a new name in the Name box. The default data source name: Virtual cube N, where N - number of the data source created within one regular report.