Skip to Content
0
Former Member
Jan 24, 2007 at 11:54 AM

update data from ODS to InfoCube

16 Views

Hello Experts,

I want to update data from ODS_TP which contains

trips, participants, price per participant and trip date to an InfoCube IC_TP!

Therefore I have the following fields in IC_TP:

ZNOT (number of trips)

ZNOP (number of participants)

How can I accumulate all trips into ZNOT and

all participants into ZNOP?

the data in ODS_TP looks like this:

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

thanks

hiza