Data transfer

On the Data transfer tab of the Properties dialog of the business group, you configure the transfer of data from the source databases into the reference database. This is important, because only those business data (fact data) are transferred to the OLAP database that are contained in the reference database. Dimension elements and structures will also be created, when the reference database is empty.

Select the check box Load data, when the database is recreated to load all data of the business units before the OLAP database is created the next time including the data that are not mapped to any OLAP dimension. The check box is disabled, while the database is created. In the table, specify, which periods are loaded for each business unit.

The table contains these columns:

Column Description
ID and Description ID and description of the business entity.
Load exchange rates Select the check box, if the exchange rates of the business entity are to be loaded into the reference database, whenever the OLAP database is created.

The exchange rates of all periods are always loaded into the reference database.

Load fact data Select the check box, if the business data (fact data) of the business entity are to be loaded into the reference database, whenever the OLAP database is created.

In the Period column you specify the periods, whose business data (fact data) are loaded.

Period Select a period category, for which business data (fact data) are loaded into the reference database from the drop-down lists, for example, Current Quarter.

Select Select periods manually from the drop-down list to select individual periods in a dialog.

Manual selection If you select the option Select periods manually in the Period column, click the button in this column to open the Periods dialog, where you may select the periods.

In the dialog, first specify the values for the Start period and the End period to restrict the range of the selection. Then select the check box of the periods, whose data are to be loaded into the reference database, when the OLAP database is created.

Note: To write the data from the reference database into theOLAP database, you must create data connections for those cubes that contain dimensions with mappings for source tables.