SAP BW on Hana Online Training

 >>  SAP BW on Hana Online Training

SAP BW on Hana Online Training


 (4.8) | 750 Ratings


Introduction


SAP BW on Hana Online Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 30 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course 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

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

Exam & Certification

0

Course Review

(4.8)
5 stars
4 stars
3 stars
2 stars
1 stars

Course 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

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

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry