Skip to Content

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

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Vagabond 007

    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.

     

     

     

    (1) 
    1. Kashif Khan 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

      (0) 

Leave a Reply