Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 106 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Provide special object Current Date as part of RPD in OBI Recruiting
Use Case and Business Need
In BO, we had a special objects folder which had "Current Date" object which used to populate localtimestamp.
In OBI Recruiting, we don't have any such object. But what we have is CURRENT_DATE function which only gives BI Server timestamp irrespective of the timezone where user is located.
When such condition is required as a filter we are forced to use EVALUATE function but it degrades the performance and using CURRENT_DATE function gives incorrect results.
Please provide this object as part of RPD.
Original Idea Number: ff2416bede
Comments
-
Are you asking a user Session variable Current Date that will pick up the user's local time?
0 -
Hi Ling,
In BO we have a dedicated object called as Current Date which is part of query, not sure technically how it can be implemented within OBI.
If session variable helps that would be great!
Thanks & Regards,
Kiran
0 -
Good idea.
0