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 don't set this option, no time zone conversion occurs because the value is "unknown".
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
DefaultDataOffsetTimeZone
API Values — <Valid offset string>