Data Warehouse Layer - Delta Calculation

The Data Warehouse Layer can have too different flavors: With delta calculation or as data mart.

With the template for the Data Warehouse Layer with delta calculation, the Activate Data and Write Change Log properties are selected under Modeling Properties:

You can also choose the optional property Unique Data Records, if you are only loading unique data records.

Requests are loaded into the inbound table. If you want to execute a query on these requests, they must be activated first. The data is written to the active data table, and the history is stored in the change log. The change log is also used for the rollback, so that activated requests can also be deleted again.

This type of modeled object corresponds to a standard DataStore object (classic). Unlike with InfoCube-like DataStore objects, this does not provide stable navigation during reporting. When a query is executed, the active table is accessed: