cancel
Showing results for 
Search instead for 
Did you mean: 

Does the Full load really remove previous requests and extract new data?

Former Member
0 Kudos

We wonder if the Full load does remove the previous requests or data and bring over new data?

For example, we extract data from a R3 table by using Full load. 1st day, we load data to R3 table, then extract the data to BW, then BW data contains only 1st day data. 2nd day, we delete R3 table data and load data for 2nd day only, then extract to BW still using the Full load, then what BW data should contain? both 1st day and 2nd day data? or 2nd day data only?

Any answer?

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Kevin

The answer to your question is <b>NO</b>.

You have the option of deleting a previous upload of the same data in the InfoPackage.

If you load to a cube all the uploads are added together. If you load to an ODS then a delta is automatically generated when activating ODS, one advantage of this is that you do not get double data if you load the same data twice.

Regards

German

Former Member
0 Kudos

hi All,

I am sorry that I forgot to mention that the data is extracted to a BW ODS other than a cube. When we conduct the 2nd day extract to the ODS, then the data with the same key would be overwritten, that would be out of question. My question is that if the 1st day data with different key would be removed from the ODS or still stay? Note: the update mode to the ODS is Full.

Thanks

former_member188975
Active Contributor
0 Kudos

Hi Kevin,

1st day data with different key would not be removed from the ODS. That data will stay...

Former Member
0 Kudos

Hi Kevin

Data in your ODS will remain with full updates. Note that you are implementing the delta when deleting and recalculating the R/3 table

Regards

Answers (3)

Answers (3)

0 Kudos

hi Kevin,

if you didn't delete 1st day's requst in bw,

then bw will contain 1st and 2nd day data.

hope this helps.

Former Member
0 Kudos

Hi Kevin,

What data the cube should have should be decided by the business requirement.

Current data load will delete the existing data only if that option has been selected in the Infopackage, else it is going to get appended.

      • You may assign points if helpful ****

Thanks,

Raj

former_member188975
Active Contributor
0 Kudos

Hi Kevin,

BW will contain all the data (Day 1 and Day 2). If you are loading to a cube, then all the data from Day 1 and Day 2 will be present in the cube. If you are loading in the ODS, there is a chance that some data is overwritten the second day.

But in no case is the previous data automatically deleted just by the load, unless you have made any deletion settings.

Hope this helps...