Skip to Content
0
Apr 03, 2006 at 12:26 AM

Merging of Datarecords in a Cube coming from 2 ODS?

17 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).

<b>ODS A</b> 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...

<b>ODS B</b> delivers the following record:

Material (0MATERIAL)

0CALMONTH: 200602

Total Number of Shipments: ZTOTSHIP: 1000 Units

These records are updated into an Infocube.

<b>For Calculations in the Cube</b> 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.

<b>The record in the Cube should look as follows:</b>

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</b>

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