Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

DSO( Data Store Object):-
-------------------------------
# 2 dimensional
# property of ods : Overwrite

# When creating a ODS we specify Key fields and Data Fields.

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

# All the info objects which are specified as Data fields in the ODS will act as non - Key coloumns 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 an ODS.

# Max. no of data fields is : 1000

# when we create the ODS, it creates 3 tables 
 a) Active data Table
 b) New Data Table
 c) Change log Table

# Active Data Table :-
-----------------------
# When we do reporting on ODS, data comes from Active Data Table.

# Naming Convention of Active Data Table :- 
 /BI(C/0)/AXXXXXX00
 eX :- ZODS  -> /BIC/AZODS00

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

# New Data Table:-
------------------
# When we load the data to the ODS, initially the data will be loaded to New Data table.

# Naming Convention of New Data Table :- 
 /BI(C/0)/AXXXXXX40
 eX :- ZODS  -> /BIC/AZODS40

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

# Change Log Table:-
----------------------
# This table will hold the registry of all the records coming into the Active Data table with different images ( New, Before, After).

# Naming Convention of Change Log Table :- 
 /BIC/B000#

# In cHANGE lOG table:  Request no, Data Packet No, Record No, Partition Number  fileds will be acting as the Primary key and all other key fileds and Data fields will be acting as non - key Coloumns.

# Loading Data from ODS 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 Chnage log Table.

# How does the Overwrite Functionality work in a ODS?
---------------------------------------------
when we load data into ODS, 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 ODS" - It delets the records in the new Data table and then moves the records from new Data table to Activa 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 ODS?
--------------------------------
1) Delete Data
2) Delete Data based on the request
note:- it deletes the request and all the request above it
3) Selective Deletion
Note :- When we do selective deletion in the ods 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 what ever 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