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 New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
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 Fusion Data Intelligence

Categories

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

How to get the latest completion date along with the new due date? (Learning Assignment)

Received Response

61

Views

1

Comments

Kobe Chavez

Kobe Chavez Rank 1 - Community Starter

Mar 28, 2023 3:33AM edited Aug 13, 2024 7:46PM in Oracle Fusion Data Intelligence

Summary:

We want to get in the report the latest completion date of the learner and the new due date in each course in 1 row for each learner. However, we are getting 2 rows. Is our requirement possible? Please check the attached screenshot and the SQL we created.

MicrosoftTeams-image (12).png

Below is the SQL used.

Orginal SQL.txt

Thank you!

Tagged:

0

Answers

Raghavan p-Oracle Rank 5 - Community Champion

Mar 29, 2023 11:25AM

Hi Kobe,

You may try the pivot table.

https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-4E6D9DBB-0029-4F1C-ACC0-6FD48F7C68A3.htm#BIPRD2283

Regards,

Raghavan P

1