Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

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