Error with Query on Multicube
I installed the inventory cube 0IC_C03 for a snapshot of the stock in the system. Since the organisation valuates the stock using a seperate moving average price it is stored in a custom R/3 table. I set up a seperated ODS and cube for getting this data into BW.
When i am trying to write a query picking 0Material from the inventory cube and the ZMPRICE from the custom cube the query fails.
Is there a way to match the material details in the custom cube and the inventory cube so that i can deliver it?