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)