SAP BW on Hana Online Training

SAP BW on Hana Online Training



    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

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    • 4 weeks, 2 days
    Contact Us

    +1 475-212-0075

    Drop us a query

    Error: Contact form not found.

    Job Support

    Error: Contact form not found.

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies