Skip to Content
0
Former Member
Mar 05, 2009 at 10:21 PM

Selection on Global Calculated Key Figure problem

17 Views

Hi all,

I've got a Calculated key figure, made up of 2 key figures and 2 restricted key figures, saved to a homogenous multiprovider (Customer Sales). this works fine as is.

However, when you create a selection in BEx QD, that limits the CKF further by Distribution channel, and view the result, the result seems to be multiplied by a value to the effect of 2.8???

If you view the CKF by itself its fine (though not limited to what it needs to be).

As an example.

Say sales for a distribution channel was 1 million dollars. Sales overall was 2 million dollars. If i drag in my CKF (and have NO characteristics), it comes up with 2 million dollars.

If i limit it to 1 sales office, no issues, I get that sales office's value. However, if i limit it to a distribution channel, i get roughly 2.8 million dollars.

Any ideas? I can't see the logic in this. Perhaps someone knows of the issue/has seen a note or something regarding this, cos its got me scratchin my head?

Cheers