data cleansing functionality

28 Views

Hi, guys,

Now our customer wants to do data cleansing before loading data into infocube or ods, however the requirement for data cleansing is somewhat complicated as following,

1. Provider a user interface to let biz man to correct the error record;

2. can code logic to check the data rejection reason, such as field type is wrong, master data doesn't exist, and etc, and can prompt these reason message to assist business guy correct;

for the project background, they have some additional source systems besides SAP R/3, so they want to create a specific staging for data cleansing purpose, and because refer to my prior experience with some ETL tools, we can ask developer to write embeded program in informatica or datastage to check data quality and write down the rejection reason in a file to assist business man correct;

so if we want to use SAP BW PSA for this purpose, is it feasible? Can we modify PSA to add one column, 'rejection reason' and add some ABAP program here; or you guys have some other good options for this function.

Thanks a lot.

Regards, ls