Skip to Content
Author's profile photo Kodanda Pani KV

How to create a BICS connection

How to create a BICS connection to a SAP BEx query.


What is BICS?

Business Intelligence Consumer Services

BICS is the BW data access layer for BEx tools

                In the information design tool, you can create an OLAP connection to connect to SAP NetWeaver Business Warehouse (BW) using Business Intelligence Consumer Services (BICS) connectivity. BICS connectivity is the recommended way for BI tools to connect to Business Explorer (BEx) queries on the SAP NetWeaver BW server.
In this tutorial, you will create OLAP connections to connect to an SAP NetWeaver BW data source based on a BW server, a cube, and a BEx query.

Advantages

  1. 1. OLAP “look and feel Can interact with data in BW as well as non BW sources No longer need to manually create / maintain universes (for example, if the underlying  BEx Query changes)
  1. 2. Improved reporting performance

When SAP BW 7.3 is your source, BICS connections are recommended by SAP. You can connect directly to a SAP BEx query or a SAP BW Info Provider. In the next steps you can see how to create a BICS connection to a SAP BEx query.


Steps:-


Log in to Information Design Tool


   

Select create new

Observe the all connection

Now I am discussing how to create the OLAP connections


 

Select the project and give the project name, location.


 

Now project is created

Select the project (TEST1)

Create new – select the OLAP connection

 

Select the BICS connections


 

Give the system credentials.


 

Select the specify a cube in the connections.

Select folders (info areas and favorites)


 

Select the next

Click on the test connections

Test successful


 

How to publish the connection to repository

Select the OLAP test connection -> Right click -> publish connection to repository


 

Choose repository file


 

Give the system credentials


 

Please observe the system credentials.

Click ton test connection


 

Now connection was published.

Hopes it is helps..

Assigned Tags

      17 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Pani,

      Very useful document. Thanks for sharing.

      I have one question " What is the difference in creating BICS connection in Local Projects and Repository Reports?"

      BR
      Aakash G

      Author's profile photo Phani KV
      Phani KV
      Blog Post Author

      Thanks Aakahs your comment.

      Author's profile photo Phani KV
      Phani KV
      Blog Post Author

      Hi akash,

      we can,t access data through Data Manger connections in local projects.

      Regrads,

      Phani.

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Nicely presented...informative.  🙂

      Regards,

      Krishna Chaitanya.

      Author's profile photo Former Member
      Former Member

      thanks pani, it is very useful

      Author's profile photo Ganesh Bothe
      Ganesh Bothe

      Hi Pani,

      Useful information...thanks for sharing 🙂 .

      Author's profile photo Former Member
      Former Member

      Hi,

      Useful info.

      Thanks

      Author's profile photo Phani KV
      Phani KV
      Blog Post Author

      Thanks Ganesh & Hari.

      Author's profile photo Former Member
      Former Member

      Nice post!. Thanks for sharing...

      Venkat...

      Author's profile photo Former Member
      Former Member

      Hi,

      It is good and usefull also...

      Please share me about DSL and APS..

      What is DSL and APS?what is use in BICS?

      Author's profile photo Phani KV
      Phani KV
      Blog Post Author
      Author's profile photo Former Member
      Former Member

      Good info. 🙂

      Author's profile photo Harshil Joshi
      Harshil Joshi
      Author's profile photo A Ganesh
      A Ganesh

      Gud.

      Author's profile photo Former Member
      Former Member

      Thanks, Nicely explained

      Author's profile photo Bala Subramanian
      Bala Subramanian

      Neat and clear, thanks.

      Author's profile photo Vivek Chaudhary
      Vivek Chaudhary

      nice