SAP BO on HANA Certification Training

SAP BO on HANA Certification Training

SAP BusinessObjects (BO) is an analytics tool which reports the data from SAP BW system. Very attractive dashboards and reports can be created utilizing this reporting tool. The integration with SAP BW is really good when compared with non-SAP sources. Our training program is composed of highly interactive classes delivered by industry expert Instructors. It consists of an in-depth curriculum that focuses on both theoretical concepts and hands-on lab exercises.
Start Date Duration Time (CST) Type Mode of Training Enroll
Flexible 55 Hrs Flexible Online INSTRUCTOR LED TRAINING Enquiry Now


SAP BO is a user focused BI suite which has data exploration, reporting and dashboard tools. Also, SAP BO has its own server for publishing and sharing, it is not a data repository by itself, but utilizes HANA and BW as sources of data. SAP BO on HANA talents is trending worldwide. SAP HANA professionals are in great demand across the globe. Nearly, 90% of the HANA jobs require knowledge and experience on SAP BO. Thus, integrated training on both BO & HANA will ensure a promising career in the SAP ERP technology.

Did you Know

  1.  90% of the HANA jobs globally require understanding and experience on SAP BO. This means combined training for BO and HANA can lead to highly rewarding careers in SAP ERP technology.
  2.  In the year 2008, SAP bought out BusinessObjects for $6.8 billion. BusinessObjects became a division of SAP and the company brand “SAP BusinessObjects” was established.
  3.  According to a recent market study, SAP has clocked more than $3 billion in annual revenues and has garnered nearly one-quarter of a market share in this industry.

Why learn and get certified in SAP BO 4.2 on HANA?

  1.  SAP BO 4.2 on HANA is a skillset that is gaining ground rapidly in the current market scenario. This means SAP HANA professionals are in high demand across the globe.
  2.  Business organizations face a growing need for database experts who can view problems from a business standpoint. Such organizations require its professionals to create end-user reporting tools and perform various complex functions on huge data sets. This can be made possible with training & certification on SAP BO 4.2 on HANA.
  3.  More than 3000 HANA customers rely on SAP BO 4.2 on HANA to resolve their issues. Thus, there is a great opportunity for professionals to start their career in SAP BO 4.2 on HANA.
  4.  Emerging SAP Technologies on Business Warehouse satisfies needs of end users which results in great opportunities for SAP BW on HANA professionals with niche skills.


  1.  A good and basic understanding of SQL, Database and Data Warehousing.
  2.  An understanding of Object Oriented Programming (OOP) concepts and functionalities will be an added advantage.
  3. Pre-requisites Materials provided: SQL TutorialData Modeling and DW concepts

Course Objective

After the completion of SAP BO 4.2 on HANA, trainees will:
  1.  Gain potentiality to apply end-user reporting tools for different scenarios
  2.  Expertise in basics and core concepts of SAP BO 4.2 on HANA like Data Provisioning methods, SAP BO Reporting tools, and SAP HANA Modeling
  3.  Attain ability to connect SAP HANA through Semantic Layer and create quick Ad-Hoc reports with functionalities Tables, Charts, Master Detail, Breaks, Pivot Table, Formulas and Variables
  4.  Resolve few real-time based scenarios related to SAP BO 4.2 on HANA

Who should attend this Training?

This certification is highly suitable for a broad range of professionals either aspiring to or already in the IT domain and Business process analytics, such as:
  1.  Professionals aspiring to a career in SAP HANA Database
  2.  Professionals looking for a career in BusinessObjects for SAP clients
  3.  Anyone who is working on SAP BW and wants a certification in SAP BO and SAP HANA
  4.  Professional working in different SAP module and want to shift to SAP BO

Prepare for Certification!

Our training and certification program gives you a solid understanding of the key topics covered on the SAP BO 4.2 on HANA. In addition to boosting your income potential, getting certified in SAP BO 4.2 on HANA demonstrates your knowledge of the skills necessary to be an effective SAP BO 4.2 on HANA Professional. The certification validates your ability to produce reliable, high-quality results with increased efficiency and consistency.

Unit 1: Overview SAP HANA 1.0

  1. Introduction to SAP HANAInformation Explosion
  2. Consumerization of ‘IT’
  3. ‘IT’ cannot deliver
  4. Reality with SAP HANA
  5. SAP In-Memory Appliance
  6. Hardware Innovations
  7. Bottlenecks
  8. Understanding Columnar Data Storage
  9. When to use Column store
  10. When to user Row Store
  11. Avoid Bottlenecks
  12. Customer feedback and benefits on SAP HANA Implementation Use cases

Unit 2: Product Availability Matrix (Supported H/w Vendors Platform)

Unit 3: BOBI 4.1 Architecture

  1. SAP HANA Appliance Architecture View
  2. SAP HANA Database Engine View
  3. SAP HANA Data-Loading View
  4. SAP HANA Data-Modeling View
  5. SAP HANA Reporting View
  6. SAP HANA Administrator View
  7. Persistence layer, Backup and Recovery

Unit 4: SAP HANA System Landscapes

Unit 5: SAP HANA System Sizing Guidelines

Unit 6: Data Provisioning

  1. Direct in HANA: Loading Data from Excel file to HANA Database with/ without Template Tables
  2. Via Data Services
    1. Loading Data from Oracle / Sql Server Database
    2. Loading Data from SAP ECC with Dataflow
    3. Loading Data from ECC with ABAP Dataflow
    4. Loading Data from BW to SAP HANA Databse
    5. Loading Metadata from SAP ECC to HANA Database
  3. Via Replication (Landscape Transformation)
    1. SAP Landscape Replication server for HANA
    2. Key benefits of SLT replication server
    3. Key benefits of Trigger-Based Approach
    4. Architecture for SAP source replication
    5. Architecture for Non-SAP source replication
    6. Configuration and monitoring Dashboard
    7. Creating new Configuration for SAP Sources
    8. Creating New Configuration for Non-SAP sources
    9. Result of Creating new Configuration
    10. Launching Data provisioning UI in HANA studio
    11. Start Load/Replication
    12. Stop/Suspend replication
    13. Status Monitoring in HANA Studio
    14. SLT based transformation Concept
    15. Advanced replication settings
    16. Change of table structuring and partitioning
    17. Filtering and selective data replication
  4. Via SAP DXC

Unit 7: SAP HANA Studio view

Unit 8: SAP HANA Modeling

  1. Data warehouse Concepts
  2. Data Modeling techniques
  3. Attribute Views (Standard / Derived / Time Dimension)
  4. Analytical View
  5. Calculation View
  6. HANA Modelling Approach
  7. Connecting Tables using Inner / Left outer / Right Outer / Full Outer / Text / Referential Join
      1. Data Definition Language (Create / Alter / Drop)
    Data Manipulation Language (Insert / Update Delete)
      1. Data Query Language (Select)
  9. Functions
  10. Creating procedures
  11. Creating Table Types
  12. Using CE-Functions
  13. Control Statements
  • Export and Import Models
  • HANA Modelling ApproachCase Study based on:
    1. Real world data warehouse Model
    2. SAP ERP Tables

Unit 9: SAP BO Reporting

  1. Client connectivity options
  2. SAP BO System Landscape Architecture and Product Availability Matrix
  3. MS-Excel
    1. Reporting via MDX
    2. Reporting via BICS)
  4. SAP BO Analysis
    1. Creating Analysis Workspace
    2. Putting up Visualizations
  5. SAP BO Explore
    1. Create Information Spaces
    2. Reporting via BICS)Create Exploration sets
    3. Use case of SAP BO Explorer
  6. SAP Lumira
    1. Connect directly to SAP HANA
    2. Connect through Semantic Layer (Universe)
    3. Prepare Data
    4. Visualize Data
    5. Create Storyboards (as good as simple Dashboard)
    6. Case Study to discover information
  7. Semantic Layer (Universe)
    1. Connect to SAP HANA using OLAP Connection
    2. Connect to SAP HANA using Relational Connection
    3. Create Data Foundation Layer
    4. Create Business Layer
    5. Deep dive to Universe like resolve loops, Object Qualifications, Customizing list of values, Derived Tables etc…
    6. Case Study based on Data warehouse model
  8. SAP Crystal Reports and Dashboards
    1. Connectivity to SAP HANA
    2. Create sample reports and Dashboards
  9. Webi
    1. Connect to SAP HANA through Semantic Layer (Universe)
    2. Create quick Ad-Hoc reports with below Functionalities
      1. Tables, Charts, Master Detail, Breaks, Pivot Table
      2. Formulas and Variables
      3. Apply Rankings, Conditional Formatting
      4. Apply Sorts
      5. Static and Dynamic filtering
      6. Case Study on creating quick Ad-Hoc Report
  10. Distribution to Users
    1. Send manually to various destinations like BI Inbox, Outlook Inbox, Shared Folder, FTP Destination
    2. Automate the Distribution Process to above Destinations
    3. Automate the Distribution Process with data level security to above Destinations

Unit 10: SAP HANA User Management

Unit 11: SAP HANA System Monitoring & Administration

Unit 12: SAP HANA Security & Authorization

Unit 13: Distributed System Landscape

Unit 14: Role of Solution Manager in SAP HANA

SAP certifications are globally recognised and standardised criterion for several roles and responsibilities in the Information Technology (IT) World. The certification details for SAP BO on HANA will be updated shortly.

Generic SPVT Training Faqs

What is Self-Paced Video Training?
Self-Paced Video Training (SPVT) program is designed to learn at your own pace. Students are given access to the LMS system and learn through pre-recorded session videos. They can access the assignments and materials through the LMS system. 24×7 access to Support is availa
Who are the Instructors and what are their qualifications?
All Instructors from ZaranTech are working professionals from leading organizations who have minimum of eight years of real-time consulting experience working on live projects and good subject knowledge. They have more than three years of experience in training. Most of our trainers are certified professionals as well and help the students to get certified.
How will I do my practicals?
We will help you to setup Virtual Machine in your system with local access. The detailed installation guides will be provided for setting up the environment. In case, your system doesn’t meet the prerequisites e.g. 4GB RAM, you will be provided remote access to the Server for the practicals. For any doubt, our 24*7 support team will promptly assist you.
How soon I would get access to the learning content after Signing up?
As soon as you enrol to the course, an immediate access to our course content in the form of Videos, PPTs, Assignments and Assessments will be provided so that you can start learning right away.