Direct Update DSO in SAP BW

[yogen_patil]

The document is aimed at all those who are at beginner level in BW. I am trying to give some information about Direct Update DSO and how to find process chain name which includes APD for direct update DSO. Content is purely based on my work experience & learning’s.

Applies to:

SAP BI/BW 7.0 and above.

DSO:

DSO stands from “DATA STORE OBJECT”. DSO’s have a 2-dimensional flat database table that contains key figures and characteristics. Data can be aggregated as well be over-written into DSO. We can use DSO’s for direct reporting but usually we use InfoCube.

Types of DSO :

Type	Structure	Data Supply
Standard DSO	Consist of 3 tables : Activation Queue, Table of active data, change log	Via DTP
Write Optimized DSO	only one table : Active table	Via DTP
Direct Update DSO	only one table : Active table	Via APD

Direct Update DSO :

Direct update DSO ensures that the data is available quickly, and can be written to the DSO by several users at the same time. So when we use this DSO , data get updated in active table directly which reduces time of activation process like Standard DSO.

Key Points :

• Ø SID’s can’t be generated in such DSO.
• Ø Data records with same key are not aggregated in such DSO.
• Ø Every record have its own technical key.
• Ø Supports parallel load.
• Ø While creating DSO we need to specify type of DSO. So in this case choose option - “Direct Update”.

T code – RSA1

APD  (Analysis Process Designer):

The Analysis Process Designer is a workbench with a graphical user interface for creating, executing, and monitoring analysis processes of loading data. APD analysis results will be stored into active table of direct update DSO.

T Code -  RSANWB

Finding chain for Direct update DSO

Business Scenario : When we work with Direct update DSO and we need to track data load but we don’t know how it get loaded/by which APD into DSO. We can’t find chain name directly as there are no requests in direct update DSO administration.

1. Step 1: Find APD name for DSO using table RSANT_PROCESSI (T Code : SE16)

1. Step 2: Search APD name related to DSO into BW (Use t code RSANWB to display APD).

1. Step 3: Check monitor to find execution or frequency of APD.

1. Step 4: Check process chain name in job log of APD.