- 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
- 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
SAP BusinessObjects Reporting Tools
What are SAP BusinessObjects Reporting Tools?
SAP BusinessObjects BI 4 is an SAP product that offers reporting applications and tools that use data from SAP BW and SAP HANA for reporting and analysis. The business objects reporting tool kit includes tools for reporting and dashboarding.
Business users can create reports and dashboards using these reporting interfaces by utilizing the data from SAP HANA in the form of tables or information views. The list of reporting tools available under SAP BusinessObjects BI 4 package is given below:
- SAP Lumira
- Web Intelligence
- SAP Crystal Reports
- Design Studio
- Dashboard designer
- Universe Designer (IDT/UDT)
- BusinessObjects Explorer
- Analysis Office
- MS Excel
All of these reporting tools connect to the SAP HANA database using individual connection drivers and database languages. Also, they provide the user with data modeling, ETL and reporting features.
The reporting tools connect with SAP HANA in two ways; either by a direct OLAP connection or through an indirect semantic layer (universe creation) which is a relational connection. All the tools use OLAP connection method except for Web Intelligence, Dashboard designer and Crystal Report Enterprise.
Presently, SAP HANA uses support package 7 of SAP BusinessObjects BI 4.2 (SP7). SAP BusinessObjects BI 4.3 is expected to release in mid-2019.
Reporting Tools in SAP BusinessObjects BI Platform
In this section, we will learn in detail about the reporting tools or applications that are a part of the SAP BusinessObjects BI Platform (client tools package):
SAP Lumira is a self-service data visualization tool which enables business users to connect directly to the SAP HANA database, create visualizations, stories, reports, transform data and do ad-hoc dashboarding.
It uses the BICS connection driver and SQLDBC as the language to connect to the SAP HANA database.
SAP Crystal Reports
SAP Crystal Reports is a Windows-based tool for creating reports for printouts and publishing such as sales invoices, sales orders report, etc. The reason behind the name Crystal reports is because of its crystal clear and pixel perfect visuals.
Crystal reports use JDBC/ODBC connectors and SQL as the interaction language to connect to the SAP HANA database.
SAP Design Studio
SAP Design Studio is a dashboard designing tool that enables business users to create interactive reporting applications and dashboards. It is an advance-level designing tool that connects to the SAP HANA database using a BICS connection communicating through SQLDBC language.
Design Studio requires complete compatibility and support with SAP NetWeaver BW and SAP HANA platforms. It also provides the capability to do server-side programming.
MS Excel is a popular Microsoft tool. Business users can connect to the SAP HANA database through a direct OLAP connection via an ODBO connector that communicates using MDX language.
Only MS Excel can access hierarchical data and data in cube models, i.e., Analytic View and Calculation View in SAP HANA.
Analysis Office (OLAP)
Analysis Office is a self-service analysis tool, especially for multi-dimensional data analysis. It works on an OLAP type connection that establishes via BICS connector using SQLDB language connected to the SAP HANA database or SAP BW.
Users can access OLAP data sources and integrate data from more than one OLAP sources.
Explorer is an information-discovery or exploring tool using which users from all over the enterprise can access the information and draw fresh insights from it. The Explorer tool connects to the SAP HANA database through an OLAP connection using a JDBC connector and SQL language.
Universe designer (IDT/UDT)
Universe Designer is a platform to design an intermediate layer on top of the SAP HANA database in case of indirect (relational) connections made with reporting tools like WebI (Web intelligence) and Dashboard Designer.
Universes are semantic layers which transform the information from relational and OLAP non-SAP data sources into business specific information. The reporting tools use the data available in the universe models instead of directly accessing the database.
A universe can be designed in two ways, either by using an Information Design Tool (IDT) or Universe Design Tool (UDT).
A universe is a semantic layer where we can manipulate data in different ways like applying filters, parameters, creating or deleting objects, business layer views, predefined queries, aggregation, variable mapping, etc.
After a semantic layer or universe creates, it publishes on the Business Objects Server Repository from where reporting tools such as Web Intelligence and Dashboards use them. Both IDT or UDT connects to the database using JDBC or ODBC connections communicating through SQL.
Web Intelligence is an advance-reporting tool having capabilities for ad-hoc reporting, detailed reporting, using query panels, etc. WebI access data from semantic layers through universes created using IDT tool.
The semantic layer creates on top of a non-SAP data source. With IDT, you can access multiple data sources, whereas, with UDT you can only access one data source at a time.
Dashboard Designer is a reporting tool in SAP BusinessObjects BI4 package for designing dashboards. It provides users with pre-designed dashboard templates which we can utilize in creating static or dynamic charts and visualizations as a part of the dashboard.
Dashboard designer also connects to data sources via universes.
Connections in SAP BusinessObjects Reporting Tools
All the SAP BusinessObjects reporting tools that we have discussed above form either a relational or an OLAP connection with the database layer.
A relational connection is made when the user needs to access conventional data tables. Relational connections can only be made via IDT or UDT created semantic layers.
On the contrary, if you need to access multi-dimensional data cubes, then an OLAP connection is required. It is a direct connection to the business layer of the data model as opposed to the relational connection which is an indirect connection.
These connections enable a user to connect to the data tables or information views in SAP HANA.