SAP BW on HANA Online Training Course Content

SAP BW on HANA Online Training

SAP Trainings Online SAP BW on HANA Training

SAP BW on HANA Online Training Overview

SAP BW on HANA is the next wave of SAP’s in memory technology vision. Running of SAP BW on HANA results in improved performance and simplified administration. This SAP BW on HANA online training enables to implement SAP BW powered by SAP HANA and advantages of the in memory solution with SAP BW.The SAP BW on HANA online training session explains HANA specific elements and aspects of SAP BW by introducing new scalable architecture which helps to familiarize with HANA optimized data modeling approach on SAP BW.

SAP BW on HANA Online Training Curriculum

Overview of SAP BW IN HANA

  • 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 and different Types of Attributes Transformations

Rule types routines

  • Start Routine
  • End Routine
  • Expert Routine

DTP (Data Transfer Process)

  • Standard 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

Info Providers

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

Info Cube Maintenance

  • Aggregates
  • Roll-up
  • Compression
  • Reconstruction

Process Management

  • Process Chains
  • 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

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