In Oracle Discoverer it is available the function LAG, that is used to compare values in different time periods .
So, for example, if I want to translate
LAG(field, 1)
in a formula of Oracle BI ?
How Can I do this ?
You function-ship it to the database by using the EVALUATE function:
https://datacadamia.com/dat/obiee/obis/logical_sql/evaluate