Step 5 - Data Transfer
Here, you configure the data transfer from the source database to 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. You may change all settings in the properties dialog of the business group.
Select the check box Load data, when the database is recreated to load all data of all business entities, before the OLAP database is created the next time. If all data are loaded into the reference database, those data are also loaded that are not assigned to anyOLAP dimension. When creating the database with the command , the check box is automatically cleared.
In the table you specify, the data that is always loaded into the reference database before the OLAP database is created. For each business unit you select the periods for which data are loaded.
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 rate
values of the business entity are to be loaded into the reference database,
when the
OLAP
database is created.
You cannot specify for which periods the exchange rates are loaded. The exchange rates of all periods are loaded. |
| Load fact data | Select the check box, if the fact data of the
business entity are to be loaded into the reference database, when the
OLAP
database is created.
In the Periods column you specify, for which periods the business data (fact data) are loaded. You can specify that the data is loaded incrementally. Select Incremental Load from the drop-down list in the Filter column. |
| Periods | Select the periods, for which business data
(fact data) must be loaded into the reference database from the drop-down
lists, for example, Current Quarter.
Select the option Select periods manually to select individual periods in a dialog. |
| Manual selection | If you select the option Select periods
manually in the
Periods column, click
the
button in this
column to open a dialog, where you may select individual 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. |