Monday, October 22, 2007

Minimize the Reporting Downtime during the initial data load

Detailed steps per scenario:
Common steps executed in SAP ERP system and BI to initialize the delta handling1. Stop booking in SAP ERP2. Fill Setup tables in SAP ERP e.g. for logistic (DataSource: 2LIS_03_BF)3. Init delta InfoPackage with or w/o data transfer, dependent on the scenarioScenario A: Init delta InfoPackage with data transferScenario B and C: Init delta InfoPackage w/o data transfer4. Start booking in SAP ERP5. Schedule delta Load data with normal process chain (including Delta InfoPackage and delta DTP)
(A) Get the historical data out of the source system directly into the InfoProviderA1. Stop Delta Process Chain (5)A2. Load data with full InfoPackage and SelectionsA3. Delta DTP to propagate the data into the InfoProviderA4. Start Delta Process Chain (5)
(B) Get the historical data out of the source system into the PSA first and not directly into the InfoProvider B1. Stop Delta Process Chain (5)B2. Load data with full InfoPackage and Selections into the PSA (store the selection criterias)B3. Init DTP w/o data transferB4. Schedule Delta Process Chain (5)
(C) Load the historical data from the PSA into the InfoProvider C1. Stop Delta Process Chain (5)C2. Load a Full DTP with same selection criteria in B2 from the PSA into the InfoCubeC3. Start Delta Process Chain (5)

No comments: