Three types of DSO in BI 7.0

[Former Member]

Hi,

I went through the sap help documents related to the three types of DSO.

1. Standard

2. Direct Update

3. Write Optimized

Still not clearly understood in which case we use what kind of DSO's. Could any one explain me that in your own words.

I am new to BI, your explanation is appreciated.

What is this ADP process that is used using the Direct Update DSO.........Any docuements or links or info on it?

Thanks,

[Former Member · Accepted solution]

DataStore Objects for Direct Update

DataStore objects for direct update ensure that the data is available quickly. The data from this kind of DataStore object is accessed transactionally. The data is written to the DataStore object (possibly by several users at the same time) and reread as soon as possible.

It is not a replacement for the standard DataStore object. It is an additional function that can be used in special application contexts.

<b>APD -</b>

In the BI system, you can use a DataStore object for direct update as a data target for an analysis process

In the BI system data is collected from the heterogeneous databases in the various systems that the enterprise is using and is consolidated, managed, and staged for evaluation purposes. There is often further, valuable potential in this data.

This is completely new information that is displayed in the form of meaningful correlations between data but that is too well hidden or complex to be discovered by simple observation or intuition.

The Analysis Process Designer (APD) allows you to find and identify these hidden or complex relationships between data in a simple way. Various data transformations are provided for this purpose, such as statistical and mathematical calculations, data cleansing and structuring processes.

The results of the analysis are saved in BI InfoProviders or in CRM systems. They are available for all decision and application processes and thus can be decisive (strategically, tactically, and operatively).

Examples of analysis processes include the calculation of ABC classes, determination of frequency distribution or of scoring information.

http://help.sap.com/saphelp_nw04s/helpdata/en/49/7e960481916448b20134d471d36a6b/content.htm

<b>Standard DataStore Object</b> The standard DataStore object is filled with data during the extraction and load process in the BI system.

It has 3 tables - New , Active , Change log table

<b>Write-Optimized DataStore Objects</b>

Data that is loaded into write-optimized DataStore objects is available immediately for further processing.

You use write-optimized DataStore objects in the following scenarios:

&#9679; You use a write-optimized DataStore object as a temporary storage area for large sets of data if you are executing complex transformations for this data before it is written to the DataStore object. Subsequently, the data can be updated to further (smaller) InfoProviders. You only have to create the complex transformations once for all data.

&#9679; You use write-optimized DataStore objects as the EDW layer for saving data. Business rules are only applied when the data is updated to additional InfoProviders.

The system does not generate SIDs for write-optimized DataStore objects and you do not need to activate them. This means that you can save and further process data quickly. Reporting is possible on the basis of these DataStore objects. However, we recommend that you use them as a consolidation layer, and update the data to additional InfoProviders, standard DataStore objects, or InfoCubes.

http://help.sap.com/saphelp_nw04s/helpdata/en/f9/45503c242b4a67e10000000a114084/content.htm

Hope it Helps

Chetan

@CP..

[Former Member]

Standard DSO: It has three tables like 1.Activation Queue 2.Active table 3. Change log table

Whenever posting is done first data will load into Activation queue then it goes to active table to active the data, whenever you change the data, the changed data will go to change log table.

In this we have Keyfields and Datafields,

Data load through DTP

SID values can be generated

Data is available for reporting after activation

Write-optimized DSO: It has only 2tables 1. Active table 2. Changelog table

Whenever we do postings it goes to Active table, there is no need of activation, without activation also data is available for reporting

Data load through DTP

SID values can't be generated

It has Technical key, Semantic key as well as Data fields

Direct-Update DSO:

It has two tables 1.Active 2. Change log

Data provided using APIs(APD)

SIDs cannot be generated

It has Keyfileds and Data Fields

[Former Member]

Hi,

Help says:

Stan dard : Consists of three tables: activation queue, table of active data, change log

2) Possible of having Update rules

3) SID Generation for characterstics at the time of Activation

4) BEx Queries Possible

5) We can only add or overwrite the records for new data request

For direct update : Consists of the table of active data only

2) No Possiblity of having Update rules

3) NO SID Generation for characterstics and No concept of Activation

4) BEx Queries Possible

5) System deleted all existing records when we do new data request upload

Write-optimized : Consists of the table of active data only

2) Possible of having Update rules

3) NO SID Generation for characterstics and No concept of Activation

4) BEx Queries Possible

5) We can only add the records for new data request

Message was edited by:

Anil Kumar

[Former Member]

Modelling - APD Analysis Process Designer.

http://help.sap.com/saphelp_nw04s/helpdata/en/a5/2e953fc405330ee10000000a114084/content.htm

Hope it Helps

Chetan

@CP..

[Former Member]

Thanks Anil kumar Nice Information in a short way to understand

[Former Member]

Hi Anil, I am new to SAP BI, Please help me to sove this issue? DSO Actvation Failed in Process Chain? How you are going to

solve this issue step by step?

[Former Member]

Hi,

First you check the reason for that error in the process chain.

The reasons for the error in the activation of dtp can be unavailability of background process etc...

If it is due to no free background process during DSO activation, Repeat the DSO activation step in the process chain..

Please post the actual error in the PC.

Regards

Lekshmi

[Former Member]

Check the monitor for the dso as well. Check the record log for the packages loaded- it will give you a better idea of where the error lies

[Former Member]

Do a quick RSRV test on the ODS. If the results turn green just go ahead and repeat the ods activation step in the PC. Hope this helps.