Provide special object Current Date as part of RPD in OBI Recruiting — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Provide special object Current Date as part of RPD in OBI Recruiting

11
Views
3
Comments

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

Current Date object vs CURRENT_DATE function.PNG

1
1 votes

Submitted · Last Updated

Comments

  • User720640-Oracle
    User720640-Oracle Rank 5 - Community Champion

    Are you asking a user Session variable Current Date that will pick up the user's local time?

  • Kiran Shenvi
    Kiran Shenvi Rank 4 - Community Specialist

    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

     

  • Ahmed Maher K.
    Ahmed Maher K. Rank 6 - Analytics Lead

    Good idea.