Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

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
67
Views
1
Comments
Tushar Rathi
Tushar Rathi Rank 1 - Community Starter
in Oracle Analytics Publisher

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 5 - Community Champion
    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