Process only error records to BPC

[SreekanthSurampally]

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..

[Former Member · Accepted solution]

They answer is YES.

First of all, are you loading those records as full load or delta?

If your load mode is full and you don't run Append then you don't need to clean the data - BPC will overwrite it.

If you are loading it in delta mode, then there is new Note that allows you to choose what to do with error records from last load - pick them up or ignore.

Regards,

Gersh