Show TOC

Modeling PropertiesLocate this document in the navigation structure

The modeling properties enable you to control how you use your DataStore object (advanced).

You can set the following modeling properties:

Activate Data
In general, the data is always written to the inbound table. If you choose Activate Data, the data is written to the table for active data (during the activation/compression process) once it arrives in the inbound table. There are three options:
  • Write Change Log: If you choose this option, the delta (new and changed records) is saved in the change log. The change log is used to extract the delta. You can only delete data from the DataStore object if the object has a change log.
  • Keep Inbound Data, and extract from Inbound Table: If you choose this option, no data is saved in the change log. The extraction process always reads the data in the inbound table again - for delta extraction or full extraction.
  • Unique Data Records: If you only load unique data records (data records with non-recurring key combinations) into the DataStore object, you can select this property. This means the system does not check whether the record already exists. You have to be sure that no duplicate records are loaded. This means that the table of active data will only contain unique data records. Data aggregation is not allowed.
All Characteristics are Key, Reporting on Union of Inbound and Active Table

If you select this property, all the characteristics are included in the key. The system accesses the inbound table and the active table (using a union across both tables) in the query. In this case, you should only load additive deltas. The data is aggregated. The properties are comparable to the InfoCube.

Extended Tables
If you use SAP IQ as extended storage for your BW system, you can set the Extended Tables flag. This means that data is only saved in the persistency layer. If you set this flag at a later point in time when the tables already contain data, a remodeling request is created, which you can start in the Remodeling Monitor. Otherwise, the tables are written directly to SAP IQ. If the definition of the DataStore objects (advanced) necessitates activation, this is performed in ABAP.
Direct Update
With this property, you create a DataStore object (advanced) for direct writing. The data is then written directly to the table of activate data using a DTP or an API.
Planning Mode
If you set the Planning Modeflag, you can use the DataStore object (advanced) for planning.
Related Information