SP BW 7.5 on HANA advanced course

| /


Do you want to take this course remotely or in person?

Contact us by email: info@nanforiberica.com , phone: +34 91 031 66 78, WhatsApp: +34 685 60 05 91 , or contact Our Offices


Course Description: SP BW 7.5 on HANA Advanced Course

  • Individualized support in Spanish
  • Access duration: 3 months
  • Duration in hours: approximately 170 hours, for an average participant with a certain level of basic knowledge of technical English language and technology
  • Fee: Request offer
  • Laboratories, practices and activities: As indicated in the attached video


SAP BW is a data warehouse tool. In simple terms, it integrates data from different sources, transforms and consolidates, cleanses and stores data as well. It also includes data modeling, administration, and staging. Content-rich SAP BW sets a precedent for speed and ease of implementation and maintenance as it is pre-configured with intelligence about a company's business process, providing faster return on information. SAP BW remains open to different source code system, and also has ease of implementation and maintenance. Enterprise demand for end users who need expertise in integrating ERP data into corporate data warehouses is growing exponentially. This creates great opportunities for certified SAP BW professionals in defining their professional career.

Course objectives

After completion of this course, the participant:

  • Understand the latest developments, capabilities and concepts of SAP BW 7.5 on HANA
  • Get an overview of how to migrate and use SAP BW with SAP HANA
  • Obtain the knowledge to migrate standard objects in SAP BW to InfoProviders 4 optimized for HANA.
  • Gain the ability to understand real-time data integration and agile data modeling
  • Gain knowledge about data provisioning methods related to SAP HANA for SAP BW 7.5
  • Learn about BW Enterprise Data Warehousing and its application
  • Understand HANA modeling and its use in your application

Course content

Unit 1: Introduction to SAP HANA Studio

Introduction to SAP HANA


History of SAP HANA

Overview of SAP HANA Studio

SAP HANA Technology Innovations

Unit 2: SAP HANA Architecture

SAP HANA Architecture


Index Server

Persistence Layer

Unit 3: Data Provision Methods

Overview of Data Provision Methods


Flat file Uploading

How to get multidimensional Sales Report

Overview of Business Objects Data Services using ETL-based approach

Unit 4: Accounts Payable

Introduction to SAP HANA Information Models


Analytical View for COPA Plan using Attribute views and COPA Actual

How to use join operators in building Calculation view

Methods to create Calculation view

Unit 5: Overview of SAP BW 7.5 on HANA 1.0

Overview of SAP BW 7.5 on HANA 1.0

Data Warehousing Workbench

Unit 6: InfoObjects and DataStore Objects

Overview of InfoObjects

Creating Characteristics under Catalog

InfoObjects Characteristics and Key Figures

Classification of Master Data

Creating Characteristics

Overview of Key Figures and Data Flow

Overview of DataStore Objects

How to load transactional data to DataStore Objects

SAP HANA Optimized DSO

Lookups on Active data DSO

Unit 7: SAP HANA InfoSource and Transformations

Explaining Transformations Framework and Expert Routines using Scenario based example

Mapping One Source Field to Target Field

Working with Expert Routines

Writing Expert Routines Code in ABAP

Introduction to InfoSource and Execution of two transformations before executing multiple transformations

InfoSource as a uniform source for several targets as targets from different sources

Return Tables using Transformation

Creating Dataflow using GUI Data flow in SAP BW on HANA and BW Oracle

Unit 8: InfoCube

DTP and its role in loading data to InfoCube in Extraction mode

Real-time Data Replication from Source system to BW and Real-time HANA Optimized InfoCubes

Unit 9: SLT Configuration, MultiProviders and Extractions

Steps for performing SLT Configuration

Explaining the three scenarios to implement in SLT

Introduction to MultiProvider and Creating MultiProvider in SAP BW 7.5

How are MultiProviders and InfoSets similar?

Mixed Models

ECC Extractions

Different Extractor types

Steps for Data Extraction method from Non-SAP Source systems

ECC Extractor using Business Content Extractors for Accounts Receivable

Loading data for characteristics, Master data using Business Content Extractors

Unit 10: BW Reporting

Introduction to BW Reporting - BEx Reporting Suit

Important Business Explorer Designers

BEx Query Navigation Options in WebQuery

Creating KeyFigure at InfoProvider and query level

Previous requirements

  1. Proficient in basic data storage concepts.

  2. It is advisable to have experience in the ABAP language

This course is best suited for the following professionals:

  1. SAP BW Practitioners
    2. SAP BW Application Consultants
    3. SAP Technical and Functional Consultants
    4. Professionals with interest in Data Warehousing
    5. Software Analysts and Mainframe Professionals
    6. Project Managers and Business Objects Professionals
    7. Those who aspire to a career in SAP BI/B


Contents: An important part of the course is in the English language as well as the practices and laboratories. 


If you are interested in taking this course in any training modality, please contact us.

Information related to training

Soporte siempre a tu lado

Training support: Always by your side

Formación presencial y telepresencial

Do you need another training modality?


Bonuses for companies