Format Options
You use these options to configure default currency and time zone settings for analyses and dashboards.
| System Setting | More Information |
|---|---|
| Default Data Offset Time Zone |
Specifies 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 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. Edition: Enterprise only |
| Currencies XML |
Defines the default currency that's displayed for currency data in analyses and dashboards. For example, you can change from American dollars ($) to Euros (E). Edition: Enterprise only |
| Default User Preferred Time Zone |
Specifies a default preferred time zone that users see in analyses and dashboards before they select their own in the My Account Preferences dialog. If you don't set this option, Oracle Analytics uses the local time zone. Specifying a different time zone 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 User Preferred Time Zone setting. Instead, set the system session variable TIMEZONE in the semantic model. Edition: Enterprise only |
| Default Time Zone for Date Calculations |
Specifies the time zone used for evaluating date calculations such as getting the current date/time, truncating datetime values to a date, and extracting time fields from date/time expressions. Edition: Professional and Enterprise |
| User Currency Preferences XML |
Determines whether users see a Currency option in their My Account preferences dialog and the list of currencies available to them. If you provide the Currency option, users can select in which currency they prefer to view columns of currency data in analyses and dashboards. Edition: Enterprise only |