I am not sure if my approach works so let me elaborate:
ODS1 contains trips on participant level.
The data in ODS1 looks like this:
Now I want to update the data to InfoCube IC_TP which looks like this:
- participant_id (has nav. attribute participant_type on which I want to report or do I have to select participant_type instead of participant_id as dimension???)
- number of trips (according to the data in ODS1 it should be "2" for jannuary)
- number of participants (according to the data in ODS1 it should be "5" for jannuary)
is this updating approach possible?