Now, it’s time to connect Web Intelligence (Webi) to SAP HANA and retrieve data from it. Webi is a reporting tool which is a part of SAP BusinessObjects BI Platform.\u00a0The data fetched from SAP HANA will be used for creating reports and conducting the analysis.<\/p>\n
Firstly, let’s learn the working of Webi with SAP HANA.<\/b><\/p>\nWeb Intelligence and SAP HANA<\/h3>\n
Webi i.e. Web Intelligence is an advanced reporting tool having capabilities for ad-hoc reporting, detailed reporting, using query panels, data visualization, creating\/modifying queries, etc. Webi access data from semantic layers from universes created using IDT tool.<\/p>\n
The semantic layer is created on top of a non-SAP data source. You can also create universes from UDT. With IDT, you can access multiple data sources, whereas, with UDT you can only access one data source at a time.<\/p>\n
Webi is a part of SAP BusinessObjects Platform client tools. It connects to the SAP HANA system using JDBC or ODBC connection<\/strong>.<\/p>\n In this section, we will learn to connect Web Intelligence (Webi) to SAP HANA in four different ways.<\/p>\n To begin with, let’s find out how to connect to SAP HANA from Web Intelligence via a Universe.<\/p>\n Step 1:<\/strong> Open Web Intelligence Rich Client.<\/strong> Click on the document icon<\/strong> to create a new document\/connection.<\/p>\n Step 2: Select a Data Source<\/strong><\/p>\n In the next dialog, select the\u00a0Universe<\/strong> as the data source. Click OK<\/strong>\u00a0to continue.<\/p>\n Step 3: Select a Universe<\/strong><\/p>\n Select your preferred universe from the list of available universes. Click on Select <\/strong>to continue.<\/p>\n Step 4: Query Panel<\/strong><\/p>\n The Query Panel<\/em> will open, having all the measures and dimensions.\u00a0You will have a list of objects of the selected universe in the Universe outline<\/strong> section given on the left.<\/p>\n You can select measures and dimensions for this panel and add it to the Result Objects<\/strong> section. Drag and drop the measures and dimensions in the Result Objects<\/strong> section.<\/p>\n Follow the steps to directly connect to SAP HANA from Web Intelligence Rich Client:<\/p>\n Step 1: Select a Data Source<\/strong><\/p>\n Open Web Intelligence rich client<\/strong>. Click on the document icon given on the topmost bar, to create a new document\/connection.<\/p>\n Select the SAP HANA<\/strong> as the data source. Click on OK<\/strong>.<\/p>\n Step 2:<\/strong>\u00a0Now, select the SAP HANA connection name from the list of connections. Click OK.<\/strong><\/p>\n Then inside that connection, select the folder containing the information views you require. All the objects within that folder will appear on the right window. Click OK<\/strong>.<\/p>\n You can cross-check<\/strong> in the\u00a0SAP HANA Information Modeler,\u00a0<\/strong>all the information views under the folder you selected in Webi are the same.<\/p>\n Step 3:<\/strong> In the Query Panel you will find the list of all the attributes (dimensions) and measures available in the selected view.<\/p>\n The list is available in the Universe Outline<\/strong> panel on the left in Query Panel<\/em>.<\/p>\n Follow the steps given in this section to make an SAP HANA Online connection.<\/p>\n Step 1: Select a Data Source<\/strong><\/p>\n Open Web Intelligence rich client<\/strong>. Click on the document icon given on the topmost bar, to create new document\/connection.<\/p>\n Select SAP HANA Online<\/strong> as the connection type. Click on OK.<\/strong><\/p>\n Step 2:<\/strong> Select the SAP HANA specific connection from the list of connections available. For instance, we select a folder DTF_HANA<\/em>. Click OK<\/strong>.<\/p>\n Step 3:<\/strong> Select the data folder from the list under the Folder<\/strong> section. Then select the view which you want to use for report creation from the left section. Click OK<\/strong>.<\/p>\n Step 4:<\/strong> The SAP HANA Online type connection does involve a Query Panel <\/em>and it directly opens the reporting interface.\u00a0<\/strong>On the reporting interface, you can instantly create reports using data from your SAP HANA data folders\/views.<\/p>\n The fourth type of connection is a Free-hand SQL connection where you get to write an SQL script to establish a relational connection to the data source.<\/p>\n Step 1: Select a Data Source<\/strong><\/p>\n Open Web Intelligence rich client<\/strong>. Click on the document icon given on the topmost bar, to create new document\/connection.<\/p>\n Select Free-hand SQL<\/strong> as the connection type.<\/p>\n Step 2:<\/strong>\u00a0Now, select the connection specific to HANA from the list of available connections. Click on OK<\/strong>.<\/p>\n Step 3:<\/strong>\u00a0Then, a\u00a0Query Script editor<\/em> will open where you can write your SQL script.\u00a0You can use the data tables and views from HANA in your SQL script.<\/p>\n A sample script is shown below:<\/p>\n Once you have established a connection to SAP HANA through one of the four ways we just learned, we are ready to create reports in Webi. The reports are created from the dataset we fetched from SAP HANA.<\/p>\n Step 1:<\/strong>\u00a0To create a report, select the measure and attribute fields from the list available of the contents of the information views.\u00a0You can find this list in the Universe Outline<\/strong> section of the Query Panel<\/strong>.<\/p>\n Drag the measures or attributes and drop them on the Result Objects section<\/strong> to finalize for the report.<\/p>\n Step 2:<\/strong> You can also access the Query Script<\/em> and make changes in it if you prefer.\u00a0The Query Script can be opened from a script icon present on the top bar of the Query Panel<\/em>.<\/p>\n A sample of query used in Query Script editor is given below:<\/p>\n Also, you can apply query filters on the selected data fields from the section Query Filters on Query Panel.<\/p>\n Step 3.<\/strong> Once you made all the selections, click on Refresh<\/strong> in the Data Preview<\/strong> section. You will get a preview of the data fields you selected in tabular form.<\/p>\n Step 4.<\/strong> Click on Run Query<\/strong> to execute the query.<\/p>\n The data will appear in reporting view in a tabular representation.<\/p>\n You can work on the report further using the tabs like Report Element<\/em> (to add visualizations), Format, Data Access, Analysis and Page Setup.<\/em><\/p>\n We hope you liked our tutorial of steps to connect SAP HANA to Web Intelligence.<\/p>\n If you have any queries or suggestions regarding this or any SAP HANA topic, do leave a comment in the comment section below. We will be glad to help.<\/p>\n","protected":false},"excerpt":{"rendered":" Now, it’s time to connect Web Intelligence (Webi) to SAP HANA and retrieve data from it. Webi is a reporting tool which is a part of SAP BusinessObjects BI Platform.\u00a0The data fetched from SAP...<\/p>\n","protected":false},"author":6,"featured_media":54081,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18002],"tags":[19496,19497],"class_list":["post-53986","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-hana","tag-connect-web-intelligence-to-sap-hana","tag-web-intelligence-and-sap-hana"],"yoast_head":"\nHow to Connect Web Intelligence to SAP HANA?<\/h3>\n
1. Universe Connection<\/h4>\n
2. SAP HANA Direct Connection<\/h4>\n
3. SAP HANA Online<\/h4>\n
4. Free-hand SQL Connection<\/h4>\n
SELECT\r\n\"DTFProject_Title\u201d,\r\nsum(\"Current_Phase\u201d) AS \"Current_Phase\u2122,\r\nsum(\"Schedule_Status\u201d) AS \"Schedule_Status\u201d,\r\nsum(\"Est_Capital\u201d) AS \"Capital\u201d,\r\nsum(\"Est_Expense\u201d) AS \u201cExpense\u201d,\r\nsum(\"Total_Cost\") AS \"Iotal_Coat\u201d<\/pre>\n
Developing Reports in Web Intelligence<\/h3>\n
SELECT\r\n\r\nTable_1.\"PRODUCT\",\r\nTable_1.\"NAME\",\r\nTable_1.\"CATEGORY\u201d,\r\nTable_1.\u201cUNITSSOLD\u201d, \r\nSUM(Table__1.\u201cGROSSAMOUNT\u201d)\r\n\r\nFROM\r\n\r\n\"_SYS_BIC\u201d.\"9QBEXSQL\/ZAV_SALES_USING_AT_001\" Table_1\r\nGROUP BY\r\n\r\nTable_1.\"PRODUCT\",\r\nTable_1.\"NAME\",\r\nTable_1.\"CATEGORY\u201d,\r\nTable_1.\u201cUNITSSOLD\u201d,<\/pre>\n
Summary<\/h3>\n