The table below describes the session variables and the elements in the instanceconfig.xml file with which you set time zones.
When you include elements in the instanceconfig.xml file, you specify the time zone that all users see. When you use session variables, you can specify a different time zone for each user. If you use session variables and you specify values for the appropriate elements in the instanceconfig.xml file, then the values of the session variables override the settings in the instanceconfig.xml file.
Note:
Certain system session variables such as, USER or ROLES, cannot be overridden by request variables. Other system session variables, such as DATA_TZ and DATA_DISPLAY_TZ (Timezone), can be overridden if configured in the Oracle BI Administration Tool.
For more information, see Working with Repository Variables in Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition.
| Element | Session Variable | Description | Value |
|---|---|---|---|
|
DefaultDataOffset |
DATA_TZ |
The time zone offset of the original data. To enable the time zone to be converted so that users see the appropriate zone, you must set the value of this element or variable. If you do not set this option, then no time zone conversion occurs because the value is "unknown". For example, suppose you want to convert to Eastern Standard Time (EST), which is Greenwich Mean Time (GMT) - 5. You must specify this value to enable the conversion to EST. |
An offset that indicates the number of hours away from GMT time. For example: "GMT-05:00" or "-300", which means minus 5 hours. |
|
DefaultDataDisplay |
DATA_DISPLAY_TZ |
Specifies the time zone to use for displaying data. If you do not set this option, then the value is the User-Preferred Time Zone. |
One of the time zones that are specified in the TimeZones.xml file. |
|
DefaultUserPreferred |
TIMEZONE |
Specifies the users' default preferred time zone before they select their own in the My Account dialog. If you do not set this option, then the value is the local time zone from Oracle BI Presentation Services. |
One of the time zones that are specified in the TimeZones.xml file. |
|
Logging |
Not applicable |
The time zone of the time stamps that appear in log files that are generated by Presentation Services. If you do not set this option, then the value is the local time zone from Presentation Services |
One of the time zones that are specified in the TimeZones.xml file. |
|
TimeZone |
Not applicable |
The parent element for the elements that modify the preferred time zone. A child of the ServerInstance element. |
Not applicable |