Integration in the Data Flow

Metadata

DataStore objects are fully integrated with BI metadata. They are transported in the same way as InfoCubes and are installed from BI Content (more information Installing BI Content in the Active Version). DataStore objects are grouped with InfoCubes in the InfoProvider view in the Data Warehousing Workbench - Modeling and are displayed in a tree. They also appear in the data flow display.

Update

Transformation rules define the rules that are used to write data to a DataStore object. They are very similar to the transformation rules for InfoCubes. The main difference is the behavior of data fields in the update. When you update requests into a DataStore object, you have an overwrite option as well as an addition option.

More information: Aggregation Type.

The Delta Process, which is defined for the DataSource, also influences how data is updated. When loading files, the user must select a suitable delta process so that the correct transformation type is used.

Unit fields and currency fields operate just like normal key figures, meaning that they must be explicitly filled using a rule.

Scheduling and Monitoring

The processes for scheduling the data transfer process for updating data into InfoCubes and DataStore objects are identical.

It is also possible to schedule the activation of DataStore object data and updating from the DataStore object into the related InfoCubes or DataStore objects.

The individual steps, including processing the DataStore object, are logged in the monitor. 

More information: Requests in DataStore Objects

There is a separate detailed monitor for executed request operations (such as activation or rollback).

Loadable DataSources

In full-update mode, each transaction data DataSource contained in a DataStore object can be updated. In delta-update mode, only DataSources that are flagged as delta-enabled DataStores can be updated.