BEx queries may now be connected to SAP BO 4.0 (SAP Business Objects 4.0) using a BICS (Business Intelligence Consumer Services) connection, commonly known as an OLAP connection. It is possible to construct and preserve an OLAP connection using CMC (Central Management Console) or IDT (Information Design Tool). This OLAP connection may be used with Multi-provider, BI (Business Intelligence) server, InfoCube, and BEx queries. The connection will be formed in the query or cube base if the connection is specific to a GIVEN Cube, Query, or Multi-provider. Otherwise, a connection will be formed on the BI server that may be used to connect to any BEx query. The benefit of creating connections on the BI server is that only one OLAP connection is required.

To connect to a BI server via an OLAP connection, follow these steps:

• Log in to CMC with Administrator permissions and select the OLAP Connection option.
• Then CHOOSE the option to create a new connection.
• Fill in the BI server's information.
• To check connectivity, click the Connect button and provide the BI server's credentials.
• As we are connecting to the BI server, don't PICK any cubes or queries; instead, click cancel.
• Choose 'Predefined' under Authentication Type, keep the user name and PASSWORD, and then save.
• CMC has now successfully made an OLAP connection to the BI server.