Skip to Content
  • In BW 3.5, we call DSO as Operational Data Storage
  • We use DSO’s to store data at detail level
  • In DSO, we can over write the data and add the data
  • DSO’s are of three types. They are

               1. Standard DSO

               2. Write optimized DSO

               3. Direct update DSO

Standard DSO:

  • It has three tables called Activation Queue/ New data table, active data table and Change log table
  • DSO has key fields and data fields
  • Key fields can only have characteristics
  • Data fields can have characteristics and key figures
  • Maximum number of key fields are 16
  • Maximum number of data fields are 749
  • Full Loads:
  • Delta Loads:

Note: When we do reporting on DSO, the records are always picked from Active data table

                                       Steps to create Standard DSO:

                                       Create necessary Info objects in before hand

  • Go to RSA1
  • Go to info provider section
  • Right click on info area
  • Select create DSO
  • Give technical name (in range of 3 to 9 characters)
  • Click on ‘Create’
  • Drag and drop necessary characteristics into Key Fields
  • Drag and drop necessary characteristics and key figures into Data Fields
  • Click on ‘Activate’

Note:

  • Property of Info cube is summation
  • Property of DSO is summation and over write. It happens only with key figures

Write optimized DSO:

  • It only has Active Data table, thereby we are saving the activation time and it makes loading faster
  • We use this DSO for loading and staging purpose
  • This DSO consists of following keys.
  • Technical Key: These are system generated (Data Package ID, Request ID and Record ID)
  • Semantic Key: These are similar to key fields in standard DSO. It is also called as Business Key. We use semantic keys, if we use this DSO for reporting purpose
  • Data fields: Consists of both key figures and characteristics

                                       Steps to create Write Optimized DSO:

  • Go to RSA1
  • Go to info provider section
  • Right click on info area
  • Select create DSO
  • Give technical name (in range of 3 to 9 characters)
  • Click on ‘Create’
  • Go to settings, select type of DSO to Write Optimized DSO
  • Drag and drop necessary characteristics and key figures into data fields
  • Click on Activate

                                       Scenario’s where we use Write Optimized DSO:

  • When the data is complex in nature
  • The DSO is used as first level of data flow
  • When the source system is not capable of providing delta records
  • When BI system gets the data from source system multiple times a day

Direct Update DSO:

  • It has Active data table
  • It is used in APD analysis (Analysis Process Designer)
To report this post you need to login first.

2 Comments

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

Leave a Reply