DataStore Objects for Direct Update

Definition

The DataStore object for direct update differs from the standard DataStore object in terms of how the data is processed. In a standard DataStore object, data is stored in different versions (active, delta, modified), whereas a DataStore object for direct update contains data in a single version. Therefore, data is stored in precisely the same form in which it was written to the DataStore object for direct update by the application. In the BI system, you can use a DataStore object for direct update as a data target for an analysis process. 

More information: Analysis Process Designer.

The DataStore object for direct update is also required by diverse applications, such as SAP Strategic Enterprise Management (SEM) for example, as well as other external applications.

Structure

The DataStore object for direct update consists of a table for active data only. It retrieves its data from external systems via fill or delete APIs.

The following APIs exist:

●      RSDRI_ODSO_INSERT: Inserts new data (with keys not yet in the 

        system).  

●      RSDRI_ODSO_INSERT_RFC: see above, can be called up remotely  

●      RSDRI_ODSO_MODIFY:  inserts data having new keys; for data with 

        keys already in the system, the data is changed.

●      RSDRI_ODSO_MODIFY_RFC: see above, can be called up remotely

●      RSDRI_ODSO_UPDATE: changes data with keys in the system

●      RSDRI_ODSO_UPDATE_RFC: see above, can be called up remotely

●      RSDRI_ODSO_DELETE_RFC: deletes data

The loading process is not supported by the BI system. The advantage to the way it is structured is that it is easy to access data. Data is made available for analysis and reporting immediately after it is loaded.

Creating a DataStore Object for Direct Update

When you create a DataStore object, you can change the DataStore object type under Settings in the context menu. The default setting is Standard. You can only switch between DataStore object types Standard and Direct Update if data does not yet exist in the DataStore object.

Integration

Since you cannot use the loading process to fill DataStore objects for direct update with BI data (DataSources do not provide the data), DataStore objects are not displayed in the administration or in the monitor. However, you can update the data in DataStore objects for direct update to additional InfoProviders.

If you switch a standard DataStore object that already has update rules to direct update, the update rules are set to inactive and can no longer be processed.

Since a change log is not generated, you cannot perform a delta update to the InfoProviders at the end of this process.

The DataStore object for direct update is available as an InfoProvider in BEx Query Designer and can be used for analysis purposes.