
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
Reporting in SAP HANA
Introduction to SAP HANA Reporting
SAP HANA is an efficient in-memory database technology which provides its users with platforms to model and design data as per their business requirements.
As an extension to the data extraction and modeling capabilities, SAP HANA reporting tools serve as an essential platform to present the information in proper ways.
The reports created by the reporting tools using processed data from SAP HANA are used by business analysts, business managers, sales managers, and senior managers.
The report enables the people in authority to draw meaningful insights and identify market trends to make strategies and bolster their business in the present as well as for the future.
SAP HANA enables different kinds of reporting tools such as SAP Lumira, Design Studio, Analysis Office, Crystal Reports, Dashboards, Explorer, Web intelligence and even third-party apps like MS Excel. Users can use both historical as well as real-time data to create reports.
Connecting to the Reporting Sources
SAP HANA users or the users at the reporting end of the setup can establish a connection to the other end in two ways:
- First is the direct way where reporting tools can connect directly to the SAP HANA database. This direct connection is an OLAP type connection. The tools which connect directly to the SAP HANA system are Design Studio, SAP Lumira, Business Explorer, Analysis of MS Office, Crystal Reports, etc.
- The second way is an indirect way of connection. It is a relational connection that establishes by creating a universe using the Information Design Tool (IDT). The tools using this method of connection to connect to the SAP HANA database are Web intelligence tools, SAP Dashboards, Crystal reports for the enterprise.
Layers in Reporting Framework
The reporting framework is easy to understand when we divide it into three primary layers;
- Interaction languages
- Connecting drivers
- Reporting tools
At the base of these three layers is the core SAP HANA system database. From there, users can fetch data to use it in the reporting tools. Let us learn about reporting architecture by understanding each layer in detail.
-
-
Interaction Languages
This layer consists of all the query languages which are used in querying database tables and objects from the reporting tools during report execution. The languages used for this purpose in SAP HANA reporting are MDX, SQL, and SQL ODBC.
-
MDX:
MDX language is used to access multi-dimensional data objects instead of relational objects from the SAP HANA database. MDX stands for MultiDimensional Expressions. This language is used to query data from MS Excel in SAP HANA reporting. It is the only language that enables hierarchy accessing from SAP HANA system.
-
SQL:
SQL is a standard database language for accessing data from all kinds of platforms. In SAP HANA reporting, all the reporting tools, which connect data through ODBC and JDBC connections use SQL as the query language.
-
SQL ODBC:
The SQL ODBC connection accesses data from the reporting tools that connect to the SAP HANA system using a BICS connection. BICS stands for Business Intelligence Consumer Services.
-
-
Connecting Drivers
The connecting drivers act as a mediator between the SAP HANA database layer and the reporting tools. The drivers transport the language queries from the reporting tool to the database and take back the data.
-
Every reporting tool connects to the database through a specific connecting driver. SAP HANA uses four main types of drivers as discussed below:
-
-
-
ODBO (OLE DB for OLAP):
The ODBO driver is a driver by Microsoft for connecting MS Excel to the SAP HANA database. This driver is specifically for multi-dimensional reporting (multi-dimensional data stores), and it communicates through MDX language.
-
ODBC:
The ODBC driver establishes relational database connections between reporting tools and SAP HANA database. Reporting tools like CR Report and Universe layer (IDE) use ODBC driver that communicates via SQL. ODBC stands for Open DataBase Connectivity.
-
JDBC:
JDBC stands for Java DataBase Connectivity. JDBC driver is a Java-based connection service. We also use it for relational reporting by tools like Explorer, UNIX using IDT, CR Report. JDBC drivers communicate with the database through SQL queries.
-
BICS:
The BICS driver is SAP propriety connecting driver, which is used by those reporting tools that use SQLDB language as the interaction language with SAP database.
-
-
Reporting Tools
The topmost layer is the layer of reporting tools. It is the SAP Business Objects BI (4.0/4.2/4.3) reporting platform which serves several reporting applications. The business users analyze data and create reports to generate meaningful insights using these applications.
-
The SAP BO platform consists of reporting applications such as SAP Lumira, Web Intelligence, SAP BO Explorer, SAP BO Dashboards, Crystal Reports, and SAP BO Universe.