This chapter includes the following sections:
Time zones are used throughout Oracle Business Intelligence for a variety of purposes.
A time stamp can indicate when an object was changed, and users can specify a time for an agent to run. Users often are most comfortable working in their local time zones. As the administrator, you can configure the preferred time zones for users for various components.
Before you begin to set preferred time zones, see the next table for information about where time zones are used.
Type | Description |
---|---|
Oracle BI Server |
If you have users in time zones that are different from the zone for Presentation Services, then you as the administrator can specify the time stamps that those users see in Oracle Business Intelligence. For example, suppose the server is located in the Pacific time zone in the United States. You can specify that users on the east coast of the United States see time stamps that are displayed in Eastern Standard Time. If you make no time zone settings and if a user does not specify a preferred time zone using the My Account dialog, then that user sees time displayed according to the local time zone for Presentation Services. For information about how users specify their preferred time zones, see User's Guide for Oracle Business Intelligence Enterprise Edition. |
Data from the database |
The administrator specifies the time zone for the data that is retrieved from the database. If you make no time zone settings, then users see the time stamp data in the time zone of the original data as set by the administrator. |
Content that is displayed in Oracle Business Intelligence |
Users who create analyses can specify the time zone that is displayed in their analyses and dashboard prompts. This specification overrides those made by you as the administrator and by end users if they have previously used the column in their queries and have set the time zone. If the specified display time zone supports daylight saving time, then the timestamp values that are displayed are automatically adjusted for daylight saving time. |
General time stamps that indicate when events happen |
End users can specify the time zone for many general stamps including the following ones:
|
Log files |
Log files contain time stamps for various activities. |
You can override the user’s time zone selection with one that is consistent for all users.
Use the following procedure to set time zones for users.
Time zones are presented in a specific order.
The actual time zone in which various types of content are displayed follows a precedence order described in the table below. An item with a lower number overrides one with a higher number. For example, Item 1 takes precedence over Item 2.
Time Zone For | Determined By |
---|---|
Data |
|
Data display |
|
General time stamps (not including column data and log files) |
|
Log file information |
|
Users can select the time zone they want presented in the interface.
The user-preferred time zone is determined by the following:
The specification that a user makes in the My Account dialog. Users can select a time zone in which they prefer to view content.
For information about setting the time zone preference on the My Account dialog: Preferences tab, see User's Guide for Oracle Business Intelligence Enterprise Edition.
The setting of the TIMEZONE session variable.
The setting of the DefaultUserPreferred element in the instanceconfig.xml file.
Time zone specifications are stored in their own file.
Whenever a time zone specification is displayed in a list, or as the value of a session variable or element in the instanceconfig.xml file, the specification originates from the TimeZones.xml file, located in:
orahome/bi/bifoundation/timezone
The TimeZones.xml file contains nearly all time zones from around the world. You need not add zones to this file, but you can edit this file if you care to. You can delete those zones that users in your organization do not use.
Specifying Time Zone Values
Various editors show the ampersand that appears in time zone values in one of two ways: either the ampersand character itself or its escape sequence. Use care when entering a time zone value, as follows:
When you use the ampersand in the value of a session variable, include the ampersand character (&) in the value, such as Pacific Time (US & Canada); Tijuana.
When you use the ampersand in the value of an element in the Oracle BI Presentation Services configuration file (instanceconfig.xml), include the escape sequence for the ampersand in the value, such as Pacific Time (US & Canada); Tijuana.
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.
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 |
The following shows a sample section of the instanceconfig.xml file in which the TimeZone element has been added.
<TimeZone> <DefaultDataOffset>0</DefaultDataOffset> <Logging>(GMT-08:00) Pacific Time (US & Canada); Tijuana</Logging> <DefaultUserPreferred>(GMT-08:00) Pacific Time (US & Canada); Tijuana</DefaultUserPreferred> <DefaultDataDisplay>(GMT-06:00) Central Time (US & Canada); Tijuana</DefaultDataDisplay>
</TimeZone>