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

Hi,

use IFrame

Frank
Branislav Nemec
Hi,

Never tried swf in ADF Faces 10g, but usually I use <f:verbatime> </f:verbatime> to include JSP or DIV or some other non JSF element

Branislav
John Stegeman
verbatim, not verbatime ;)

zaki, amr, bebo agogo memo.

Those are lovely names for forum posts
Branislav Nemec
Hi John,

you are fast... thanks for the correction. I don't know why I always misspell this tag name ?:|

Branislav
Hi,

whatever solution you choose, keep in mind that such an addition cannot be cancelled at runtime and might skow down the page loading process

Frank
1 - 5