Skip to end of metadata
Go to start of metadata

DSO (Data Store Object):-

* DSO is 2 dimensional

* Property of DSO is Overwrite

 When creating a DSO we have to specify Key fields and Data Fields.

* All the Info objects which are specified as key fields in the DSO will act as primary key in the Active Data table.

* All the info objects which are specified as Data fields in the DSO will act as non - Key columns in the Active data table.

* Max. No of Key fields is 16

* We cannot have info objects of type Key figures acting as key fields of a DSO.

* Max. No of data fields is: 1000

* When we create the DSO, it creates 3 tables

            a) New Data Table

            b) Active data Table

            c) Change log Table

New Data Table:-

* When we load the data to the DSO, initially the data will be loaded to New Data table.

* Naming Convention of New Data Table:-

            /BI(C/0)/AXXXXXX40

            Ex: - ZDSO   /BIC/AZDSO40

 In New Data table:  Request no, Data Packet No, Record No  fields will be acting as the Primary key and all other key fields and Data fields will be acting as non - key Columns.

Active Data Table :-

* When we do reporting on DSO, data comes from Active Data Table.

Naming Convention of Active Data Table :-

            /BI(C/0)/AXXXXXX00

            Ex :- ZDSO   /BIC/AZDSO00

 In Active Data table, Key fields will be acting the primary key and Data fields will be acting as the non - key columns.

Change Log Table:-

 This table will hold the registry of all the records coming into the Active Data table with different images.

New image

Before image

After image

* Naming Convention of Change Log Table:-

            /BIC/B000*

* In change log table:  Request no, Data Packet No, Record No, Partition Number  fields will be acting as the Primary key and all other key fields and Data fields will be acting as non - key Columns.

* Loading Data from DSO to Info Cube:-

* If you load the Info Package with (Full/Initialize Delta update) it extracts data from Active Data Table.

* If you load the Info Package with ( Delta update ) it extracts data from Change log Table.

How does the Overwrite Functionality work in a DSO?

       when we load data into DSO, initially the data is loaded into New Data table. By using "Set quality status to OK" we convert the request status from yellow to green. once the request status is green we "Activate the DATA in DSO" - It deletes the records in the new Data table and then moves the records from new Data table to Active data table by overwriting the records if it finds the records with the same key field combination and maintains respective entries in change log table.

 How to delete data in the DSO?

1) Delete Data

2) Delete Data based on the request

Note: - it deletes the request and the entire request above it

3) Selective Deletion

Note: - When we do selective deletion in the DSO it deletes data only in the Active Data table, but not in the Change Log.

4) Deleting the contents of Change Log

Note:-

1) Do not condense the request into one

2) Process the request serially

Update Modes:-

1) Full Update:-

                        When we schedule the Info Package with FULL update, It extracts all the records from the source system to SAP BW with respective to Data Selections only.

2) Initialize Delta Update:-

                        When we schedule the Info Package with Initialize Delta update, It extracts all the records from the source system to SAP BW with respective to Data Selections only and enables us to run the delta.

 Note: - With whatever the Data Selections we run the Initialize Delta Update with the same Selections Delta has to run.(Mandatory)

3) Delta Update:-

    When we schedule the Info Package with DELTA update, It extracts all the records which are newly added or modified since the last update.

  • No labels