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