New Features for Oracle BI EE 11g Release 1 (11.1.1.5)

New Features for Oracle BI EE 11g Release 1 (11.1.1.5)

• Access to Oracle OLAP Data Sources
• Access to TimesTen Data Sources
• Ability to Connect to SAP/BW Data Sources Using a Native Connection
• Validation Utility to Validate Metadata Objects in a Repository
• Oracle BI EE now includes a validation utility to validate metadata objects. 
• New Diagramming Capability  :   The Physical and Business Model Diagrams have enhanced capabilities in this release, including an improved look-and-feel, the ability to display columns in table objects in the diagram, and new diagram options like auto-layout, marquee zoom, and zoom to fit.

OBI Priority Group Number for LTS

Setting Priority Group Numbers for Logical Table Sources

We can set priority group numbers to determine which logical table source should be used for queries for which there is more than one logical table source that can satisfy the requested set of columns.

Scenario:  You might have user queries that can be fulfilled by both a data warehouse and an OLTP source. Often, access to an operational system is "expensive," while access to a data warehouse is "cheap." In this situation, you can assign a higher priority to the data warehouse to ensure that all queries are fulfilled by the data warehouse if possible.

Note:  That the priority group of a given logical table source does not always ensure that a particular query will be fulfilled by that source. Priority group assignments are only one of many factors used by the Oracle BI Server to determine which logical table source to select for a given query. However, the logical table source priority is the most significant metric and is considered before any other cost metric.

To assign priority group numbers:  Rank your logical table sources in numeric order, with 0 being the highest-priority source. You can assign the same number to multiple sources. For ex, you can have two logical table sources in priority group 0, two logical table sources in priority group 1, and so on. Often, only two priority groups are necessary (0 and 1).Assigning priority groups is optional. All logical table sources are set to priority 0 by default.

System Session Variables

Here is the list of System Session Variables and their definitions : 

System Session Variables	Definitions
PROXY  & PROXYLEVEL	PROXY and PROXYLEVEL are used to authenticate proxy users in the act as functionality.
DATA_TZ or DATA_DISPLAY_TZ	Time zone setting
DISPLAYNAME	Used for Oracle BI Presentation Services. It contains the name that will be displayed to the user in the greeting in the Oracle BI Presentation Services user interface. It is also saved as the author field for catalog objects. For internal Oracle BI repository users (non database users), this variable is populated with the user's full name.
EMAIL	Contains the user’s default email address for use with Answers. If the delivery option of Answers is enabled, an email device using this address will be created for the user upon first log in. Users can override this address by changing their account settings in Oracle BI Presentation Services.
GROUP	Contains the groups to which the user belongs. These are used by both the Oracle BI Server and Oracle BI Presentation Services.
LAST_SYNCH_TIME and THIS_SYNCH_TIME	These two variables are set and tracked by Oracle BI Presentation Services to manage the synchronization of Oracle BI Disconnected Analytics.
LOGLEVEL	The value of LOGLEVEL (a number between 0 and 5) determines the Logging level that the Oracle BI Server will use for user queries. This system session variable overrides a variable defined in the Users object. If the Administrators Users object has a Logging level defined as 4 and the session variable LOGLEVEL defined in the repository has a value of 0 (zero), the value of 0 applies.
PORTALPATH	Used for Oracle BI Presentation Services. It identifies the default dashboard the user sees when logging in (the user can override this preference after logged on here : Settings → My Account → Preferences → “Default Dashboard”).
REQUESTKEY	Used for Oracle BI Presentation Services. Any users with the same non blank request key will share the same Presentation Server cache entries. This tells Oracle BI Presentation Services that these users have identical content filters and security in the Oracle BI Server. Sharing Presentation Server cache entries is a way to minimize unnecessary communication with the Oracle BI Server.
SKIN	Determines certain elements of the look and feel of the Oracle BI Presentation Services user interface. The user can alter some elements of the user interface by picking a style when logged on to Oracle BI Presentation Services. The SKIN variable points to an Oracle BI Presentation Services folder that contains the non alterable elements (for example, graphics such as GIF files). Such directories begin with sk_.
USER	OBIEE - User
PASSWORD	OBIEE - Password
WEBGROUPS	Specifies additional groups specific to Oracle BI Presentation Services, if any. The use of Presentation Services groups provides a mechanism for more granular content control.
WEBLANGUAGE	The WEBLANGUAGE variable contains the language of the user.
LOCALE	OBIEE two-letter (shown in the LOCALE parameter entry of NQSConfig.INI File)
DISABLE_CACHE_HIT	If this value has the value 1 for a request, then the BI server doesn't try to find a query cache.
DISABLE_CACHE_SEED	If this variable has the value 1, the result will not be seeded in the query cache.
PREFERRED_CURRENCY	This variable store the preferred currency value of the user.
REVERSIBLE_LTS_PRIORITY_SA_VEC	This system session variable permit to indicate the subject area where the priority group of the logical table source can be reversed. It permit with the help of the variable REVERSE_LTS_PRIORITY to dynamically select a source at run time.
REVERSED_LTS_PRIORITY_SA_VEC	This system session variable indicate all subject area where the priority group of the logical table source is permantely reversed.
REVERSE_LTS_PRIORITY	This system session variable is much more use as request variable to reverse the value of the priority group of the logical table source.