Oracle Analytics and AI

Need user preference date from BIP query on the report

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

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