Monday, December 5, 2011

Life is easier in SAP BO 4.0 for Bex Queries Integration


I got chance to look at SAP Business Objects BI 4.0. The look and feel is great.

Now I am going to discuss about How to create reports on top of SAP BEX Queries in BO 4.0.

Before we go ahead, Let's talk about how the reports can be created on top of BEX Queries in BO XI 3.1

In BO XI 3.1, here are the steps we follow:
  1. Identify the BEX Query
  2. Create a Universe
  3. Create a Universe Connection using SAP Client middleware and connect to it
  4. Universe imports the BEX Query objects such as Characteristics, Key figures and so on.
  5. If you observe there would be two dimension objects for each characteristic. They start with L00 and L01.
  6. L00 - is for aggregate level data   & L01 - is for detailed data
  7. Create WebI report on Top of Universe.
We cannot create Reports using WebI RICH Client on top of BEX Queries in BO XI 3.1

In SAP BO BI 4.0 - You can directly create WebI report on top of BEX Queries using WBEI Rich Client.
  1.  Identify the BEX Query
  2. Create a Universe Connection using SAP Client middleware and connect to it
  3. Open WEBI Rich Client
  4. Select the data source as connection which you created in Step2.
  5. The interface opens with list of all Characteristics, Key figures and so on
  6. The objects shows up in better way than BO XI 3.1. 
  7. Only one dimension object is shown for each characteristic. Hierarchies are displayed as a detail object. 
  8. When you select the detail object with a icon as hierarchies, the report takes care of alignment and formatting of Hierarchy.This is a great feature in SAP BO BI 4.0.
 Please post your comments if you like this post.

 Would you like to discuss more ? Please post your questions in our forum

Looking for online trainings? Contact

Looking for Jobs. Visit


  1. Point 2: Is it only possible to create a OLAP connection in the BO CMC? Are there any other ways to create this connection?

    1. You can create it via IDT too

  2. Yes. This is the only way. You could also check by directly using BEX Query from WebI Rich client.

    I believe in both the cases, you must create a connection in Information Design Tool.

  3. Thank you very much!
    What I would like to know is:
    1. can I use a BEx query in WEbi directly? Without a connection
    2. If not, is the CMC the only place where I can create the olap connection
    3. You mentioned the Information Design Tool. Can I create this connection also there

    Again thank you very much for taking time to answer my questions

  4. ok I think I got it. I need this connection. And I can create a olap connection in the information design too (better) or in the CMC.

    I hope I am right

  5. Probably check following options:

    1. I believe you should create a BEX connection first using IDT.
    2. Then you can create reports in WebI using IDT connection.

  6. SAP BO Online Training Video Classes @ 15000/- Only and 3 Months Server Access
    Excellent videos good explanation One time pay and Life time use.

  7. best institutes for sap training in bangalore, that offer you sap hana training, sap fico training, sap abap training, sab basis training
    sap training institutes in bangalore and sap HANA training in Bangalore
    sap ABAP training in Bangalore

  8. we offer sap training in bangalore for all courses related to sap just click here to get the detail
    sap training in bangalore