Categories
- All Categories
- Oracle Analytics Learning Hub
- 26 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 234 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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
