DTP DSO to CUBE Delta load
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.