Tag Archives: Online SAP BW on HANA Training

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

 

 

Student Reviews :

 

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 ↑