cancel
Showing results for 
Search instead for 
Did you mean: 

data cleansing functionality

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi ls,

For your scenario I would go with loading the data into a Custom table and then provide access to the users to view the content and modify the data. The Z table would have 2 additional columns - One for approve and the other for reject reason. Now for the Custom table create a datasource in the BW System and load all the "approved" data into the Data target.

Hope this helps.

Bye

Dinesh

Former Member
0 Kudos

Hi,

I think PSA is exact the correct place for such kind of cleansing

/manfred

Former Member
0 Kudos

Hi,

would you please provide some detail solution on that?

regards, ls