Understanding the BI Connection Configuration

All of the OBIEE reports are located on the Oracle BI Application Server. In order to connect to the Oracle BI Application Server, one or more BI connections must be created for the users. Before you can create BI connections, you create a BI connection template.

A BI connection defines how the system connects to the Oracle BI Application Server for any given EnterpriseOne user. A BI connection includes information about the server, the port of the Oracle BI application server, the Oracle BI user and password used to establish the connection, and the root folder (optional). A BI connection can be added for any valid EnterpriseOne user, role, or *PUBLIC. They represent three different levels of mapping. An administrator can create one BI configuration for *PUBLIC to cover all of the EnterpriseOne users or create multiple BI connection records to perform mapping at various levels. If multiple BI connection records are created, the system uses the following rules:

  • The system uses the most specific BI connection configuration (user>role>public).

  • When the user logs in with a role of *All, the system prioritizes all roles of the user based on role sequence.