Obiee Ceim


The TopN function in OBIEE permit to perform a TopN analysis.

The TOPN function operates on the values returned in the result set.

When you add it as a formula column in an answer, the data are automatically filtered. You don't need to add a special topN filter.


TOPN (n_expression, n)


  • n_expression is any expression that evaluates to a numerical value.
  • n. The N of TopN which is any positive integer. It Represents the top number of rankings displayed in the result set, 1 being the highest rank.

A query can contain only one TOPN expression.


TopN for the whole rapport

Obiee Topn Global Scope

Obiee Topn Global Scope Result

TopN by section

TOPN("Sales Measures".Dollars, 5 by Markets.Region)

Obiee Topn By

The N as parameter

Just create a dashboard prompt with the help of a presentation column with the number data type to set up a presentation variable and change:

  • the formula column
TOPN("Sales Measures".Dollars,@{MyPresentationVariable}{5} by Markets.Region)
TOPN("Sales Measures".Dollars,@{MyPresentationVariable}{5} by Markets.Region) <= @{MyPresentationVariable}{5}

Documentation / Reference

Discover More
Obiee Ceim
OBIEE - (Display Function|Derived Measures) (Rank, TopN, Median, )

Oracle BI Answers simplifies the use of derived measures i.e. measures that are computed on a query result set such as ranks, Ntiles, standard deviations, running totals, moving averages, and moving medians....
Obiee Ceim
OBIEE - BottomN function

The BottomN function is an aggregate function. See also the TopN function for more example and information. The BottomN function applies a filter on the Bottom Number (See ). where: BottomNumber...
Obiee Ceim
OBIEE - Functions

The home page of OBIEE functions of the logical sql and from BI Server. See Logical SQL Reference

Share this page:
Follow us:
Task Runner