January 22, 2012

Setup Tables filling without Locking Users in SAP BI

While filling setup tables, the first step we think about is locking the users.Why we think about locking users is we might miss the records posted by the users when we are filling setup tables. The next doubt we get is " Can't we fill without locking users..?".
Yes, we can fill the setup tables without locking users if data source supports that feature.

We can fill the setup tables and load the data to BI in 2 ways.

1) Init with data transfer option:

In this method we need to do the below steps.

i) Lock the users in R3 system
ii) Delete the data in setup tables for specific application component
iii) Fill the setup tables.
iv) Run the Info Package with option "Init with data transfer"
v) Unlock the users in R3 system.

This is very time consuming process, because we need to lock the users until the data reaches to BI system.This affects client business.

2) Init without data transfer and full repair:

In this method we need to do the below steps.

i) Lock the users in R3 system
ii) Delete the data in setup tables for specific application component
iii) Fill the setup tables.
iv) Run the Info package with option "init without data transfer".This sets the delta queue and timestamp for delta in R3 system.
v) Unlock the users in R3 system
vi) Load the data to BI system using Full repair Info Package.

In this method, after data is loaded to setup tables we can unlock the users in R3 system. This is better than the first option.

We have one more option in Info Package called "Early Delta Initialization"

Early Delta Initialization:

In this one we do the initialization before filling setup tables. So that users can post the records when we are performing setup tables filling. we will get the posted records in next delta run.

In this method we need to do the below steps.

i) Run the Info Package with option " early delta initialization". This will enable the delta queue and setup the timestamp for delta in system
ii) Delete the data in setup tables for specific application component
iii) Fill the setup tables.
iv) Load the setup tables data to BI using full repair IP.

How to check whether Data source supports for Early Delta Initialization?

We can check this in table ROOSOURCE.
i) Go to SE16 --> table name and enter
ii) In the next screen give the data source name and execute.
iii) If field ZDD_ABLE in the result has value X, then data supports for early delta initialization.
iv) If it has space, then it doesn't support.


Hope it will be useful.

Refer the below links for more details.

http://help.sap.com/saphelp_nw04/helpdata/en/80/1a65dce07211d2acb80000e829fbfe/frameset.htm
http://forums.sdn.sap.com/thread.jspa?threadID=2120981

You can also go through BW 350 -- Data Acquisition book.

No comments:

Post a Comment