MultiProvider Query results not shown

[Former Member]

Hello Experts,

I have a Multiprovider defined over a InfoCube and a ODS, the InfoCube contains transactional data of Purchasing such as PO number, material number etc. and the ODS just contains data related to Material its material number, Unit of measure and Standard Price.

When I create a query to show the material number and PO number in rows

and the standard Price (of material coming from ODS) in columns, the result shows me the Standard price of the material next to a not assigned(#) record of the PO number and the remaining PO numbers do not show any value under the Standard Price column. We are expected to have the Standard Price to be shown against all the records where the material is used.

Please suggest how to acheive this goal.

Thanks and regards,

Sonu.

[Former Member · Accepted solution]

Which is the common field between the ODS and the Cube. You must have PO number as the key to join the Cube and ODS. Check the multi provider definition.

Ravi Thothadri

[Former Member · Accepted solution]

0material is the common field between the ODS and the InfoCube.

[Former Member]

You are trying to achieve a 'join' with a multiprovider.

This is only possible when you use 'constant selection' - an example is <a href="/people/prakash.darji/blog/2006/09/19/the-hidden-secret-of-constant-selection.

[Former Member]

Hi Ajay,

Thank you for your reply and the information. As per the given example in the blog I created a new constant selection on the Key figure Standard Price with 0material set to constant value. The result is giving me some unrelated large value.

Regards,

SONU

[Former Member]

Thank you Ajay your piece of information was really helpful.