Introduction
Update method is used to get the updated data coming from the source system to BI system at Info package level. We can set update methods in the update tab of the info package.
The update methods in the info package are:
1. Full Update
2. Delta Update
3. Initialize Delta Process
(I) Initialize with data transfer
(II) Initialize without data transfer
(III) Early Delta Initialization
1.Full Update
Full update extracts the full data from source system to PSA in BI7 every time.
2. Delta Update
Delta update extracts delta records only from the BW delta queue in the source system to BI system.
We must initialize the delta in order to get delta records, otherwise it is not possible to load delta records.
The following are the 4 delta types for the data source in the system.
F: Flat file provides the delta
E: Extractor determines the delta, Ex: LIS, COPA
D: Application determines the delta, Ex: LO, FI-AR/AP
A: Use ALE change log delta
Note: We can know the delta properties from ROOSOURCE table in the source system with SE16 transaction code.
3.Initialize Delta Process
To get the delta records, one must initialize the delta process. While initializing the delta process, the system will generate a flag: Initialize option for the source system in (scheduler menu of info package) BI and BW delta queue per the data source in the source system (RSA7). This enables the time stamp mechanism.
Initialize with data transfer
If you select this option, It extracts the init data from source system to BI system and allows delta functionality.
Steps for initialize with data transfer
Lock the users in the source system
Delete the contents of the setup tables for the specific application component in source system(T code: LBWG).
Fill the setup tables (SBIW or OLI*BW, use 1,2,3...in place of * according to the application ).
Run the info package with initialize with data transfer.
unlock the users in the system
Note: This is very time consuming process, because we need to lock the users until data reaches to the BI system.This effects the client business.
Initialize without data transfer
In some cases, init is successful but someone has deleted the init flag. In order to set the flag again to perform the delta load without disturbing the data, we execute IP with this option.
Steps for initialize without data transfer
Lock the users in the source system
Delete the setup tables content for the specific application component.
Fill the setup tables
Run the IP with the option: Initialize without data transfer.
Unlock the users in the source system
Load data to BI system using repair full request info package
Note: In this method, after data is loaded to setup tables we can unlock the users in source system. this is better option than initialize with data transfer option.
Early Delta Initialization
In this option, we can do the delta initialization before filling the setup tables.So that users can post the documents when we are filling the setup tables.We will get the posted records in the next delta run
Steps for early delta initialization
Run the Info package with early delta initialization option.This will enable the BW delta queue and setup the time stamp for delta in the source system.
Delete the setup tables for the application component
Fill the setup tables
Load the setup table data using repair full request (scheduler menu option of info package) info package
How to check whether the data source supports early delta initialization or not?
Go to SE16 in ECC, give table name: ROOSOURCE and enter
In the next screen give data source like 2lis_02_sdr(purchase document header data source) name and enter
if field ZDD_ABLE has a value 'X', then the data source supports early delta initialization
If the filed has space, then the data source does not support early delta initialization.