Exception of average values

[Former Member]

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

[Former Member]

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 ...

[Former Member]

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?

[Former Member]

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.

[Former Member]

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..........

[Former Member]

Hi

I´ve tried this already with different combinations, but without any success.

Regards