SAP BW on HANA Training | BW362 SAP BW on HANA Course:
Attend free demo today for Online SAP BW on HANA Training by realtime experts Learn SAP BW362 powered by HANA Online Training with Course Material pdf live Tutorial video classes SAP BW on HANA 7.5 Certification Training Best institute within Reasonable Fee Hyderabad Bangalore Canada USA Singapore UK Australia South Africa Dubai Malaysia London Italy France Spain
Attend free demo today for Online SAP BW on HANA Training by realtime experts Learn SAP BW362 powered by HANA Online Training with Course Material pdf live Tutorial video classes SAP BW on HANA 7.5 Certification Training Best institute within Reasonable Fee Hyderabad Bangalore Canada USA Singapore UK Australia South Africa Dubai Malaysia London Italy France Spain
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