SAP BW ON HANA Training Contents
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
Data Source Enhancements