Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
Oracle Analytics Cloud May 2025 Update The Oracle Analytics Cloud (OAC) May 2025 update enhances how users generate insights, engage with data, and distribute content
Poll: Oracle Analytics Community Website Satisfaction Tell us about your satisfaction with our newly redesigned Oracle Analytics Community Website.

Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How translate function LAG from discoverer to Oracle BI 12c

1

Views

1

Comments

User_8PPKU

User_8PPKU Rank 2 - Community Beginner

Apr 15, 2021 1:09PM edited Aug 13, 2024 5:14PM in Oracle Analytics Cloud and Server

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 ?

Tagged:

Function

0

Comments

[Deleted User] Rank 5 - Community Champion

Apr 15, 2021 3:15PM

You function-ship it to the database by using the EVALUATE function:

https://datacadamia.com/dat/obiee/obis/logical_sql/evaluate

0