Multicube based on 4 cubes (Planning, Commitments, Actuals and Purchasing). Why does the PO number from the Purchasing cube NOT appear in a query without having to put a keyfigure from that cube? Example: I have all orders that we are analyzing with 0AMOUNT. but I will not get any PO number attached to that order if I dont put Net Sales which is in Purchasing cube. ANy way to overcome the problem?
The issue is similar to populating a cube without a key figure and there should always be a reference to the fact tables and the dim tables and hence you have to supply a key figure for any multiprovider using a cube. There must be a key figure from every cube. Otherwise it would be a join of dimensions alone whcih would not be the case with the design of a cube.