Applies to:

SAP NetWeaver Business Warehouse (formerly BI). This will work on SAP BI  7.0 and further versions.

Summary :

This document will help to understand the various steps which happen during a data gets loaded to DSO and further to the cube.

We are focussing on the role of tables of standard DSO here .

Author: Arpit Khandelwal

Company: Accenture Services Pvt. Ltd.

Author Bio:

apk.PNG

Arpit Khandelwal is a SAP BI Consultant currently working with Accenture Services Private Limited. He has around 2 years of experience in BW/BI implementation and support projects. He has been particularly involved in Archiving Activities in SAP BW system.

Detailed Working ::

We have a simple data flow to explain standard DSO table’s working in a very simple manner.The document might be very long but each step has been explained very clearly to make the readers understand the process in a much better way.

Simple initial requirements to understand this document is that a standard DSO has 3 tables :

1) New Data

2) Active

3) Change Log

We will use the flat file load to explain the working of Delta load in standard DSO.

The snapshot of our initial Info Package (here after referred to as IP)

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

We are taking only a single record in our flat file to load the data in DSO.

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

After loading this in our standard DSO, we check all the 3 tables of the DSO to understand working of DSO here.

Before Activation

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

a) Data in New Table :

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


b) Data in Active Table :


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

c) Data in Change- Log table :

s6.PNG

After Activation

a) Data in New Table :

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

b) Data in Active Table :

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

c) Data in Change- Log table :

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

So, when we are activating the data , it is moving from new table to Active and Change Log tables.

Note that the Record Mode here in Change Log table is N.

Loading this data to further Cube ::


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

The data is same in cube as that in the DSO. This covers our half portion of the document.

Now, loading new data for same fields (account, center,etc.) in a new flat file ::

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

After loading this in our standard DSO, we will again check all the 3 tables of the DSO to understand working of DSO here.

Before Activation

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

a) Data in New Table :


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

b) Data in Active Table :


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

c) Data in Change- Log table :

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

So now before carrying out the activation, there will be no change in Active & Change Log table while the new data loaded will come till the New Table only.

After Activation

a) Data in New Table :


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

b) Data in Active Table :

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

c) Data in Change- Log table :

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

Here , we will get two entries each of the 1st file and 2nd file as RECORD MODE N and a negative value for 1st record already in Change-Log table as RECORD MODE X.


  1. RECORD MODE N –  New image is created when a new record comes in Change-log table.
  2. RECORD MODE X –  Once the data is already there in Change-log table it will get as reversed image in the next load to avoid duplicity of data in load to cube further.


This is necessary because the data which goes to further cube will be decided by the record mode only.

Loading this data to further Cube ::

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

The data is same in cube as that in the DSO’s Change-log for new image.



To report this post you need to login first.

10 Comments

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

  1. chandan praharaj

    The document explains good about the RECORDMODE N and X,But here I am rating it 3 as  it would be good if you can explain other RECORDMODE with screen shot and explanation.

    good doc, post more doc like this. 😎

    (0) 
  2. Rodrigo Rodrigues Rodas

    And whether the DSO has a key and the second load has a different characteristic (not key)?

    In others words, DSO key is Controlling Area, Company Code, CostCenter and Account and the first file is the same, but in second file the month is different (month 2) and month is not part of the DSO key. Thus, in DSO we are changing the record. What happens to the cube in this case?

    (0) 
  3. Suyash Pandey

    Arpit you need to clarify few things here for sanity :

    • ‘  ‘ — After Image not N when you load a new data in DSO there is 19 with after image
    • From DSO to cube what are you doing full or delta?

    Cheers,

    Suyash

    (0) 
  4. Ritesh Srivastava

    awesome Document.

    1- I have a doubt here , when you load 2nd records as “19” this is also new record and different. Why no image Value is showing in front of 19 Record.

    Please clarify.

    (0) 

Leave a Reply