Skip to Content
avatar image
Former Member

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

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Oct 12, 2016 at 09:16 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 12, 2016 at 09:03 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 13, 2016 at 04:48 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 17, 2016 at 08:44 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded