Skip to Content
Author's profile photo Yogen Patil

Direct Update DSO in SAP BW

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 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 :



Data Supply

Standard DSO

Consist of 3 tables : Activation Queue, Table of active data, change log


Write Optimized DSO

only one table : Active table


Direct Update DSO

only one table : Active table


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.



Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Nice Document

      Author's profile photo KD Jain
      KD Jain

      Hi Yogen,

      Can you please clarify below points:

      1. By my understanding technical keys are available in Write optimized dso, but where in Direct update dso.

      2. If technical keys are not there how parral load is possible.

      3. Data is aggregated based on key fields.

      Please clarify my doubts.

      Author's profile photo Yogen Patil
      Yogen Patil
      Blog Post Author

      i) Write-Optimized DSO, the Key fields are Called Semantic keys.Along with Semantic Keys it maintains Technical Key for every record and this key is unique.Technical Key is made by Request ID , Package ID , Record No. & Data is loaded with help of DTP.

      ii) Direct Update DSO,the key fields will be decided based on the source tables or the data source which we are using. & Data is loaded from API's.

      Author's profile photo Tharun Kumar K C
      Tharun Kumar K C

      very useful.. thank you 🙂

      Author's profile photo Former Member
      Former Member

      thanks a lot. very useful

      Author's profile photo nayeer samsi
      nayeer samsi

      Useful document

      Author's profile photo Former Member
      Former Member

      It is very useful document for Freshers.. Thanks

      Author's profile photo Jalina Vincent
      Jalina Vincent

      Hi Yogen,

      Just want to know the property of direct Update DSO.

      Yesterday i loaded one set of data. Today i am loading another set of data. While loading, will it delete automatically 1st set of data and load 2nd set data ?


      Author's profile photo Yogen Patil
      Yogen Patil
      Blog Post Author

      Hi Jalina,

      If data is loaded with help of DTP's then only we can find DTP request in DSO but in case of Direct Update DSO data get loaded by using API.

      As data is not loaded with help of DTP you cant find request ID in DSO.

      For the other DSO's except direct update data loading will happen by using DTP but for direct update DSO data load will happen by using API not DTP.

      Every time you load data to a Direct update DSO, all the previous data gets deleted and loaded again with help of APD's / API.

      APD will normally have queries, transformation and joins on data & whole data will be loaded again.



      Author's profile photo Ipsita Kundu
      Ipsita Kundu

      Hello Yogen,

      Can you please tell me ,is it possible to load write optimised DSO using APD?


      Author's profile photo Ipsita Kundu
      Ipsita Kundu

      hello Yogen ,

      Can you please tell me, write Optimized DSO can be loaded using APD or not.


      Author's profile photo Yogen Patil
      Yogen Patil
      Blog Post Author

      Hi Ipsita,

      In write optimized DSO data get loaded with help of DTP, not with help of API. So  it is not possible to load data with help of APD.

      - Yogen

      Author's profile photo Former Member
      Former Member

      Hi Yogen,

      Could you please kindly let me know that is direct update DSO must be through APD? I think that can be other SAP datasources, right? Please clarify on me.



      Author's profile photo Tharun Kumar K C
      Tharun Kumar K C

      Hi Cherry,

                      Yes Direct update DSO must be loaded through APD. Alternatively you can load it by manual input in planning sequence or through an input enabled query using save back data option.