BW Self Transformation No Update (DSO 1 -> DSO 1)

[former_member238775]

Hi all,

I have a case where I have two characteristics (one of which being a key field) that I loaded incorrectly from the 1st transformation. I created a new transformation that changes my key field as a hard coded value in the target and a formula that changes the non-key field. When I ran the transformation the first time, it worked and I could see the correct fields. I had to make a change so I deleted those and tried to run again. This time it did not work. The key figures are set to overwrite, but I'm only needing to change 2 fields so I assume this is the correct path, but I'm confused on why the change is now not taking place.

Thanks in advance!

[former_member226999 · Accepted solution]

Is your original record not deleted?

What you have to do is using new transformation change the key field and other field (original record becomes the source of information). This will create a new record instead of changing the original one as the key field is changed. Now check if you can see both the records in display value, finally delete the original record using the key field as selection.

[former_member186399]

Hi Ashley,

If you are trying to change a key field, then its not the right approach. Key field will never get overwritten unless you are loading the same key field data or else it will create two separate line items in the DSO.

Regards

Gajesh

[former_member186445]

the best approach in this case would be to create a new DSO that you can use to temporarily store the data. So you load the data to the new DSO (with the mapping/modifications). Delete the data in the original DSO. And then load back from your new DSO to the original one.

M.

[former_member238775]

I was okay with creating a new key and deleting it. I was able to do this the first time and delete, but once transporting to another environment the transformation did not work at all. My original key field was the only one there and the one I wanted did not display.