Oracle Business Intelligence

Products Banner

Reg: LEAST and GREATEST function in OBIEE

Received Response
192
Views
6
Comments

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

Tagged:

Answers