Skip to Content
0
Former Member
Feb 26, 2009 at 03:42 PM

How BW 3.5 load data from ODS to cube (chaneglog or active table)

417 Views

Hi,

I am trying to understand how BW load data from ODS to cube. Is it reading active table or changelog table. It is not clear for me.

I have an ODS where I deleted all the changelog Data via RSA1,

modeling, PSA. I went into the ODS manage, I check the content of the

changelog table 0 records and I check the content of active data 728

records.

I run a full and also a INIT infopackage from the ODS to the cube and 728 records

was transfered and added to the cube, I was expected no records because

the changelog of the ODS is empty

Can you explain this please.

Do you think it reads each records from the active table of the ODS and

check if there is some changelog records (ODSR requests) , if no

records exist in te changelog it will load the active records only to

the cube ? if there is changelog records (ODSR requests), it will load

the changelog records to the cube ?

I saw also that if in the infopackage from ODS to the cube I load to

PSA also in the settings, the requests are created (REQU_ requests) in

the changelog table. Those records in the changelog table are they

process when we upload from ODS to cube ?

thank you