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,