BOTTOMN FUNCTION IN OBIEE 11G

BOTTOMN

Bottom N function displays the lowest n values of the expression argument from 1 to n, 1 corresponding to the lowest numeric value.

The BOTTOMN function operates on the values returned in the result set. A request can contain only one BOTTOMN expression.

Syntax

BOTTOMN(numExpr, integer)

numExpr is any expression that evaluates to a numeric value.

integer is any positive integer.

Represents the bottom number of rankings displayed in the result set, 1 being the lowest rank.

Example,

BOTTOMN (“measure Column”,5)

It shows the Bottom low values up to 5 rows, and it ranks as lowest value as 1 and 2…

Here I am going to calculate for one revenue according to the monthly base for the year of Bottom N ranks.

Take a look of report before using bottom ranks.



Here I used Total revenue actual values according to the month. Calculate the revenue of bottom ranks based on the months.

Negative values are the lowest values.

According to the bottom 5 , the 1st lowest value will be May= -3779467.1

2nd lowest value will be June = - 3093948.9 and so on.

Calculation formula used here is

BottomN (“Measure column “, 5)

BOTTOMN FUNCTION IN OBIEE 11G

BOTTOMN (“W_DAILY_REV_DFT_F”.”Actual Sum”,5)

W_DAILY_REV_DFT_F Actual Sum denotes the measure column.

Bottom 5 values have to show denoted by 5 next to the measure column.

Take a look on the result of 5 Bottom Revenue.

BOTTOMN FUNCTION IN OBIEE 11G