Work with cumulative KF in the BEx

[Former Member]

Hi all,

I have created a cumulative KF in a query. Now, I would like to work with "conditions" (or even "exceptions") on this cumulative KF.

The problem is that "conditions" consider the actual ("internal") value of my KF and not the cumulative ("displayed") one...

Does somebody know how to resolve this issue?

Regards

[Former Member · Accepted solution]

A possible solution: Create a calculated keyfigure column that has the value of the cumulative KF. Base your condition on this calculated KF. The column with the calculated KF can be hidden so the users will not notice the difference.

[Former Member · Accepted solution]

I will try you solution as soon as possible... but I am very pessimistic about it : don't you think the new KF will react exactly as the cumulated one (display but not internal)? ==> no conditions possible on it.

[Former Member · Accepted solution]

We use this solution in some reports without problems.

[Former Member · Accepted solution]

I have created a CKF based on the Cumulated one. The showed results for this CKF are the non-cumulated values.

So I'm still not able to make any condition or exception on the "cumulated" value.

Maybe there is something I did wrong...?