Need help on how to get the data in query of the multicube
We are trying to have the two cubes data ( Sales cube, Delivery cube ) in a query by means of Multicube.
We thought that system it self would match sales documents number and against the document number will give both the details of cube!
but that was the case not to be. when i had included the both sales order info objects numbers and run the query , in one column it was showing the sales order number and on the alongside it , it is showing junk values, where that has to be filled by the sales document of the other cube or we expected it to be the sales document number of the other cube.
is there anyway that in the query, sales document is matched, and we get the data of both the cubes pertaining to that sales document number?