cancel
Showing results for 
Search instead for 
Did you mean: 

DTP DSO to CUBE Delta load

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member186445
Active Contributor
0 Kudos

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.

Answers (0)