cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Process only error records to BPC

SreekanthSurampally
Active Contributor
0 Kudos
236

Hi, I am loading the data from BW to BPC, using Load data from Infoprovider,  sometimes it ends with warning and some of the data records get rejected may be due to dimension values do not exist already or may be with any other error.

In this situation, only succesful records are loaded to BPC cube, In order to correct the rejected records, I am clearing the data in BPC for the selections I loaded just now, then correct the Dimension members for the failed ones, then re-process the entire data load using the same Data package.

I am wondering is there any better way to handle it,  in BW we got several options in DTP while uploading them, error records can be written to Error stack and then we can process only them after correcting it etc..

View Entire Topic
SreekanthSurampally
Active Contributor
0 Kudos

Thank you Andy and Gersh, Currently I am loading the full load, I always had a doubt that, Overwrite option does not overwrite the records correctly becaues of the request number characteristic, after tests, I confirmed that, Full + Overwrite should always be fine, no need to clear the previous load data.

We are planning to leverage delta capability of DM package also, I will explore more on the option specified by Gersh to correct the error records,

I am closing the thread.