Introduction

SAP BW on Hana Training makes you an expert in concepts like DTP (Data Transfer Process),DSO (Data Store Object), accelerating BW data access, Analysis Process & Design, Scheduling, Analysis Functions, Reporting – Business Explorer, Info Cube Maintenance and Info Providers..etc.

Course Content

1.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

2.Rule Types Routines

• Start Routine
• End Routine
• Expert Routine

3.DTP (Data Transfer Process)

• Standard DTP
• Error DTP
• Direct Access DTP
• Real time DTP

4.DSO (Data Store Object)

• Standard DSO
• Write optimized DSO
• Direct update DSO
• APD (Analysis Process & Design)
• Update Methods
• Full updates
• Initialization
• Delta Updates

5.Info Providers

• Multi Providers
• Info set
• Virtual Providers
• Re-Modeling
• Re-Partitioning
• Open-Hub Destination
• Data Marts

6.Info Cube Maintenance

• Aggregates
• Roll-up
• Compression
• Reconstruction

7.Process Management

• Process Chains
• Process Types
• Scheduling
• Monitor (Header, Status, Details)

8.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

9.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