From SAP BO 4.0(SAP Business Objects 4.0) onwards it is allowed to connect BEx query through BICS(Business Intelligence Consumer Services) connection which is also called OLAP connection. With the help of CMC(Central Management Console) or IDT(Information Design Tool), it is possible to create and save the OLAP connection. This OLAP connection can be CREATED for connection with the Multi-provider, BI(Business Intelligence) server, InfoCube, and BEx query. If the connection is specific for a particular Cube, Query, or Multi-provider then the connection will be created in query or cube BASE. Otherwise, the connection will be created on the BI server using which connection to any BEx query is possible. The advantage of Connection creation on the BI server is only a single OLAP connection is required for all BO reports.

Steps for creating OLAP connection to connect with BI server:

• Login to CMC with the right of Administrator authorization and go for the OLAP Connection option.
• Then select the option new connection.
• Enter the details of the BI server as given in the below screenshot.

• Click on Connect BUTTON for checking connectivity and give the CREDENTIAL of the BI server.
• Don’t go for a selection of any cube or query as we are making the connection to the BI server, click on cancel.
• Select ‘Predefined’ for AUTHENTICATION Type and maintain the user name and password, then click on save.

Now, OLAP Connection to the BI server has been successfully created using CMC.