Life is easier in SAP BO 4.0 for Bex Queries Integration

Folks,

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 www.xpert4ms.com

Looking for online trainings? Contact Projectsupport@xpert4ms.com

Looking for Jobs. Visit www.fuzure.com