Oracle Analytics Publisher Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Publisher Forum

Categories

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

Need user preference date from BIP query on the report

Received Response
71
Views
1
Comments
Tushar Rathi
Tushar Rathi Rank 1 - Community Starter
in Oracle Analytics Publisher Forum

I have a requirement to show date difference based on user preference setup on the report output.

I need to handle this from BIP query to print on RTF report.

Please share any way to achieve this.

Regards,

Tushar

Answers

  • Hassan El Bouihi-Oracle
    Hassan El Bouihi-Oracle Rank 6 - Analytics & AI Lead
    edited Jul 17, 2023 6:01PM

    Hello Tushar,

    Please use the session variable XDO_USER_TIMEZONE to get the user time zone.

    Example:

    select :XDO_USER_TIMEZONE from dual

    Thank you

    Hassan