Master Data Attribute Deletion in BW

[tek_ib]

Hello,

We are loading "Business Partner" master data everyday with one of its attribute called "BP_Type"

We deleted selective attributes for few business partners in ECC but the m/data in BW is not updating, we delete those selected attributes manually in BW Maintain M/Data but the next day in loads back in after the load from ECC.

There are two extractors with multiple DTPs with FULL load and Delta loads everyday.

Here is the data flow:

Extractor > DSO > M/Data info object.... (DSO is also feeding some other info cubes as well).

I can not do selective deletion from DSO as it will delete the entire record whereas I only want to delete few attribute of the business partner. Also it is also feeding to another info cube.

How can I get rid of those few selected attributes of the business partner m/data ?

Note that I only want to delete few selective attribute from the entire set of Business Partner like below example:

Your help will be appreciated.

Thanks

[Abhishek_Hazra]

Hi tek_ib,

"We deleted selective attributes for few business partners in ECC but the m/data in BW is not updating" - What do you mean by deleted selective attributes? You cleaned off BP_Type for 0BPARTNER BP222358 & BP23253? And this does not get the changed values into the DSO? Your infoobject is getting the values most likely because the DSO is still holding the old values?

[tek_ib]

Hi @Abhishek

Yes it is coming from DSO but I can not delete the attribute from DSO because DSO is feeding another info cube plus it is a full load to my DSO from the extractor so even if I delete it from DSO it will be overwritten next day with the full load from the extractor.

Correct me if my understanding is wrong here.

Thanks

[Abhishek_Hazra]

Yes I understood that you can't delete from the DSO, but you said that you have deleted the attribute values from ECC right? I wonder then how does the full load from ECC bring the old values?

Best Regards,
Abhi

[tek_ib]

Thats exactly I am trying to find out. I assume it is loading back from DSO so regradless of the fact if ECC has deleted it it loads back to m/data infoobject from DSO.

So my question is how do I get rid of it from DSO. Is selective deletion is the only option I have ?

and even if I do selective deletion from DSO it deletes the entire record (line item) from the DSO not only that attribute. I just want that attribute field blank but still want to show the key field (business partner).

Any idea or solution ?

Thanks

[Abhishek_Hazra]

Hi tek_ib,
If having the data modified in the info object helps you out, I would suggest to implement a formula in the transformation rule mapping for the attribute between the DSO & info object, just assign blank when it gets the unwanted value for the attribute. Something like, (IF "BP_Type" = 'A12', '', "BP_Type"). This would assign blank value for the unwanted value 'A12' in next load (if full load, else you need to change it through maintain masterdata one last time).

Best Regards,
Abhi

[tek_ib]

Hi Abhi,

Thanks for the suggestion. I have thought of that to write a small code in End or field routine but it wont work because not all Business Partners needs to get rid of BP_Type A12. for example few Business Partners still required BP_Type = A12 but remaining Business Partners still need to show A12 in the BP_Type attribute.

By the way FYI, I already have code written in the field routine like this:

If SOURCE_FIELDS-BP_Type = 'A12'.

Result = 'A12'.

else

Result = ' '.

endif.

Do you think this code is causing an issue even if it is being deleted from ECC.

Thanks

[Abhishek_Hazra]

Hi tek_ib,

I thought you wanted to remove the value of BP_Type when it is 'A12' from your example, but this piece of code you shared would do exact opposite. However, coming to your question, no this would not cause the issue while loading from ECC if you have cleaned the data off in ECC itself, in that case you should expect blank values for BP_Type from ECC & they would pass on & overwrite the data in the aDSO. I would suggest to check in the PSA (if existing) what value is fetched from ECC.

Best Regards,
Abhi