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)
where:
A query can contain only one TOPN expression.
TOPN("Sales Measures".Dollars, 5 by Markets.Region)
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:
TOPN("Sales Measures".Dollars,@{MyPresentationVariable}{5} by Markets.Region)
TOPN("Sales Measures".Dollars,@{MyPresentationVariable}{5} by Markets.Region) <= @{MyPresentationVariable}{5}