SAP BW ON HANA ONLINE TRAINING @ VIVANTA IT LABS
An online course designed to make you an expert in using SAP BW on HANA and learn all that is required to implement and maintain SAP BW powered by SAP HANA and outlines advantages of the new “In-Memory” Solution with SAP BW.
BW functions performed within SAP HANA benefit from its in-memory planning capabilities and calculation engines, accelerating BW data access. No need for aggregates in it. The system creates logical indexes for the SAP HANA-optimized InfoCube. Composite Provider enables to combine ad-hoc data with consolidated data and use the OLAP functions of the BW system for analysis. It create a VirtualProvider based on a SAP HANA model SAP BW on HANA Online training enables implement SAP BW powered by SAP HANA and advantages of the “In-Memory” Solution with SAP BW.
SAP BW on Hana Online Training Overview
Vivanta IT Labs offers the complete spectrum of IT training focus on business objectives. The sessions explains HANA specific elements and aspects of SAP BW With introducing a new Layered Scalable Architecture help to familiarize with a HANA optimized data modeling approach on SAP BW. Our unique approach of teaching methodologies includes implementing solutions to student requirements by real-time Practitioners.
SAP BW on Hana Training Curriculum
Overview of the SAP BW in Hana
Module One: Enterprise Structure Introduction to ERP
SAP
Data Warehouse Overview of BW, BI
Data Base
Overview of BW Architecture
Landscape Basic Modeling
Create a valid Schema Multi-Dimensional Model – The Star,Schema (Classical Approach) Multi-Dimensional Star
Schema in
BW (Extended star Schema) The OLAP Concept
Differences between OLAP and OLTP Business Modeling
Info Area,Info Object Catalogs and Info Objects
PSA
Application Component
Info Source, Data Source
Transfer Rules, Update Rules
Transfer Structure, Communication Structure
Info Package
Transformation, Data Transfer Process
Loading Transactional Data into BW info Cube Loading MD with TD into BW System BW and BI Comparisons Master
Data loading-new(BI) ETL process
Info cube & Types
Standard Info cube and Loading with new ETL Process
Generate Report with BI master and Transaction Data
Manual Uploading of MD like Attributes
Text, Hierarchy
Different Types of Attributes Transformations
SAP
Data Warehouse Overview of BW, BI
Data Base
Overview of BW Architecture
Landscape Basic Modeling
Create a valid Schema Multi-Dimensional Model – The Star,Schema (Classical Approach) Multi-Dimensional Star
Schema in
BW (Extended star Schema) The OLAP Concept
Differences between OLAP and OLTP Business Modeling
Info Area,Info Object Catalogs and Info Objects
PSA
Application Component
Info Source, Data Source
Transfer Rules, Update Rules
Transfer Structure, Communication Structure
Info Package
Transformation, Data Transfer Process
Loading Transactional Data into BW info Cube Loading MD with TD into BW System BW and BI Comparisons Master
Data loading-new(BI) ETL process
Info cube & Types
Standard Info cube and Loading with new ETL Process
Generate Report with BI master and Transaction Data
Manual Uploading of MD like Attributes
Text, Hierarchy
Different Types of Attributes Transformations
Rule Types Routines
Start Routine
End Routine
Expert Routine
End Routine
Expert Routine
DTP (Data Transfer Process)
Standard DTP
Error DTP
Direct Access DTP
Real time DTP
Error DTP
Direct Access DTP
Real time DTP
DSO (Data Store Object)
Standard DSO
Write optimized DSO
Direct update DSO
APD (Analysis Process & Design)
Update Methods
Full updates
Initialization
Delta Updates
Write optimized DSO
Direct update DSO
APD (Analysis Process & Design)
Update Methods
Full updates
Initialization
Delta Updates
Info Providers
Multi Providers
Info set
Virtual Providers
Re-Modeling
Re-Partitioning
Open-Hub Destination
Data Marts
Info set
Virtual Providers
Re-Modeling
Re-Partitioning
Open-Hub Destination
Data Marts
Info Cube Maintenance
Aggregates
Roll-up
Compression
Reconstruction
Roll-up
Compression
Reconstruction
Process Management
Process Chains
Process Types
Scheduling
Monitor (Header, Status, Details)
Process Types
Scheduling
Monitor (Header, Status, Details)
Reporting – Business Explorer
BEX Query designer
BEX Analyzer
BEX WAD
BEX Report Designer
Visual Composer
Functional Overview of Bex Query
Designer Reusable Query Elements
Query Controls with Variables
Calculated Key Figures
Restricted Key Figures
Formulae
Structures
Variable Definition in Detail
Characteristic values variables
Text Variables
Formula Variables
Hierarchy Variable
BEX Analyzer
BEX WAD
BEX Report Designer
Visual Composer
Functional Overview of Bex Query
Designer Reusable Query Elements
Query Controls with Variables
Calculated Key Figures
Restricted Key Figures
Formulae
Structures
Variable Definition in Detail
Characteristic values variables
Text Variables
Formula Variables
Hierarchy Variable
Analysis Functions
Conditions
Exceptions
Reporting Drilldown
Drilldown to DSO from Info Cube (RRI)
Copying Queries from Cubes
Bex Analyzer Bex WAD Bex Report Designer
Visual Composer Migration Objects from BW 3.x to BI 7.0
Transportation Extraction
Generic Data Extraction using MD/TD Tables
COPA Extraction
Business Content Extractions using MD/TD
LO-COCKPIT Data Extraction
Delta types for Generic Extraction
LO Extraction
ASAP methodology
Exceptions
Reporting Drilldown
Drilldown to DSO from Info Cube (RRI)
Copying Queries from Cubes
Bex Analyzer Bex WAD Bex Report Designer
Visual Composer Migration Objects from BW 3.x to BI 7.0
Transportation Extraction
Generic Data Extraction using MD/TD Tables
COPA Extraction
Business Content Extractions using MD/TD
LO-COCKPIT Data Extraction
Delta types for Generic Extraction
LO Extraction
ASAP methodology
FEEL FREE TO CONTACT US
Your feedback is valuable to us. Please send us your suggestions.
USA OFFICE
- 140 Metro Park, Suite 7A, Rochester, NY, 14623
- 585-492-6226
- 585-302-1231
- 585-302-1232
INDIA OFFICE
- Flat:G1, 376/2RT, Srinivasa Mansion, Behind AXIS Bank, S.R.Nagar, Hyderabad-500038
- +91 8125577577
- +91 8978946494
- +91 9553392535


