Datawarehouse synchronization

• Code (field CODDOS)

Use this check box to define the list of datawarehouses to be processed.

• Preliminary purge (field GEN)

The datawarehouse synchronization function retrieves the data in the source tables and transfers them to the destination tables.

Select this check box to reset the destination tables to zero and populate them again.

• Detailed log file (field DET)

Select this check box to generate a detailed log of the audit records that have been added to, modified or deleted in the fact and dimension tables.

• Simulation (field SIMU)

When this check box is selected, the synchronization is not performed, but only simulated. A log file is generated listing the tables that would have been updated if the operation was actually run.

• Audit backup (field EPUAUD)

Select this check box to retain the records of the audit table. This will allow you to reuse these records for another datawarehouse, for example.

• field TYPVAL

Select the List check box to only select the types of BI tables that you need.
Select the All check box to select all types of BI tables.

• Access code (field SACC)

• Calendar (field SDAT)

• Folder (field SDOS)

• Authorization/user (field SAUZ)

• Local menus (field SMEN)

• Miscellaneous tables (field SADI)

• Dimensions (field SDIM)

• Fact tables (field SFAT)

• Aggregates (field SAGG)

• from (field DEBACC)

• To (field FINACC)

• from (field DEBDAT)

• To (field FINDAT)

• from (field DEBAUZ)

• To (field FINAUZ)

• from (field DEBMEN)

• To (field FINMEN)

• from (field DEBADI)

• To (field FINADI)

• from (field DEBDIM)

• To (field FINDIM)

• from (field DEBFAT)

• To (field FINFAT)

• from (field DEBAGG)

• To (field FINAGG)