Merging of Datarecords in a Cube coming from 2 ODS?

[i807185]

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

[Former Member · Accepted solution]

Hi Christian,

The ODS A has the characteristic "calmonth"

ODS B has the charcteristic as "Material" and

"Calmonth".

If you want to display the keyfigures of ODS A and ODS B, you can integrate the two in an multiprovider.

But since the characteristic material is not maintained in an ODS A, you cannot associate the key figures of two ODS in the report.

One thing you can do is to enhance the datasource for the ODS A so as to populate the material.

Hope this might help you with some idea.

Regards,

K.Manikandan.