SAP BW on Hana Online Training

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

Course Reviews

No Reviews found for this course.

Drop us a query

Looking for a training for

 Myself My team/organization

captcha

top
Copyright © 2015 KEEN IT TECHNOLOGIES Pvt.Ltd, ALL RIGHTS RESERVED  |   PRIVACY POLICY   |   TERMS OF USE   |   REFUND AND RESCHEDULE POLICIES   |   SITEMAP  
Keen IT is not an affiliate of SAP AG or other products.
error: Content is protected !!