Skip to Content
avatar image
Former Member

DTP DSO to CUBE Delta load

Hi Experts,

i have been searching for a while but I couldn't really find the explanation to my issue. So I have several DSO that I want to connect them to 1 infocube where the transaction data is stored. The thing is that when I first load the master data of the DSO to the Cube, it loads fine but then when I load the transaction data, which has similiar primary key like the master data of the DSO, it doesn't overwrite the IDs but it doubles them.

So the master data should come from the DSO and the transaction data is loaded to the Cube from another source with the same primary keys like the ones that are existing in DSO for the master data.

Is this maybe because Infocube does not allow overwritting? Or maybe because there are different requests ID? Could you please let me know any alternative way how can I load first the data of DSO in the Cube and then when I load the transaction data to Cube, the Id to be overwritted with the one coming from DSO.

I could make this work with Delta Init without Data transfer but I dont think that is the right way.

Please see the image below of the data in the cube.

Regards,

Regys

Prbl dtp.PNG (3.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 14, 2016 at 12:33 PM

    loads from different sources into the same cube, will have their own line in the cube, no overwriting is done, even with the same key.

    to have all on the same line, read one dso while loading the other one.

    or define the master data fields as attributes of a characteristic used in the transactional data dso.

    M.

    Add comment
    10|10000 characters needed characters exceeded