Understanding the OAS Connection Configuration

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

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

  • The system uses the most specific OAS 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.