help! Modeling of ODS object

[Former Member]

We have a requirement to display all CRM sales contracts with their associated historical sales, even if the sales contract has no historical sales history.

We have 2 ODS objects:

0CRM_CNT2(CRM Sales Contract Master)

ZRG_O16(Sales history for sales contracts)

Each ODS has the following key characteristics that need to be in the input selection and/or in the display output of the report.

0CRM_CNT2

- Contract Number

- Contract Start Date

- Contract End Date

- Material Price

ZCRG_O16

- Fiscal Year/Period

- Material Number

- Net Sales Value(KF)

On the input selection screen would like the ability to enter a date range for the <b>Contract End Date</b> to then select the domain of sales contracts from 0CRM_CNT2(which would then become input into ZCRG_016 for the relevant sales contract history), as well as then enter a <b>Fiscal Year/Period</b> from which to select and display sales history from ZCRG_O16.

So the report output would have the following on one row:

Contract Number, Start Date, End Date, Material, Contract Price, FYP1$, FYP2$,FYP3$,FYP4$

Need a way to combine 0CRM_CNT2 with ZCRG_O16, but using an infoset or multiprovider is only showing results for contracts that exist in ZCRG_O16(and not all contracts from 0CRM_CNT2)

Anyone experience this type of issue in the past and/or suggest how to achieve through modeling or on the front-end BEX?

Thank you in advance.

Regards,

-Anthony

[Former Member]

It is just depends on what the key in each ODSes you have, I am sure either multiprovider or infoset will work, specially with infoset you need to do Left Outer Join instead of inner Join, again the problem with infoset will be: Performance will be bad and if you are getting key figures from both the ODSes then infoset will produce a wrong results.

Multiprovider will be the best solution as long as you have the same characteristics which can select from both odses.

thanks.

Wond