SAP BusinessObjects - Web Intelligence (WebI), SAP HANA

4 Ways to connect Webi on top of HANA Views

From SAP BO 4.2 onwards we have option to connect webi with HANA view in 4 ways efficiently. I am writing up them below with high level steps of navigation to achieve them.

Option 1: Using Universe on top of HANA view and build webi with that universe

This method is available from older version. I should say this was the only option that was available in earlier version of SAP Business Objects to connect to SAP HANA views. To achieve this a universe need to be created on SAP HANA view. Go to IDT and create universe and then build a webi report on this universe.

Option 2: Webi connecting with HANA view directly

This was the most expected release in new version. Here from webi development environment we are getting option to connect to the HANA views.

Below are the steps those need to be performed.

Step 1: Open webi rich client and connect with the Business Objects server to get the list of HANA connections from managed list of connections from Business Objects server.

SAP BusinessObjects - Web Intelligence (WebI), SAP HANA

Step 2: Above step will list down all the views based on the packages they are assigned in the HANA system. Select the package from where you have your view.

SAP BusinessObjects - Web Intelligence (WebI), SAP HANA

Step 3: Once it is done it will populate the webi query panel

SAP BusinessObjects - Web Intelligence (WebI), SAP HANA

Option 3: Using SAP HANA Online connectivity

This option is also introduced in SAP BO 4.2 version. In this option when we will be going to connect to the HANA view from Webi there is no Webi query layer to build webi query.

Step 1: Select the HANA Online connection after connecting your webi client to SAP Business Objects server. When webi rich client goes with the HANA online connectivity it will list relational connects only. Once we will select that connection it will list down all the packages and holding views.

SAP BusinessObjects - Web Intelligence (WebI), SAP HANA

Step 2: After selecting one of the view it will take us to the reporting layer directly without allowing us to build webi query. There is no concept of webi query in this scenario

SAP BusinessObjects - Web Intelligence (WebI), SAP HANA

Option 4: Connecting HANA views using Free-hand SQL

Free-hand SQL is another option that got introduced in SAP BO 4.2 When Webi connects using Free hand SQL option it will list down all the HANA relational connection list from the Business Objects server. Once this connection is selected it will give a query script editor to write the query

Step 1: Selecting Free-hand SQL option

SAP BusinessObjects - Web Intelligence (WebI), SAP HANA

Step 2: Selecting relational HANA connection from available list of connection from SAP BO server

SAP BusinessObjects - Web Intelligence (WebI), SAP HANA

Step 3: Writing select query to form Webi Query

SAP BusinessObjects - Web Intelligence (WebI), SAP HANA

Step 4: Running Webi Query

SAP BusinessObjects - Web Intelligence (WebI), SAP HANA

Leave a Reply

Your email address will not be published. Required fields are marked *