✍ Kashif M
Trends

Sunday, 29 September 2013


AVERAGE FUNCTION IN OBIEE 11g


By on September 29, 2013

AVG (Average)

It calculates the average value of an expression in a result. It must take a numeric expression as its argument. It denotes the mean value of expression.

The denominator of AVG is the number of rows aggregated. For this reason, it is usually a mistake to use AVG(x) in a calculation in Oracle Business Intelligence. Instead, write the expression manually so that you can control both the numerator and denominator (x/y).

Syntax

AVG (numExpr)

Here numExpr is any expression that evaluates to a numeric value.

Look Before using AVG function, only with actual value.

AVERAGE FUNCTION IN OBIEE 11g
AVERAGE FUNCTION IN OBIEE 11g

Use the AVG function to calculate the Actual Sum values.

Formula used:

AVG (“W_DAILY_REV_DFT_F”.”Actual Sum”) Actual Sum is the measure column

AVERAGE FUNCTION IN OBIEE 11g
AVERAGE FUNCTION IN OBIEE 11g
Check the results, the new calculated AVG Column will calculated automatically and display the AVG values for the revenues.

AVERAGE FUNCTION IN OBIEE 11g
AVERAGE FUNCTION IN OBIEE 11g

Kashif
mkashu: AVERAGE FUNCTION IN OBIEE 11g
Review : Kashif | Kashif
Update: September 29, 2013 | Rating: 4.5

Comment for "AVERAGE FUNCTION IN OBIEE 11g"

1 comments:

  1. mkashu.blogspot.in/2013/09/uninstall-obiee-11g-in-windows.html

    ReplyDelete

Blog Archive