Skip to Content
Author's profile photo Kashif Khan

Create OLAP Connection (BICs) to SAP BI server to access Bex Query Data:

Hello Everyone,

Objective: Create dashboard and webi reports on BEx query directly, for this we need to create OLAP Connection(BICs)to SAP BI server.



Introduction: SAP BO 4.0 onwards allows us to connect BEx query via Business Intelligence Consumer Services (BICS) connection which also known as OLAP connection. We can create and save OLAP connection through CMC (Central Management Console) or IDT (Information Design Tool). OLAP connection can be created to connect BI server, Multiprovider, InfoCube and Bex query. If connection is specific for particular Query, Cube or Multiprovider then goes for create it in query or cube base Otherwise create connection on BI server through which we can connect to any BEx query. The benefit of creating Connection on BI server is single OLAP connection for all BO reports.


Create OLAP connection to connect BI server:


1) Login to CMC with Administrator authorization right and goes to OLAP Connection

         


2) Then select new connection

         

  3) Put the BI server details as per below given screen shot.         

4) Click on Connect button to check connectivity give BI server credential.

        

5) Don’t select any cube or query as we are making connection to BI server, click on cancel.

            

6) Select Authentication Type as ‘Predefined’ and maintain user name and password and save.

Now we have created OLAP Connection to BI server successfully using CMC. Hope this Document will be helpful.

Thanks,

Kashif Ali Khan

Assigned tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo VIVEK SELVARAJ
      VIVEK SELVARAJ

      Good one.

      Author's profile photo Former Member
      Former Member

      Hi Kashif, this is perfect. Thanks. Also how do you specify port number for a server in OLAP Connection ? we have only specific ports allowed and we have to force our connection to talk to server on these ports.

       

       

       

      Author's profile photo Kashif Khan
      Kashif Khan
      Blog Post Author

       

      Hi Vagabond,

      You will need to configure request ports for all the BO servers as per the table mentioned in BI 4.0 SP06 admin guide page number 161. Following are the steps to configure request ports.

      1. Login to CMC and click on servers
      2. Open server list and right click on CMS->Properties
      3. Uncheck the auto assign option for request port and add request port manually as per admin guide
      4. Repeat the same steps for all the servers and restart SIA
      5. Open these ports bi-directionally on the firewall and try login to client tools.

      Request port is actually a response port in BO the servers will respond back on these request ports. It would select any random port to respond back if request port is auto assign which may be blocked on the firewall. You can find BI 4.0 SP06 admin guide at

      http://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp6_bip_admin_en.pdf

       

      Thanks,

      Kashif Ali Khan

      Author's profile photo Siddhesh Satardekar
      Siddhesh Satardekar

      Hi Kashif,

       

      Can you let me know steps to configure with message server