Our users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries before we proceed to update all the report code. Parameters have an option whether to be input in UTC using the ignore timezone flag. So if the “ignore time zone” option is checked then no date conversions are needed is what we assume. Is this correct? Similarly internal sysdate and current_date are in UTC and when comparing with other table date fields which are all in UTC, so we believe we don’t need a date conversion in such cases. All date conversions in where clause impact report performance. Will all these TZ conversion modified report outputs be in sync with system/standard report outputs? Does standard reports display based on timezone preferences? How do we take care of Dates on OTBI/FRS reports for timezone related updates? Thanks Abhilash

We decided to modify the query with conversion of the timestamp columns so we reduce the load of the post processor. thanks all.

Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Analytics Publisher

Accepted answer

649

Views

Comments