Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 26 Oracle Analytics and AI Lounge
- 309 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.6K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 118 Oracle Analytics and AI Trainings
- 23 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OTBI Global Level Function sysdate issue
trying to get ssysdate from Global Value Functions by the following syntax but return null value, how can get the sysdate from Global Value Functions in OTBI( Fusion Cloud)
CURRENT_DATE
FORMAT_DATE(SYSDATE,'yyyymmdd')
FORMAT_DATE(CURRENT_DATE ,'yyyymmdd')
to_char(sysdate,'yyyymmdd')
how can achieve the sysdate in formate yyyymmdd from Global Values Function.
Answers
-
Doesn't OTBI just have the exact same formula editor as OBIEE?
Does NOW() work?
0 -
Thk Christian for your response
Please can you explain ?
0 -
In OBI another function is "NOW()" without quotes
0 -
I tried as above NOW() without quotes but getting the following error.
Formula Parser: Function {0} is not found.
0 -
What about if you ask in an OTBI forum?
OTBI maybe use OBIEE as base, but has it's own things.
OBIEE in any screen where you can write a formula has a button 'f(...)' : do you have it? Click on it and go through the various entries till you find what you are after. If you don't have that button ask this thread to be moved in the OTBI forum as it isn't an OBIEE question (because NOW() is an OBIEE function).
0 -
The only place for OTBI is Cloud Customer Connect:
https://cloudcustomerconnect.oracle.com/resources/a670a2ff88/summary
Maybe OP can get an answer there.
0
