How to create connections in SAP BI 4.0

You may also like...

41 Responses

  1. Great blog Pieter! Very usefull information. I know the blog is referring to connecting BI4 Tools to BW. Perhaps it would be nice to extend the diagram to show the alternatives to get BW data into SAP BO Explorer.

    • Hi Martijn,

      Thanks for the comment! I’ll extend the diagram as soon as possible with SAP BO Explorer.
      Hope you will visit this site regularly, my plan is to post more “how to…” documents on my blog.


    • venkat says:

      Hi Pieter,
      Your blog is so nice,
      i have a small doubt in sap-dash boards
      i have to create multiple parameters in dashboards
      is it possible did u refer me how to do this work

  2. Santosh says:

    Very useful Pieter, thanks for sharing..

  3. He Pieter,

    Thanks for sharing. I’ll drop by at a sprint demo after my holidays to see how much you guys are progressing in the BI4 project. Sounds promising :)

    Pieter Hendrikx

    • SivaPrasad says:

      Hi.Pieter i am working as a sap bo consultant right now we are using the version SAP BI 4.0 SP6..we are generating mobile dashboards.for that w are using liveoffice to get the data from web-i. For desktop version liveoffice working if at all any changes happen in database with out refresh it showing updated records in Dashboard.but in mobile version its not updating records.

      So could you please tell me for mobile dashboards live office will work..?or i need to use another connections to get the live data in ipad.Please help me your answer is very help full to me.

  4. Mohanraj says:

    Hi Pieter,

    This is well written. Thanks for sharing it.

    Is it possible to create multiple connections to different BW cubes from IDT or a mix of SAP BW and a relational database?


    • Hi Mahanraj,

      Thanks for your comment. It is certainly possible to create multiple connections on different BW cubes. With the relational multi source connection you can combine SAP and non-SAP sources. With the relational single source connection it is not possible to connect to SAP BW. Hope this information will help you.


  5. Mamatha says:

    Hi Pieter,
    Thanks for publishing the useful information. Can we connect to SAP ECC/ERP through Information Design Tool? Could you provide me the steps if possible. I appreciate your help.


  6. Falk says:

    Hi Pieter,

    read your nice paper “How to create connections with SAP BO BI 4.0”. On page 8 you use a SAP Netweaver BW connector. In our BO 4.0 latest Patch it is not available. BW is still on 7.0 without EHP.
    Is our BW the problem or where do we get the JCO connector driver from?
    Thanks for you help.

    • Hi Falk,

      Thanks for writing a message on my blog. What is the latest patch you installed on your SAP BI4 environment? The JCO connector can be used only with relational connections. So this option is only available when you choose “Insert Relational Connection”. The JCO connector will be automatically installed when you install SAP BI4. I can remember this is an option in the install menu. Please contact your system-administrator if the drivers are installed.


  7. Falk says:

    Hi Pieter,
    thanks for your fast answer. We have installed BI 4.0 with Patch 12. I tried to create a relational connection. Standard BICS connections are fine.
    Kind regards

    • Hi Falk,

      When you’re using BW as source system, SAP recommend to use the BICS connection. If you plan to use the BW source in combination with an other source system, you need to use the JCO connector. With this connection it’s possible to combine source systems.

      Success with your development!


  8. Priyanka says:

    Hi Pieter,

    The description was very helpful.

    I am working on BO Feature Pack 3 and trying to connect to a BEx Query using Infirmation Design Tool. See my steps below:

    1. Created an OLAP connection to a BEx query in Local Projects and published it to the repository.
    2. Data Foundation not required in case of OLAP, so moving to the creation of Business Layer
    2. Now, when I try to create a Business Layer on top of this, i get an error saying this is not possible which I am also aware of (some strategic decision from SAP, I believe)

    My question is, why does the training manual show that this is possible:


    • Hi Priyanka,

      In the training manual on SDN the OLAP connection was created on a 3rd party cube. When you create an OLAP connection on a SAP cube or query, business layers cannot be created.


  9. Excelent article!!! Helped me a lot!
    Marco Modesto

  10. Karen says:

    Hi Pieter,

    I have just come across your blogs and have found them very interesting. I am struggling at the moment with Dashboards and the two different types of BICS connector that can be used to access BEx Queries. I have got the netweaver based BICS connector working fine but I cannot get the BOBJ BICS connector working – the button to select a Bex Query when using the Query Browser – Add Query option in Dashboards is missing and only gives the option to create a query based on a Universe. Have you seen this option working and do you know if it is dependent upon some setup or config or path level or indeed anything??.



  11. sri says:

    Hi Pieter.

    Thank you very much for the article
    I am getting error business objects validity(SQL/MDX) error upon intergretiy check on Buniess Layer of the Relation badabase connection. I am using Bex Query


  12. Hi,
    Is it possible to create universe based in personal files such as excel file or csv?


    • Hi,

      Yes, this is possible. First you need to create an ODBC-connection to the Excel file. The second step is to create the universe on top of the ODBC connection.
      With these steps it’s possible to query on your Excel or CSV file.


  13. Nitin says:

    HI Peter,

    We are planning to use multisource capability with SAP BW and non SAP. I know we need to create JCO connection. When we create JCO connection, does it support infoset( basically 2 infoobject combined to form an infoset) type ?


  14. Moises says:

    Hi Pieter,

    Thanks for very usefull information.

    I am working on SAP BW/BO 4.0 integration project and there are some security issues we need to define, for example, end-users will use Web Intelligence to create reports based on Universe as data source so the ‘user name’ filled in the connection properties should be the same for all the connections to different infoCubes in SAP BW??

    Second, If we want to apply data restriction at report level, I mean vendors of north group should view only the ‘north sales’ in sales territory report. The same case for vendors of south group, they should view only south sales for the same report.
    How can we get it?

    Lastly, using only BO universes connected to BW Infocubes, what is the best approach to apply security (SAP BW side or BO side)? I mean for reporting analysis, no administrative tasks.

    I will really appreciate your comments.


    • Hi Moises,

      Authorization is not a simple topic ;-). You need to distinguish two essential things about SAP BW/BO authorization, in SAP BO you’ll authorize on reports (in a business logical structure), in SAP BW you’ll authorize on data.
      About your first question, a best practice is to set the authentication mode on “Single Sign On”. Via this way users that logon (via SAP authentication mode) to he SAP BOE platform, will use their SAP authorization (data level). You can create one connection to your SAP BW environment.

      Hope these answers will help you, good luck!


  15. Saul says:

    Hi Pieter,

    Thanks for the article. I´m specially interested in know how to create connections to multidimensional databases and how it works. I was told that connect Cognos to BO 4.0 would not be possible. Could you confirm what you said in the sentence ‘The dimensional semantic layer can be used to access multidimensional databases, such as Microsoft Analysis Services, Hyperion or Cognos.‘?

    Thanks in advance.

    • Hi Saul,

      My apologies for the delayed reply, I was on holiday :-) Unfortunately I must say that I wrote about Cognos is incorrect. You are not able to connect to Cognos Cubes. I’ll adjust this immediately ;-)


  16. friedrich Hervé Lien says:

    Hi Pieter,

    thanks for sharing your knowledge here.
    I used your post “How to create connections with SAP BusinessObjects BI 4.0” and everything was fine.
    The issue I have now is that the user I created in SAP BW can see all the applications assigned to them. But once clicking on these applications, they cannot open them.
    Can you please help me by telling me what I should do next?

    Kind regards from Germany


  17. Friedrich Hervé Lien says:

    Hi Pieter,

    thanks. I have already read the article you sent me. The problem was on the Access Levels in SAP BO.

    The Edit Objects functionality was not active.

    Thanks and Kind regards


  1. August 2, 2011

    RT @pverstraeten: New blog post: How to create connections in #SAP #BOBJ #BI4

  2. August 2, 2011

    New blog post: How to create connections in #SAP #BOBJ #BI4

  3. August 3, 2011

    New blog post: How to create connections in #SAP #BOBJ #BI4

  4. August 3, 2011

    RT @pverstraeten: New blog post: How to create connections in #SAP #BOBJ #BI4 – Very usefull PDF Pieter!

  5. August 6, 2011

    New blog post: How to create connections in #SAP #BOBJ #BI4

  6. August 8, 2011

    Great blog post by @pverstraeten including "how to" PDF to create connections between SAP# BW# and BOBJ# BI4#

  7. August 8, 2011

    Great blog post by @pverstraeten including "how to" PDF to create connections between SAP# BW# and BOBJ# BI4#

  8. August 9, 2011


  9. August 9, 2011


  10. August 9, 2011

    RT @roz_heathcote -> very nice visual of how things connect in BI 4.0 … alles klar!

  11. June 29, 2012 » How to create connections in SAP BI 4.0:

  12. June 29, 2012 » How to create connections in SAP BI 4.0:

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.