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?