Skip to Content
0
Former Member
Jan 06, 2011 at 03:40 PM

Query on MC (on agg level on cube) not input ready

37 Views

Hello xperts,

aggregation level A is placed on infoprovider P and contains all characterstics and KYFs from P.

A query containing KYFs X,Y and Z built on A is input ready for KYFs X,Y and Z.

The query displays the correct values for

X = 10

Y = 20

Z = 30

So far everything is good 😀 ... but then it gets nasty!

Multiprovider M sits on top of A (and InfoPovider P is also included in M).

In an identical copy of above query built on multiprovider M the keyfigures (rows) are restricted through 0INFOPROVIDER:

row 1 with KYF X: 0INFOPROVIDER = A

row 2 with KYF Y: 0INFOPROVIDER = A + P

row 3 with KYF Z: 0INFOPROVIDER = P

The query is NOT input ready and the values displayed are:

X = nil

Y = nil

Z = 30

Why???

Key figures in M are mapped:

X from A only

Y from A and P

Z from P only

Changing how the key figure in M are mapped as per below does not help:

X from A and P

Y from A and P

Z from A and P

The query is in change mode, X,Y and Z are marked as planning. restricting by 0INFOPROVIDER in the filter does not help either.

We are on 7.0 SP 23.

Any ideas out there?