Loading Master data and Transaction data
Master Data Flat file
We have created the Info Area , Info object Catalog and Info Objects
Once we create Info Objects SID table and Master data table (P table) gets Created without an SID Keys
/BIC/PENK_EID - Master Data Table Time Independent
/BIC/SENK_EID- SID Table
/BIC/SENK_EID - SID TABLE
SID TABLE does not have any values before data loading
/BIC/PENK_EID - Master data Table
Before Loading Master Data SID and P Table gets created without any fields.
Creation of Data Source for Master Data Loading ( Attributes )
Creating InfoPackage
Creating DSO to load Master Data
Creating Transformation between Data Source and DSO
Creating DTP to load Data to DSO
Data In New Data Table in DSO.
After giving Active Data we will get Data in Change log Table and Active Table
Data In Change log Table
Data in Active Table
Select Insert Characteristics as InfoProvider
Before Loading Master data SID Table and P Table did not have any values
After Loading Master data we have SID Keys and Values for SID Table and Master Data Table
Now we are going to load Transaction Data
Input for Transaction Data Loading
Data Source for Transaction Data
Creating Info Package
Creating DSO for Transaction Data
Creating Transformation between Data Source and DSO
Creating DTP between Data Source and DSO
Data in New Table
After Giving Activate Data will come to Change Log Table and Active Table.
Data in Change Log Table
Data in Active Table.
Data Loading from DSO to Cube
We have Create the Info Cube now Dimension tables will be created. No values will be present in the Table, Once we Load Master Data Dim IDs will be Generated Based on SID’s
/BIC/DENK_CU1 EMPLOYEE ID
Loading Transaction Data From DSO to Cube.
Creating Transformation between DSO and Cube
Creating DTP
Transaction Data in Cube
Before Loading Master Data SID Table gets created without any SID Keys
After Loading Master Data SID Keys Gets Generated in SID Table
Before Loading Transaction Data Dimension Table gets Created without any Dim ids and SID’s
After loading Transaction Data DIM IDs gets generated Based on SIDs in Master data in SID Table
Now I am Loading Transaction Data without Master Data Value in SID.
E5 Does not have any Master Data means ( no SID available in SID Table )
Delta load from Source system to DSO
Data in DSO’s Active Table
Now we are going to do Delta Load From DSO to CUBE
Dimension table after loading transaction Data without master data.
SID Table
P Table
Now Master Data loading after Transaction Data Loading E5
Data in Cube
Master Data Table
Now Loading Master Data with one more record
Lets see what happens
Data in PSA
Records in Active Data Table in DSO
Master data in Info Object
Master Data Sid Table
P Table
Dimension Tables
Listschema
Conclusion:
- If we load Master Data first SID Tables gets created and then when we Activate cube Dimension Table gets Created, Once We load Master Data SID TABLES will have SID Keys, and then when we load Transaction Data Dimension IDS will be created based of the SIDs in the SID Table.
- If we load Transaction Data without any Master Data Dimension Table DIM IDS & SID and SID Table, SID Keys Will is generated and Master data Table P Table will also have the Primary key Value (EID).
- If we Load Master Data without any Transaction Data, SID Table will have SID Keys no DIM ids will be generated in Dimension Table.
****************************