Skip to Content
Author's profile photo Former Member

Data Store Object (DSO)

  • 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)

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Jarret Pazahanick
      Jarret Pazahanick

      Hi Saideep


      Just a heads up that you should remove the SAPMENTOR tag on both your posts as they are for Mentors only.


      Thanks,


      Jarret

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Jarret,

      Sure. I will definitely do it.

      Thanks for the update.

      Regards,

      Saideep.