Creating, editing, deleting data connection for cubes
To create a data connection for cubes, right-click the cube in the tree and select . The Create Cube Data Connection View dialog opens.
In the Create Cube Data Connection View dialog, specify the Id and the description of the data connection and select the business group from the drop-down list Source, whose data you transfer to the OLAP cubes. Select one or more fact tables to import. Fact tables are grouped according to content. You can only select fact tables from within a single group. Configure the data transfer from the reference database to the OLAP database.
To edit a data connection for cubes, right-click the data connection in the tree and select the command. The Configure Data Connection dialog opens. Here, you edit the description of the data connection, configure the data transfer from the reference database to the OLAP database, and enable the export function.
| Option | Description |
|---|---|
| Load automatically | Select the check box, if the fact data are to
be loaded from the reference database into the cube of the
OLAP
database, whenever theOLAP
database is created.
To use external data for the cube, select the Use external data check box. Data of an existing fact table are loaded. The fact table will not be created anew. |
| Allow Export | Enable this check box, to enable the export function for the data connection. |
| Clear data area | Select this check box to clear the target data area of the cube, where the data is transferred to. This ensures the consistency of the data in the cube. |
To delete a data connection for cubes, right-click the data connection in the tree and select .