OBIEE: Rank function

The Rank function in OBIEE are described as follows:

Syntax: RANK(expr)

Description: Calculates the rank for each value satisfying the numeric expression argument. The highest number is assigned a rank of 1, and each successive rank is assigned the next consecutive integer (2, 3, 4,…). If certain values are equal, they are assigned the same rank (for example, 1, 1, 1, 4, 5, 5, 7…).

But if you want to partition the rank by a specified column, you can use another syntax, not described in the tooltip:

RANK(measure by attribute)

For example to obtain the rank of “Product Sales” by “Fiscal Year” you can use:

RANK("Fact – Product Sales".Cost by "Calendar"."Fiscal Year")