Skip to Content
0
Former Member
Nov 30, 2011 at 02:52 PM

DataLoad into Write-optimized DSO with DTP and semantic groups

30 Views

hi gurus,

i'm going crazy with my current problem.

i searched in the other posts of this topic, but i did not found a solution.

here my situation:

i created a w-o-DSO with semantic key (0ucinstalla, 0calmonth, zbelnum, 0unit) and three key figures.

now i'm loading from several cubes data into the DSO. (i need the historical data)

in every transformation, i implemented an expertroutine which collects the data into the result_package.

in the routine, i even clear the record number before collecting the result_rows.

in the DTPs, i'm using a semantic group for 0ucinstalla in order to select all rows for one 0ucinstalla into one data-package.

each DTP has to run one time in full mode.

but when i schedule the third DTP, i get the message: "duplicate record"

i checked the active data in dso. there was no record with that semantic key.

i found a record with the same 0ucinstalle for a diferent month - in my opinion, thats no duplicate record... 😊

is there a dependence between semantic key in DSO and semantic group in DTP?

how can i solve this error?

regards,

philipp