Merging of Datarecords in a Cube coming from 2 ODS?

18 Views

Hi all,

I hope someone out there can help me or tell me if the following is possible.

I have 2 ODS (ODS A and ODS B).

ODS A delivers the following record:

0CALMONTH: 200602

ZSHIPD -Total number of Shipment Days in the Month: 20

ZSHIPMOP - Number of Shipment Days passed in the Month: 14

These records are updated daily. ZSHIPD stays constant during a month, ZSHIPMOP is like a counter and starts at 1, 2, 3...

ODS B delivers the following record:

Material (0MATERIAL)

0CALMONTH: 200602

Total Number of Shipments: ZTOTSHIP: 1000 Units

These records are updated into an Infocube.

For Calculations in the Cube I would need

ZSHIPD (Total number of Shipment Days in the Month) and ZSHIPMOP(Number of Shipment Days passed in the Month) that is delivered from ODS A attached to the record delivered from ODS B.

The record in the Cube should look as follows:

Material (0MATERIAL)

0CALMONTH: 200602

Total Number of Shipments: ZTOTSHIP: 1000 Units

Total number of Shipment Days in the Month ZSHIPD: 20

Number of Shipment Days passed in the Month ZSHIPMOP: 14

Is there any way to achieve this? I would appreciate any input on that a lot? Coding in update rules? Modeling?

Thank you very much

Christian