Tag Archives: sap bw on hana

SAP BW HANA Training

SAP BW HANA Training Course Content

BW/4HANA is an evolution of BW that is completely optimized and tailored to SAP HANA. The BW/4HANA code can only run on SAP HANA as it is interwoven with SAP HANA engines and libraries. The ABAP part is several million lines of code smaller compared to BW-on-HANA.

 

Highlights of training:

  • Real time Industry Experienced Trainer
  • Interactive Training session using web conferencing tool
  • Normal track, weekend and fast track classes
  • Class Recordings
  • Training Material, Exercises and Real time examples with case studies
  • Resume preparation and Certification Guidance

Introduction to Data Warehousing :

  • Architecture of Data Warehousing
  • OLTP Vs OLAP
  • Multi-Dimensional Modeling/ Star Schema Vs Entity Relationship Modeling
  • Enterprise Reporting, Query and Analysis
  • ETL and Reporting Tools
  • Evolution of SAP BW/BI and HANA Landscape

Introduction to SAP BW/BI :

  • Evolution of HANA
  • Evolution and Architecture of SAP BW with HANA
  • Modeling, Extraction and Reporting
  • Installation of SAP HANA Studio and SAP GUI

MODELING of SAP BW 7.5 with SAP HANA :

  • Introduction of basic terminology and objects
  • Data Extraction and Data Flows

Info Providers:

  • Master Data – Attributes, Texts, Hierarchies
  • Standard, Write-optimized , Direct Update DSO’s
  • Standard Info Cube and Virtual Provider
  • Logical Layers: Info Set and Multi Provider
  • Open Hub Destination
  • Analysis Process designer

HANA Optimized Objects

  • HANA-Optimized InfoCube
  • Semantically Partitioned Object
  • Advanced Data Store Object
  • Open ODS Views
  • Composite Provider
  • HANA Analysis Process

Importing SAP BW models in SAP HANA

Importance of Business Content ,Installation and Activation

Data Acquisition/Extraction :

  • Flat file Extraction
  • Overview of ECC6.0 Extractions
  • Master Data extraction Customer, Vendor, Material
  • Finance(FI), Sales and Distribution(SD) and Material Management modules
  • Generic Data Extraction using Master and Transaction data tables

Process Chains:

  • Process Chains and Process Types
  • Administration activities
  • Real time scenarios from support projects

Transport Mechanism :

  • Review of system Landscape
  • Creating Transports
  • Releasing, Importing and Monitoring Transports

Reporting :

  • Business Explorer Query Designer and Analyzer
  • Reusable Query Elements
  • Filters, Columns & Rows
  • Characteristic Restrictions & Free Characteristics
  • Formulas & Calculated Key Figures
  • Restricted Key figures and Variables with Texts
  • Report to Report Interface or Jump Starts
  • Exceptions, Conditions, Structures, Cell Definitions
  • Business Explorer Analyzer
  • Introduction to Business Explorer Analyzer
  • Filtering
  • Properties available in Analyzer

Performance Improvement

  • Column Store and Row Store
  • Aggregates
  • Compression
  • Partitioning
  • Indexes and DB Statistics
  • Read Mode & OLAP cache
  • Line Item Dimension & High Cardinality

Introduction to SAP ABAP

  • SAP ERP Introduction and Architecture
  • SAP ABAP

ABAP Programming Techniques:

  • ABAP Development Workbench Tools
  • Object Navigator
  • Workbench Organizer and Data Dictionary
  • ABAP Dictionary
  • Tables
  • Views
  • Lock Objects
  • Reports Statement
  • Declarations
  • Tables
  • Includes
  • Variables (Data Types and Data Objects)
  • Structures

ABAP for SAP BI requirements:

  • Field level Routine
  • Start Routine
  • End Routine
  • Expert Routine
  • Infopackage level Routine
  • DataSource Enhancements

SAP BW on HANA Training

BW/4HANA is an evolution of BW that is completely optimized and tailored to SAP HANA. The BW/4HANA code can only run on SAP HANA as it is interwoven with SAP HANA engines and libraries. The ABAP part is several million lines of code smaller compared to BW-on-HANA.

 

SAP BW on HANA Training Course Content.

 

Highlights of training:

  • Real time Industry Experienced Trainer
  • Interactive Training session using web conferencing tool
  • Normal track, weekend and fast track classes
  • Class Recordings
  • Training Material, Exercises and Real time examples with case studies
  • Resume preparation and Certification Guidance

 

Introduction to Data Warehousing :

  • Architecture of Data Warehousing
  • OLTP Vs OLAP
  • Multi-Dimensional Modeling/ Star Schema Vs Entity Relationship Modeling
  • Enterprise Reporting, Query and Analysis
  • ETL and Reporting Tools
  • Evolution of SAP BW/BI and HANA Landscape

 

Introduction to SAP BW/BI :

  • Evolution of HANA
  • Evolution and Architecture of SAP BW with HANA
  • Modeling, Extraction and Reporting
  • Installation of SAP HANA Studio and SAP GUI

 

MODELING of SAP BW 7.5 with SAP HANA :

  • Introduction of basic terminology and objects
  • Data Extraction and Data Flows

 

Info Providers:

  • Master Data – Attributes, Texts, Hierarchies
  • Standard, Write-optimized , Direct Update DSO’s
  • Standard Info Cube and Virtual Provider
  • Logical Layers: Info Set and Multi Provider
  • Open Hub Destination
  • Analysis Process designer

 

HANA Optimized Objects

  • HANA-Optimized InfoCube
  • Semantically Partitioned Object
  • Advanced Data Store Object
  • Open ODS Views
  • Composite Provider
  • HANA Analysis Process

Importing SAP BW models in SAP HANA

Importance of Business Content ,Installation and Activation

 

Data Acquisition/Extraction :

  • Flat file Extraction
  • Overview of ECC6.0 Extractions
  • Master Data extraction Customer, Vendor, Material
  • Finance(FI), Sales and Distribution(SD) and Material Management modules
  • Generic Data Extraction using Master and Transaction data tables

 

Process Chains:

  • Process Chains and Process Types
  • Administration activities
  • Real time scenarios from support projects

 

Transport Mechanism :

  • Review of system Landscape
  • Creating Transports
  • Releasing, Importing and Monitoring Transports

 

Reporting :

  • Business Explorer Query Designer and Analyzer
  • Reusable Query Elements
  • Filters, Columns & Rows
  • Characteristic Restrictions & Free Characteristics
  • Formulas & Calculated Key Figures
  • Restricted Key figures and Variables with Texts
  • Report to Report Interface or Jump Starts
  • Exceptions, Conditions, Structures, Cell Definitions
  • Business Explorer Analyzer
  • Introduction to Business Explorer Analyzer
  • Filtering
  • Properties available in Analyzer

 

Performance Improvement

  • Column Store and Row Store
  • Aggregates
  • Compression
  • Partitioning
  • Indexes and DB Statistics
  • Read Mode & OLAP cache
  • Line Item Dimension & High Cardinality

 

Introduction to SAP ABAP

  • SAP ERP Introduction and Architecture
  • SAP ABAP

 

ABAP Programming Techniques:

  • ABAP Development Workbench Tools
  • Object Navigator
  • Workbench Organizer and Data Dictionary
  • ABAP Dictionary
  • Tables
  • Views
  • Lock Objects
  • Reports Statement
  • Declarations
  • Tables
  • Includes
  • Variables (Data Types and Data Objects)
  • Structures

 

ABAP for SAP BI requirements:

  • Field level Routine
  • Start Routine
  • End Routine
  • Expert Routine
  • Infopackage level Routine
  • DataSource Enhancements

SAP HANA Training

SAP HANA Training by Experts Live Instructor Led Classes with Certification Material SAP HANA Online Training Course in USA UK Canada and Australia Free Demo Pay In Installments Project Scenarios Job Support.

SAP HANA  Training Course Content.

1.SAP HANA Introduction

  • In-Memory Computing
  • Evolution of In-Memory computing at SAP
  • History HANA
  • HANA Hardware Sizing
  • Product Availability Matrix
  • HANA compare to BWA

2.SAP HANA Overview

  • Architectural overview
  • Row Store
  • Column Store
  • Persistency Layer

3. SAP HANA Versions and Studio overview

  • SAP HANA Version
  • History of Service pack details
  • Studio Overview
  • HANA Studio Preferenc
  • es
  • HANA Studio Prospective

4. SAP HANA Engines

  • Column Store Engine
  • Row Store Engine
  • Join Engine
  • OLAP Engines
  • Calculation Engine
  • Calculation Engine’s Non-RelationalBehavior
  • SAP HANA General Modeling Principles

SAP HANA Modeling
Attribute View

  • How to connect tables using
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Text Join
  • Referential Join
  • Union
  • Filter
  • Calculated Column

Analytic View

  • Structural Overview
  • Data Foundation
  • Logical View
  • Define View Semantics
  • Left Outer Join – Attribute View
  • Inner Join – Analytical View
  • Right Outer Join – Analytical View
  • Referential Join – Analytical View
  • run-time object: column view
  • Calculated Attribute
  • Calculated Measure
  • Restricted Measure
  • Filter
  • Input Parameter

Tables in HANA

  • Column Store Table
  • Row Store Table
  • Table type

SQL in HANA

  • Basic SQL Knowledge
  • Select Statement
  • From Clause
  • Where Clause
  • Group By clause
  • Having Clause
  • Order by Clause
  • Top N clause

SQL Procedure in HANA

  • How to create Procedure
  • Elements of the Procedure
  • Procedures using Column Store Views
  • IF-ELSE Logic
  • For Loop Logic
  • Cursor in HANA
  • Dynamic Filter

CE based Script in HANA

  • CE_COLUMN_TABLE
  • CE_JOIN_VIEW
  • CE_OLAP_VIEW
  • CE_CALC_VIEW
  • CE_JOIN
  • CE_LEFT_OUTER_JOIN
  • CE_RIGHT_OUTER_JOIN
  • CE_FULL_OUTER_JOIN
  • CE_PROJECTION
  • CE_CALC
  • CE_AGGREGATION
  • CE_UNION_ALL

Calculation View

  • Graphical Calculation View
  • Calculation SQL Script method
  • GraphicalCalculation View Working with Nodes
  • Graphical Calculation View Define View Result Set
  • Graphical Calculation View Define View Semantics
  • How to call Calculation view using SQL into Calculation Views
  • Script-based CV: output column structure import
  • Scenario redesign: replace node / replace data sources
  • Extract semantics from data sources
  • Table function as data sources
  • Debugging Views with drill-down analysis
  • Calculation View limitations in Designing and performance issues
  • Select count (*) statement on top of a HANA graphical Calculation View leads to unexpected number ofrecords in the result set.

Miscellaneous

  • Delivery Units
  • Transport Individual HANA Models
  • How to load Excel data into HANA using Studio
  • Export/Import
  • How to create Sequence
  • How to create Synonym
  • How to create Trigger
  • How to create View

Performance Tuning

  • Index creation
  • Partitioning
  • Hash Partition
  • Merge Partition
  • Round Robin Partition
  • Multi-Level Partition
  • Table Redistribution

Security & User Management

  • Creating Users
  • Creating Roles
  • Privileges
  • Authorization challenges
  • User Administration
  • Backup & Recovery
  • Collecting traces

Data Provisioning

  • SAP Data Services extraction
  • SAP SLT Replication
  • Smart Data Access
  • AP HANA-Direct Extractor Connection (DXC)

SAP Data Services Overview

  • What is SAP Data Services
  • SAP Data Services Architecture
  • SAP Data Services objects (Job, Data Flow, Work Flow, Transformations)

SAP Data Services Extraction

  • Loading Data from SAP ECC to SAP HANA DB
  • Loading Data from SAP BW to SAP HANA DB
  • Loading Data from MSSQL Server DB to SAP HANA DB
  • Loading Data from Excel to SAP HANA DB
  • How to load data from HANA Information Models to MSSQL DB

SAP SLT Data provisioning overview

  • What is SAP SLT
  • SAP SLT License options
  • SAP SLT system sizing
  • SAP SLT system landscape preparation

SAP SLT Schema configuration

  • How to configure SLT Schema for SAP Source system
  • How to configure SLT Schema for Non-SAP Source system
  • No.of Data transfer Jobs configuration
  • How to improve Initial data loading
  • Tables configuration in SLT using Data Provisioning

SAP SLT Performance tuning technics

  • Monitoring Replication in SLT
  • Access Plan
  • Reading Types
  • Adding Entry in the table IUUC_PRECALC_OBJ
  • Adding Entry in the table IUUC_PERF_OPTION
  • MWBMON
  • How to do Partition in SLT
  • How to restrict the tables that are allowed for replication
  • HANA Supported Data Types
  • How to change the standard mapping

HANA Advanced Analytics

HANA Reporting BO Tools

    • How to Connect with IDT
    • How to create Universe using HANA Tables
    • How to create Webi Reports
    • Webi Functions
    • How to schedule Webi reports
    • How to assign the WebI reports to the End users

HANA Reporting with Crystal Reports 2013

  • Report Designer
  • Report creation wizard
  • Sections
  • Sorting and Grouping
  • Chart expert
  • Formulas
  • Sub reports

HANA Reporting with Crystal Reports for Enterprise

  • How to Connect HANA with Crystal Reports for Enterprise
  • How to create reports

HANA Reporting with SAP Dashboards

  • How to Connect HANA with Dashboards
  • How to create Dashboard Reports

HANA Reporting with SAP Lumira

  • How to Connect HANA with SAP Lumira
  • How to Explore HANA Data with Lumira
  • Publish Lumira report

HANA Reporting with SAP Design Studio

  • SAP Design Studio Overview
  • How to create reports

HANA Reporting with SAP Predictive Analysis

  • SAP Predictive Analysis Overview
  • How to Explore data with Predictive Analysis

BW 7.3 powered by HANA Overview

    • BW 7.3 powered by HANA Overview
    • BW7.30-HANA Optimized Info Cube
    • BW7.30-HANA Optimized Info DSO
    • Importing SAP BW7.30 Models into HANA Modeling environment
    • Publish Standalone HANA Models into SAP BW 7.30 on HANA
    • BW on HANA Migration activities

SAP HANA as Secondary Database

  • Architectural Concept

SAP HANA End to End Mock Implementation Project

  • How configure SAP 150 ECC tables using SLT Replication
  • How to configure Data loads using SAP Data Services from Oracle DB
  • How Create HANA Information models based on Business Requirement
  • Creating HANA Models using Combination of multiple Sources
  • How to generate SAP BO reports and Assign to End User
  • Creating 3 HANA Implementation projects Proof of Concepts
  • Guidance to Create HANA models Architecture for Implementation project

SAP HANA Certification Guidance

  • SAP HANA Exam Code C_HANAIMP141
  • HA100 and HA300 Documents can be provide for certification preparation purpose.
  • SAP HANA Exam Dumps can be provided, to clear certification exam.

SAP BW on HANA Interview Questions

SAP BW on HANA Interview Question And Answers:

Q.What is the DIM ID?

Dim ids ink dimensions to the fact table.

FOR Course Content   Click me


Q. What is the time distribution option in update rule
This is to distribute data according to time; for example if the source contains calendar week and the target contains calendar day, the data is spit for each calendar day. Here you can select either the normal calendar or the factory calendar.


Q. What are the types of attributes?
Display only and navigational; display only attributes are only for display and no analysis can be done; navigational attributes behave like regular characteristics; for example assume that we have a customer characteristics with country as a navigational attribute; you can analyze the data using customer and country.


Q. What are the steps to load non cumulative cube?

  • initialize opening balance in R/3 (S278)
  • activate extract structure MCO3BFO for data source 2LIS_03_BF
  • set up historical material documents in R/3
  • load opening balance using data source 2LIS_40_S278
  • load historical movements and compress without marker update.
  • set up V3 update
  • load deltas using 2LIS_03_BF.

Q. What is a transnational info cube?
These cubes are used for both read and write; standard cubes are optimized for reading. The transactional cubes are used in SEM.

Top ↑