SAP DSO or ODS

ODS


->  ODS STANDS FOR OPERATIONAL DATA STORE
->  IN BI7-WE CALL IT AS DATA STORE

->  IT IS A 2 DIMENSIONAL TABLE
->  IN BW 3.5 ODS IS OF 2 TYPES
     1>  STANDARD
     2>  TRANSACTIONAL
->  IN BI.7 ODS IS OF 3 TYPES
     1>  STANDARD
     2>  DIRECT UPDATE
     3>  WRITE OPTIMESED DATA STORE
->  WHEN WE CREATE ODS IT CREATS 3 TABLES INTERNALLY

     1> ACTIVE DATA TABLE
     2> NEW DATA TABLE
     3> CHANGE LOG TABLE

->  NAMING CONVENTIONS OF 3 TABLES

    ACTIVE DATA TABLE :  /BIC(C/0)/A{NAME OF ODS}00
    NEW DATA TABLE : /BI(C/0)/A{NAME OF ODS}40
    CHANGE LOG TABLE : SAME AS PSA TABLE

->  PROPERTY OF CUBE IS ADDITIVE
->  PROPERTY OF ODS IS OVER WRITE IF WE WANT WE CAN MAKE AS ADDITIVE

->  WHEN WE EXTRACT DATA INTO ODS IT GOES DIRECTLY INTO NEW DATA TABLE.
->  WHEN WE DO REPORTING ON ODS DATA COMES FROM ACTIVE DATA TABLE.

->  WHEN WE RUN INFO PACKAGE DATA GOES INTO NEW DATA TABLE BUT REQUEST WILL BE STILL IN YELLOW 
    BECAUSE DATA HAS NOT GONE INTO ACTIVE DATA TABLE FOR THAT WE PERFORM FUNCTION ACTIVATE
    DATA IN ODS BUT TO DO THIS REQUEST MUST BE IN GREEN FOR THAT WE SET QUALITY STATUS TO GREEN.

->  WHEN WE ACTIVATE DATA IN ODS IT TAKES ALL THE RECORDS FROM NEW DATA TABLE TO 
    ACTIVE DATA TABLE AND CROSS CHECKS THE RECORDS WHETHER ACTIVE DATA TABLE CONTAINS ANY 
    RECORDS WITH SAME PRIMARY KEYS IF THERE IS NO RECORD THEN IT ADDS ASNEW RECORD IF THERE
    IS ANY RECORD WITH SAME PRIMARY KEY THEN IT OVER WRITES IN ACTIVE DATA TABLE.

->  WHILE DOING THIS PROCESS IT MAINTAINS IMAGE IN CHANGE LOG TABLE.

->  WHEN WE DO REPORTING REPORT FETCHES DATA FROM  ACTIVE DATA TABLE.

->  WHEN  WE DO INIT OR FULL LOAD INTO DATA FETCHES FROM ACTIVE DATA TABLE AND CHANGE LOG TABLE.

->  WHEN WE ACTIVATE DATA IN ODS DATA TRANSFERS FROM NEW DATA TABLE TO ACTIVE DATA TABLE.
    AND CLEANS DAT IN NEW DATA TABLE.

->  WE LOAD DTA DIRECTLY INTO CUBE OR FROM DATA SOURCE TO ODS TO CUBE DEPENDS ON 
    DATA SOURCE FUNCTIONALITY.
->  IF DATA SOURCE ITSELF GIVES BEFORE IMAGE AND AFTER IMAGE THEN WE CAN LOAD DIRECTLY 
    INTO CUBE.
->  IF DATA SOURCE IS NOT GIVING ANY BEFORE IMAGE AND AFTER IMAGE THEN ODS IS MANDATORY.