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

/wp-content/uploads/2013/08/a_266258.jpg

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

/wp-content/uploads/2013/08/b_266260.png

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)

/wp-content/uploads/2013/08/c_266261.png

  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.

/wp-content/uploads/2013/08/d_266262.png

/wp-content/uploads/2013/08/e_266263.png

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

/wp-content/uploads/2013/08/f_266264.png

/wp-content/uploads/2013/08/g_266265.jpg

To report this post you need to login first.

14 Comments

You must be Logged on to comment or reply to a post.

  1. 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.

    (0) 
    1. Yogen Patil 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.

      (0) 
  2. 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 ?

    Thanks.

    (0) 
    1. Yogen Patil 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.

      Regards,

      Yogen

      (0) 
    1. Yogen Patil 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

      (0) 
  3. cherry zhou

    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.

    Thanks,

    Cherry

    (0) 
    1. 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.

      Regards

      Tharun

      (0) 

Leave a Reply