Data Offset for Analyses and Dashboards

Administrators use this system setting to specify a time zone offset of the original data that users see in analyses and dashboards.

Enter an offset value that indicates the number of hours away from Greenwich Mean Time (GMT) time.

For example, to display values in United States Eastern Standard Time (EST), which is Greenwich Mean Time (GMT) - 5 hours, enter the value GMT-05:00 or the equivalent value in minutes -300.

If you leave this setting empty, Oracle Analytics interprets this as "unknown" and performs no time zone conversion.

If you enter 0, Oracle Analytics uses GMT to display data. If you enter 0 and set the Default User Time Zone system setting, Oracle Analytics uses the default user time zone to display data.

If you set the Default User Time Zone system setting and the user overrides it in the My Account Time Zone field, Oracle Analytics uses the user's specified time zone to display data.

Specifying a different offset value for each user

If you want to specify a different offset value where session variables can be used (for example, expressions, calculations), don't use the Default Data Offset Time Zone setting. Instead, set the system session variable DATA_TZ in the semantic model. See About Session Variables.

Valid Values

Valid offset string.

Apply Required

No.

Change Effective

After a few minutes.

Edition

Professional and Enterprise.

API Key and Values

API Key — 
DefaultDataOffsetTimeZone

API Values — <Valid offset string>

Documentation Links