on 2006 Jul 07 11:49 AM
Hi all
I have a problem with an exception which is defined in BEx Analyser.
The key figure is a valeue in percentage an defined as "Average of all Values <> 0". I have defined to show values >50% in green, but in the query some values (not all) which are >50% (e.g. 83%) are not marked in green, and some values are marked correct.
In other queries, where the same key figure is used but as single values where "calculate result as..." is not defined, the exeption works correct. Just when using the average values it makes the problem.
Any ideas?
Regards
Sabine
Create a condition to filter the Values with 0 ( If you really don't want to show those rows).
Then change the query as the other query avoiding the formula "Average of all Value <> 0".
I think there is "Average of all Value <> 0" and exception combination is misbehaving.
Regs
Gopi.
Assign points if it helps ...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Also if I use "Average of all value" the exception is not always correct.
My feeling is, that the exception don´t access to the average value. Could it be possible that the system choose one of the basic values which are used for calculation of the average? E.g. there are 2 values for calculating the average 40% and 80% with the average of 60% (should be green, but it isn´t) and the system uses for the exception 40% instead of 60%. Could this case be possible?
I don't clearly understand the behaviour of BW.Have you tried Formula Collision? If Exception is treated as a formula internally then there may be a collision between Average and Exception.
Formula collision may help Average to take precedence and then it may force the Exception to get it applied.
Sorry Sabine I don't have data to test and I never come across so don't think I am putting u in a loop.
Regs
Gopi.
Hi,
In the exception check the 'Validity Area of Exception' tab. Select the relevant characteristic against which the exception on key figure should give....
Hope this helps you..........
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.