About Time Zones (Preview)

Oracle Analytics provides time zone support for both subject areas and datasets so all users can view the values for columns with a DateTime or timestamp data type in the right time zone in workbooks.

Time zone configuration is available for preview. Ask your administrator to turn on the Enable Time Zone option in System Settings. See Preview Options.

For example, suppose you have a table visualization showing the product sales for each order date where the Order Date column has a data type of DateTime. The Order Date values in the table display their timestamp based on how the time zone settings are configured.

Description of the illustration time_zones_example_gmt-3.png

Time zones can be specified for subject areas and datasets, and you can specify your user time zone.

• The time zone for all subject areas is set by your administrator in the Console.
• The time zone for a dataset is set individually by the dataset owner. See Set the Time Zone for a Dataset (Preview).
• You set your preferred time zone in your user profile. See Set Your Preferred Time Zone (Preview).

Administrators can also configure additional time zone system settings in the Console to apply a default time zones to users.

In order for a time zone shift to apply in a workbook, both the time zone of the source data and the time zone you as a user want to view it in must be defined.