OBIEE - Last/First function (Point in Time measure)

Obiee Ceim


Function that selects the first/last returned value of the expression argument.


FIRST (expression)
LAST (expression)

where expression is any expression.


You cannot use it in Logical SQL statements. It must be used in the repository.


By default, the FIRST/LAST function operates at the most detailed level specified of all dimension.

For example, if you have:

  • a time dimension defined with hierarchy levels year, month, day
  • a geographic store dimension defined with hierarchy levels county, state, zip, store

the FIRST/LAST function returns the first/last value for the combination day/store on each level. (i.e. even if the report asks a month summary for instance).

To limit the FIRST/LAST function, you must define an dimension-specific aggregation rules in the repository.


Bad Performance

You should not use the FIRST/LAST function as the first dimension-specific aggregate rule. It might cause queries to occurs on large numbers of rows.

Documentation / Reference

Discover More
Obiee Ceim
OBIEE - Functions

The home page of OBIEE functions of the logical sql and from BI Server. See Logical SQL Reference
Obiee Data Is Dense
OBIEE - Repository Aggregation rules based on dimension (dimension-specific aggregate)

Obiee offer the possibility to have differents measure aggregation rule based on the dimension. This functionality is really tied to the last and first function (in order to define its grain ?) ...
Obiee Data Is Dense
OBIEE - What means Data is dense ?

When setting up a aggregate rules for a measure column, you can specify that data is dense only if all the logical table sources to which it is mapped are dense. In a logical column if you check “Based...

Share this page:
Follow us:
Task Runner