Showing results for 
Search instead for 
Did you mean: 

Regarding DSO settings

Former Member
0 Kudos

Hi All,

In Standard DSO, in the settings, 5 options are there...

SID generation, unique data records,Quality status, activate data automatically, update data automatically.

what is the significance for each of these options?

if we check the activate data automatically option, does it activate it automatically.. i dont think it is automatic.. we need to do manually.. So what is the difference between checking and unchecking this option.

Can anybody explain this option a bit detail.....



View Entire Topic
Active Participant
0 Kudos

HI Punitha,

ODS Object Settings


When creating and changing an ODS object, you can make the following settings:

BEx Reporting

With the BEx Reporting indicator, you determine whether the ODS object is immediately available for BEx queries. If the indicator is not set, no SIDs are generated for the new characteristics when the data in the ODS object is activated. This optimizes the performance of the activation process, but the ODS object is not available as an InfoProvider for queries. Turn the indicator off for all ODS objects that are only being used for further processing of data in other data targets or that are being used in InfoSets.

ODS Object Type

Select the ODS object type. You can choose between standard and transactional, whereby standard is pre-installed and transactional is only meant for special cases. You can switch the type as long as there is still no data in the ODS object.

See also Transactional ODS Objects.

Unique Data Records

With the Unique Data Records indicator, you determine whether only unique data records are to be updated to the ODS object. This means that you cannot load a data record into the ODS object the key combination for which already exists in the system u2013 otherwise a termination occurs. Only use this setting when you are sure that only unique data records are to be loaded into the ODS object (for example, single documents). A typical application of this is in the loading of mass data. It improves the load performance.

You can also deselect this indicator again (even if data has already been loaded into the ODS object). This can be necessary if you want to re-post deleted data records using a repair request (see: Tab Page: Updating). In this case, you need to deselect the Unique Data Records indicator before posting the repair request, following which you can then reset the Unique Data Records indicator once more. The regeneration of metadata of the Export DataSource, which takes place when the ODS object is reactivated, has no effect on the existing data mart delta method.

Check Table for the InfoObject

Here the name of the InfoObject is displayed for which the ODS object is also the check table, if necessary. You can specify this when creating an InfoObject. See also Tab Page: Master Data/Texts in the InfoObject maintenance.

Automatically Setting Quality Status to OK

With this indicator, you can determine that the system automatically sets the quality status to OK after loading data into the ODS object. You should turn on this function. You should only deselect this indicator if you want to check the data after it has been loaded.

Automatically Activating the ODS Object Data

With this indicator, you can establish that the data that has Quality Status OK be transferred from the activation queue into the active data table, and that the change log is updated. Activation is carried out by a new job that is started after loading into an ODS object is complete. If the activation process terminates, there can be no automatic update.

Automatically Updating Data from the ODS Object

With this indicator, you can establish that the ODS object data be automatically updated. Once it has been activated, the data is updated in the data targets. An init. update is carried out automatically with the first update. If the activation process terminates, there can be no automatic update. The update is carried out by a new job that is started once activation is complete.

Only activate automatic activation and updating if you can ensure that these processes do not overlap.

If you use process chains to guarantee serial processing of the process, these settings are not supported for the object (with the exception of setting the quality status). Then you have to include the automatic processes as process types in the process chain.

Also refer to the example for Including ODS Objects in Process Chains.

refer this link-