Multicube query issue

[Former Member]

Hi guys, i have a problem with the result of the query being run on a MultiProvider. Multicube is based on 4 cubes, COPA CCA I/O Planning Cube, Cost Centers/Order Commintments, Cost Centers/Orders Actuals, and the latest that was added is Purchasing Data. The query has contains Order and PO # (along with a few filters and a couple of restricted keyfigures). But each time i run the query with different variable entries, the PO #'s come as unassigned. What could be the problem? How can i diagnose it ?

[former_member188975 · Accepted solution]

Hi Farhan,

Is this the same issue as:

Can you do a LISTCUBE using Object Type MPRO and the name of your multiprovider. Try to recreate the query selections and filters and see if you get any values for PO#. You can also check the data in the Purchasing cube to see if it is available for reporting.

Hope this helps...

[Former Member · Accepted solution]

yeah its the same problem. the data is available for reporting...the problem i've descovered is that there are no PO #'s common in all the cubes. Or so i think is that problem. first of all in one of the cubes, there were no Orders...as in Order #'s. so if there are no corresponding order #'s, i guess I will not see the corresponding PO #'s either. Let me know wht u think

[Former Member]

Hi Farhan,

Please execute tcode LICTCUBE with object type = CUBE for EACH of your cubes that are in multiprovider.

Select whatever chars and KFs you want, better to use PO# as well. It's just to make sure that data in each cube are present and visible.

Then do the same with object type = MPRO for you multi cube.

Do you see any data in your cubes?

Best regards,

Eugene