updating data from ODS to InfoCube

[Former Member]

Hello experts,

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:

ODS1:

trip_id___participant_id___price_____trip date

__101_____1___________25.00_____20070112

__101_____27__________12.50_____20070112

__102_____21__________55.00_____20070124

__102_____7___________55.00_____20070124

__102_____15__________35.00_____20070124

Now I want to update the data to InfoCube IC_TP which looks like this:

IC_TP:

dimensions:

- time

- 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???)

measures:

- price

- 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?

thanx

hiza

[Former Member · Accepted solution]

The aproach is posible.

map date and participant_id directly in update rules, key figures as sum and number of participans always 1.

If participant_type is navigational attribute you can do reporting based on it.