Errors while data loading...!!!

[Former Member]

Hi BW Experts,

How is it possible to correct errors in PSA. Even if it is corrected, what happens when in future full update is needed to be done. Does correcting error data at PSA means to correct it in the source system also, say like a flatfile.

Please shed as much light as possible on this topic for me.

Thanks in Advance.

Regards,

Giftedbrain.

[Former Member]

Hi Giftedbrain

It's possible to Correct the data in PSA, But if you wna tto correct the data the request should be deleted from the data target(ods or Cube), if the request is there , it will not allow you to edit the data...

if your doing the full update the data in the cube or ods will be overwritten..

Yes.if the error is in flat file you can correct the data in the flatfile and reload the data..

Generally if you have less no of errors then we can edit in the PSA.It is not feasible to correct the huge no of errors in PSA ..it is better to correct in the source itself..

Hope the above helps..

bye

Shu Moh..

[Former Member]

Hi Shu Moh,

Could you please elaborate on how data is corrected in the source system. Is it handled by someone (a specialist) or do we have to do it. In that case, if the source system is other than FlatFile, say Oracle, and the BW person doesn't know Oracle, what would be the scenario.

Are there any special techniques to be followed when correcting huge amount of error data...???

Thanks in Advance.

Regards,

Giftedbrain.