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

[SreekanthSurampally]

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.

[Former Member]

Hi Sreekanth,

Before uploading BW data into BPC, try "validate and process Transformation file", if there be an error or rejected records, you can rectified them at the same time.

Some of your records also get rejected due to master data absence.

Try to rectified all issues/correct rejected records, before upload the data to BPC

Regards

Rohit

[Former Member]

Hi Sreekanth,

You should always load master data before transaction data so that all new master data is in place.

you don't need to delete all the loaded data, in the next run BPC can overwrite all the existing data.

Andy