What happens to records created when filling setup tables without deleting delta queue?

[Former Member]

Hi All,

My question is in regards to deleting and reloading our Inventory cube in BI. It is a custom z cube but we are using the 2LIS_03_BF and 2LIS_03_UM extractors to load it. Because we are using AFS we also used the 2LIS_AF_STOCK_INITIALIZATION extractor as well. I don't want to delete the entire cube as you all know that the timing of loading goods movement data can be very tricky with regards to business down time and locking users out which is impossible for us at the moment. What I am thinking is deleting a subset of data from the cube (plant 1000 for example) and then doing a full load of plant 1000 from our ECC system and going through all of the plants until all have been reloaded. I figure this would cause the least amount of downtime for the business.

My only issue is deleting and filling the setup tables in ECC. Since I am not deleting the delta queues, while I delete and fill the setup tables what will happen to newly created records? will they get lost or will they sit in the queue LBWQ until I run my delta queue collection job again?

Thank you,

Anthony

[former_member202718]

Hi Anthony,

Its always recommended to have User Lock out for the LO Datasources.

You may replicate the number of records if you dont lock the Users or May loose out records and this may landup in Mismatch of Data.

Your Question

Since I am not deleting the delta queues, while I delete and fill the setup tables what will happen to newly created records? will they get lost or will they sit in the queue LBWQ until I run my delta queue collection job again

Full Load and Delta  Load

Assume that you have a Document number 101 for Quantity 100 which is created in 22 Nov 2013 and you are loading it through Full Load and is there in PSA and then at the same time an User is changing the Quantity  to 250 which will get captured in the Delta Queue (LBWQ) and in turn will flow to RSA7 and then to PSA ,the quantity will be 250.

Delta Load and Full Load

And if you run delta first then do a Full Load then that will have a negetive impact on that Record.The Quantity will be 100.

Hope this gives some understanding.

rgds

SVU

[former_member182196]

a simple answer for your question.

if your user is not locked at the same time when you filling the setup table, then the records will save in 2 place at the same time at data base table and and lbwq. after that when you schedule IP for full records same records will come into BW which is there in setup table and in delta which there in LBWQ so the data redundancy will occurs.

If your data flow is data Source > PSA > DSO (With overwrite mode) > IC .

Nothing will happen but flow is without DSo then data will aggregate at cube level.

I hope this is clear your doubt.

Regards,

SM

[Former Member]

HI,

I agree with Satendra.

I did this kind of stuff lot of times.

My Flow is data Source > PSA > DSO (With overwrite mode) > IC . I never faced any Issue.

Thanks & Regards,

Anil

[RamanKorrapati]

Hi Anthony,

"while I delete and fill the setup tables what will happen to newly created records? will they get lost or will they sit in the queue LBWQ until I run my delta queue collection job again?"

While deleting setup tables nothing will be happen to newly creating or changed records. deletion will effect on only set up table not on base tables.

before completion of filling setup tables if any record(specific to plant 1000) was saved that record will come into setup table as well as into delta also.

if your delta was with selections and plant 1000 was not included then it won't come in delta loads.

if your init without any selections then above record will comes into LBWQ and RSA7---> psa. it leads duplication.

Do one thing, without locks, better to fill setup tables at 0 business hours or on weekend. even though no guarantee. but as my guess weekend there will be no business as crismus eve and users will be off.

Thanks

[Former Member]

Hi Raman,

What I actually meant was when I fill the setup tables.

My plan is to not delete the init and then reinit the datasource. It was to delete plant 1000 data from my cube and then run a full load on only plant 1000 from ECC, back into my cube.

I tested in our sandbox (2 week old copy of production) filling the setup tables and they took several hours, even when breaking it up by plant. This is goods movement data so we will have 10's of millions of records.

[RamanKorrapati]

Hi,

Seems like you misunderstood when i said init. am not saying delete init and reinit.

If your existing init is with selections on plant and included 1000 then data will be duplicate. because same record will come thru delta load and setup table --> full load also.(assuming as new record with plant 1000 was created while filling setup tables).

if init with selections and plant 1000 was excluded then no duplicate record into bw.

if no init selections, then also you will get duplicate record of plant 1000

tell me about your init? is it with selections or without selections as of now?

I think you know that as we load delta records with selection wise only when we do init with selections.

Thanks

[Former Member]

I wouldn't be loading another init in my plan above, I would be loading Full repair requests, filtered by plant. I will also deleting the corresponding plant data from my cube beforehand so as to avoid duplicate records.

The init has a filter on creation date =

20060101-20070531;

20070601-20071231;

20080101-20080531;

20080601-20201231;

19000101-20051231;

I don't the reason fall the inits, but that is what is there and includes all our data in ECC.

Thanks

[RamanKorrapati]

ok. your init have selections on posting date. you can delete and refill setup tables. load data into psa with proper selections thru repair full load. it won't leads duplication as my guess. because your posting date all are less than today date.

[Former Member]

Right, but my concern is actually with loading the setup tables and the creation of new records at the same time. will the new records go to the delta queue or get lost?

[RamanKorrapati]

before completion of filing setup tables if new record was saved which is related to plant 1000. then it will come into setup tables, but thru delta it won't come into psa. because your init with posting date selection(posting date dec 17/18/ not inluded).

if your new record saved after the filling of setup tables then that record won't capture into setup tables also.