
Quick Contact
SAP Tutorial
- SAP HANA
- Features of SAP HANA
- Advantages and Disadvantages of SAP HANA
- SAP HANA Architecture
- SAP HANA Use Cases
- SAP Hana Installation
- SAP Hana Studio
- SAP HANA Studio Administration Console
- How to Use SAP HANA System Monitor
- How to Use SAP HANA on Azure
- SAP HANA Modeling – Attributes, Measures, Privileges, Modeling Objects
- Data Warehousing in SAP HANA – Components, Methods, Working & Benefits
- SAP HANA Attribute View – Create Attribute View in 9 Easy Steps
- SAP HANA Analytic View
- SAP HANA Calculation View
- Tables in SAP HANA
- SAP HANA Packages
- Schema in SAP HANA
- How to Create Analytic Privileges in SAP HANA
- SAP HANA Information Composer
- Import and Export in SAP HANA
- Major Components of SAP HANA
- Reporting in SAP HANA
- SAP Bussiness Objects Reporting Tool
- create relational connection in sap hana in 8 steps/
- steps to create olap connection in sap hana/
- How to Connect SAP Lumira with SAP HANA
- Connect Dashboard Designer to SAP HANA & Create Stunning Dashboards
- How to Connect Web Intelligence to SAP HANA in 4 Ways – Seamless Process
- Replication Modes and Types in SAP HANA
- SAP HANA Sidecar Scenario
- SAP HANA Security Guide
- SAP HANA License Management
- Difference between SAP HANA vs SAP S/4 HANA
- What is SAP S/4 HANA?
- S/4HANA Editions
- SAP S/4HANA Lines of Business
- >SAP S/4HANA Deployment Options
- >SAP S/4HANA Overview
- >Introduction of SAP ABAP
- >Overview of SAP ABAP
- >SAP R3 ARCHITECTURE
- >SAP Data Dictionary
- >SAP ABAB Views
- >SAP ABAB database Tables
- >ABAP Constants & Literals
- >ABAP Constants & Literals
- >Types of Tables in SAP
- >Sap Data Object
- >Internal Tables and Work areas
- >Internal Table Operations in SAP ABAP
- >ABAP Report uses Internal tables and Work Areas
- >Select single and Select up to 1 rows
- >Modularization Techniques
- >Techniques of debugging
- >Types Subroutines
- >Reports of Sap Abap
- >Using At Selection Screen Output
- >Select Statements
- >Function Modules
- >Modularization Techniques 2/
- >Subroutines In Sap Abap/
- >Report Of Sap Abap 2
- >Using At Selection Screen Output 2
- >Interactive Reports
- >Interactive Reports Development
- >Interactive Report Using Hide Technique
- >Interactive Report Using Get Cursor Technique
- >Tree List Report
- >Abap Alv Reports/
- >Sap scripts/
- >Purchase Order SAP Script/
- >SAP Smartforms/
- >What is BDC in SAP ? Types of BDC ?/
- >BDC Call transaction for Material Master MM01/
- >SD flow with T-Codes and tables/
- >Introduction to module pool programming in SAP/
- >Functional Specification/
- >ASAP methodology SAP
- >ABAP Development end to end process in Companies
- >SAP SD Sales and Distribution
Sap Abab
Sap FI
- Accounting Entries in SAP FICO
- Define Company in SAP
- Creating new companies
- Assign Company Code
- Business Area
- Functional Area
- Credit Control Area in SAP
- Financial Management in SAP
- Segments in SAP
- SAP Enterprise Structure
- General Ledger Accounting
- Fiscal Year Variant in sap
- Posting Period Variants in SAP
- Posting Period Variant to Company Code
- How to Assign company code to field status variants in SAP
- Posting Keys in SAP
- Tolerance Group for Employees in SAP
- Tolerance Groups For G/L Accounts
- Assign Users to Tolerance Groups in SAP
- Enter Global Parameters for Company Code OBY6
- Define Additional Local Currencies for Company code in SAP System
- Chart of Accounts in FICO
- Assign Company Code to Chart of Accounts in SAP
- How to Create G/L Account Group in SAP
- Define Sample Account Rule Types in SAP
- Data Transfer Rules
- Convolutional and recurrent neural network
- Assign company code to rule type in sap
- Create sample account in sap
- Accounting entries in sap fico sap accounting postings
- Financial statement versions in sap
- TAX Check Calculation Procedure in SAP
- Define New Condition types for Taxes
- How to Assign Country to Calculation Procedure
- Specify Structure for Tax jurisdiction code
- How to Create tax codes in SAP – FTXP "FI"
- Assign Tax Codes for Non-Taxable Transactions in SAP FI
- Define Tax Calculation Procedure for GST in SAP"FI"
- Assign Tax Calculation Procedure to Country in SAP for GST"FI"
- Define Access Sequence in SAP for GST"FI"
- Define Condition Types in SAP for GST"FI"
- How to create customer account groups in sap
- How to create number ranges for customer accounts
- Assign number ranges to customer account groups
- How to Assign Number Ranges to Vendor Account Groups in SAP F1
- How to Create Sundry Creditors GL Account in SAP FI
- How to Define Tolerance group for vendors /Customers
- How to Create Vendor Master Data
- Automatic Payment Program Configuration Steps SAP FI
- Create Vendor Account Groups in SAP
- How to Create Number Ranges for Vendor Accounts in SAP
- Maintain terms of payment SAP
- How to Create Customer master data by XD01
- How to Define Dunning Procedures in SAP
- Copy Reference Chart of Depreciation in SAP
- Assign Chart of Depreciation to Company code in SAP
- Specify account determination asset accountng
- How to create screen layout rules asset accounting
- SAP FI: Create Screen Layout Rules
- SAP FI: Maintain Asset Number Ranges – AS08
- Create Investment Program Types in SAP
- Investment profiles
- How to Investment Program Types to Operative objects in SAP
How to Connect Web Intelligence to SAP HANA in 4 Ways – Seamless Process
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. The data fetched from SAP HANA will be used for creating reports and conducting the analysis.
Firstly, let’s learn the working of Webi with SAP HANA.
Web Intelligence and SAP HANA
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.
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.
Webi is a part of SAP BusinessObjects Platform client tools. It connects to the SAP HANA system using JDBC or ODBC connection.
How to Connect Web Intelligence to SAP HANA
In this section, we will learn to connect Web Intelligence (Webi) to SAP HANA in four different ways.
-
Universe Connection
To begin with, let’s find out how to connect to SAP HANA from Web Intelligence via a Universe.
Step 1:
Open Web Intelligence Rich Client. Click on the document icon to create a new document/connection
Step 2: Select a Data Source
In the next dialog, select the Universe as the data source. Click OK to continue.
Step 3: Select a Universe
Select your preferred universe from the list of available universes. Click on Select to continue.
Step 4: Query Panel
The Query Panel will open, having all the measures and dimensions. You will have a list of objects of the selected universe in the Universe outline section given on the left.
You can select measures and dimensions for this panel and add it to the Result Objects section. Drag and drop the measures and dimensions in the Result Objects section.
-
SAP HANA Direct Connection
Follow the steps to directly connect to SAP HANA from Web Intelligence Rich Client:
Step 1:Select a Data Source
Open Web Intelligence rich client. Click on the document icon given on the topmost bar, to create a new document/connection.
Select the SAP HANA as the data source. Click on OK.
Step 2:
Now, select the SAP HANA connection name from the list of connections. Click OK.
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.
You can cross-check in the SAP HANA Information Modeler, all the information views under the folder you selected in Webi are the same.
Step 3:
In the Query Panel you will find the list of all the attributes (dimensions) and measures available in the selected view.
The list is available in the Universe Outline panel on the left in Query Panel.
-
SAP HANA Online
Follow the steps given in this section to make an SAP HANA Online connection.
Step 1:
Select a Data Source
Open Web Intelligence rich client. Click on the document icon given on the topmost bar, to create new document/connection.
Select SAP HANA Online as the connection type. Click on OK.
Step 2:
Select the SAP HANA specific connection from the list of connections available. For instance, we select a folder DTF_HANA. Click OK.
Step 3:
Select the data folder from the list under the Folder section. Then select the view which you want to use for report creation from the left section. Click OK.
Step 4:
The SAP HANA Online type connection does involve a Query Panel and it directly opens the reporting interface. On the reporting interface, you can instantly create reports using data from your SAP HANA data folders/views.
-
Free-hand SQL Connection
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.
Step 1: Select a Data Source
Open Web Intelligence rich client. Click on the document icon given on the topmost bar, to create new document/connection.
Select Free-hand SQL as the connection type.
Step 2:
Now, select the connection specific to HANA from the list of available connections. Click on OK.
Step 3:
Then, a Query Script editor will open where you can write your SQL script. You can use the data tables and views from HANA in your SQL script.
A sample script is shown below:
SELECT
"DUCATProject_Title”, sum("Current_Class”) AS "Current_Class, sum("Schedule_Status”) AS "Schedule_Status”, sum("Est_Capital”) AS "Capital”, sum("Est_Expense”) AS “Expense”, sum("Total_Cost") AS "Iotal_Coat”
Developing Reports in Web Intelligence
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.
Step 1:
To create a report, select the measure and attribute fields from the list available of the contents of the information views. You can find this list in the Universe Outline section of the Query Panel.
Drag the measures or attributes and drop them on the Result Objects section to finalize for the report.
Step 2:
You can also access the Query Script and make changes in it if you prefer. The Query Script can be opened from a script icon present on the top bar of the Query Panel.
A sample of query used in Query Script editor is given below:
SELECT
Table_1."PRODUCT", Table_1."NAME", Table_1."CATEGORY”, Table_1.“UNITSSOLD”, SUM(Table__1.“GROSSAMOUNT”) FROM "_SYS_BIC”."9QBEXSQL/ZAV_SALES_USING_AT_001" Table_1 GROUP BY Table_1."PRODUCT", Table_1."NAME", Table_1."CATEGORY”, Table_1.“UNITSSOLD”,
Also, you can apply query filters on the selected data fields from the section Query Filters on Query Panel.
Step 3.
Once you made all the selections, click on Refresh in the Data Preview section. You will get a preview of the data fields you selected in tabular form.
Step 4.
Click on Run Query to execute the query.
The data will appear in reporting view in a tabular representation.
You can work on the report further using the tabs like Report Element (to add visualizations), Format, Data Access, Analysis and Page Setup.
Apply now for Advanced SAP Course