Miscellaneous Information About Oracle BI Applications Deployments
3-34
Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users
3.9.2 Using Initialization Blocks
Table 36
lists some of the initialization blocks common to all Oracle BI Applications
and their purposes. Initialization blocks that are specific to each Oracle BI Applications
area are not listed here.
To view the initialization blocks provided with Oracle BI Applications, open the
Variable Manager in the Oracle Business Intelligence Enterprise Edition
Administration Tool. For instructions, see Oracle Business Intelligence Server
Administration Guide.
3.9.3 Creating Custom Indexes in Siebel Source Databases for Incremental Load
Performance
To maximize performance for Siebel CRM, you can implement indexes using SQL files
that are available in the ORACLE_HOME\biapps\dwrep directory.
Table 37
describes
the SQL files that are appropriate for the specified applications.
Table 36
Initialization Blocks and Their Purposes
Initialization Block
Purpose
Authorization
Calculates user's responsibilities from the database.
Authentication
Authenticates against the database and verifies the user exists as a
operational application user.
External Metadata
Strings
Gets the translated value of metadata strings for the user's locale. This
initialization block is critical to Intelligence Dashboards in international
deployment.
LOCALE
Sets the user's locale specification in the Oracle BI Server.
Login Properties
Gets user's login properties, such as full name, from the database. This
initialization block also sets the logging level of the users. By default, the
log level is 0 for all users. If you wish to generate Oracle BI query logs
for all users, this initialization block should be updated by changing the
default value as well as the value in the initialization SQL.
Default System
Language ID
Sets the variable OLTP_LANG_ID by querying the operational
application database.
Organizations for
Org-based Security
Queries the operational application database to get the organization
membership for each user. It sets the variable ORGANIZATION.
Primary Owner ID
Sets the primary owner ID based on the user login ID.
Primary Position ID
Queries the operational application database to set the variable
PRIMARY_POSTN_ID.
Warehouse Refresh
Date
Sets several time-based variables such as CURRENT_YEAR.
ETL Run Date
Retrieves the ETL run date.
ETL Default
Currency
Retrieves the default currency.
Table 37
SQL files for Siebel transactional databases
Application Name
SQL File Name
Horizontal Application
PerfIndex_Horizontal.sql
Industry Application
PerfIndex_Industry.sql