cancel
Showing results for 
Search instead for 
Did you mean: 

Multicube Problem

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member184494
Active Contributor
0 Kudos

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.

Arun

Former Member
0 Kudos

Thanks for the reply. So you think this has nothing to do with the definition of the MultiProvider? And you are sure that including a KF from Purchasing is a must ?