Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Reg: LEAST and GREATEST function in OBIEE

User_JZKI6Dec 13 2021

Hi Team,
We are using LEAST() and GREATEST() functions between 2 dates, for calculating date field in DB level need to do same logic in RDP/Report level.
Logic:
Case when to_char(LEAST(DATE1, DATE2),'YYYY') < 2018
then GREATEST(DATE1, DATE2) else LEAST(DATE1,DATE2) end as New Date
Can someone help how to use LEAST and GREATEST function in OBIEE RPD/Report level.
Version we are using: Oracle Business Intelligence 12.2.1.4.0
Thanks in Advance

Comments