Table 25. Initialization Blocks and Their Purposes
|
|
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. |
Orgs 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. |