DataStore Object Settings

Select the DataStore object type. You can choose between Standard, Direct Update, and Write-Optimized, where Standard is the default value, while Direct Update is only intended for special cases. You can switch the type as long as there is still no data in the DataStore object yet.

More information: DataStore Object Types

The following settings are only available for certain DataStore object types:

For Write-Optimized DataStore Objects:

• External SAP HANA view:

  If you are using an SAP HANA database, you can specify that you want an SAP HANA view to be created. More information: Generating SAP HANA Views from the BW System

• Allow duplicate data records:

  With write-optimized DataStore objects, the technical key of active tables always consists of the fields Request, Data Package and Data Record. The InfoObjects that appear in the maintenance dialog in the Semantic Key folder form the semantic key of the write-optimized DataStore object.

  If this flag is set, no unique index is generated with technical name "KEY" for the InfoObjects in the semantic key. This means that there can be more than one record with the same key in the active table of the DataStore object.

DataStore Objects for Direct Update:

The following applies to DataStore objects for direct updates using the planning mode flag:

• Use of characteristics:

  All characteristics must be contained in the key of the DataStore object. This also applies to characteristics that contain currencies and quantities.

• Use of key figures:

  All key figures in a data part, which are valid for the direct update of the DataStore objects without planning mode, can be used. In addition, key figures with standard aggregation no aggregation (X, if more than one value) (NO2) can be included in the data part. However, BW-integrated planning only allows you to change key figures with standard aggregation SUM and NO2.

For Standard DataStore Objects:

• Generate SID values:

  With the Generation of SID Values flag, you define whether SIDs are created for the new characteristic values in the DataStore object when the data is activated. There are three options:

  • During reporting: When data is activated in the DataStore object, no SIDs are retrieved for the new characteristic values. This reduces the runtime during activation. The SIDs are generated during query execution.
  • During activation: The SIDs are generated when the data is activated. This reduces runtime when executing the query.
  • Never generate SIDs: SIDs are never generated. This is the best option for all DataStore objects that are likely to be used for further processing in other DataStore objects or InfoCubes. If you create a query for a DataStore object with this property, the query cannot be executed. You can still define InfoSets with this DataStore object and execute queries for it.
• External SAP HANA view:

  If you are using an SAP HANA database, you can specify that you want an SAP HANA view to be created. More information: Generating SAP HANA Views from the BW System

• Load unique data records: If you only load unique data records (data records with non-recurring key combinations) into the DataStore object, performance is improved if you set the Unique Data Records flag in DataStore object maintenance. This setting is displayed as the default setting when activating data in administration or the corresponding process in the process chain. You can also overwrite this setting there if required (for initial data loading for example).

  The records are then updated more quickly because the system no longer needs to check whether the record already exists. You have to be sure that no duplicate records are loaded because this leads to termination. Check whether the DataStore object might be write-optimized.

• Settings for automatic further processing: If you set the flag Automatically set quality status to OK, the system automatically sets the quality status to OK after loading data into the DataStore object. You should activate this function. You should only deselect this flag if you want to check the data after loading.