S4 SAP BW ON HANA

SAP BW ON HANA COURSE OVERVIEW

• SAP BW on HANA is the next wave of SAP’s in-memory technology vision that enables SAP NetWeaver BW to use SAP HANA as a fully functioning in-memory database.
• Running SAP BW on HANA results in dramatically improved performance, simplified administration and streamlined IT landscape resulting in a lower total cost of ownership.
• SAP BW on HANA is nothing but SAP’s Existing database for the NetWeaver BW Data Warehouse.
• Because SAP HAAN is much faster than regular relational databases like Oracle or Microsoft SQL Server, the data warehouse performs much faster.
• The Purpose of SAP BW on HAAN is to combine the power of both.

SAP BW ON HANA BENEFITS

• Excellent query performance for improved decision making.
• Simplified data modeling and remodeling.
• Faster decision making – Having the right information when you need it.
• Lower total cost of ownership.
• Simplified configuration and operational management.

SAP BW ON HANA COURSE CONTENT

• 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 Object Catalogs
• Info Objects
• PSA
• Info Area
• 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 Courses for sap BW on HANA training
• 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

REPORTING – BUSINESS EXPLORER

• BEX Query designer
• 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
• BEX Analyzer
• BEX WAD

ANALYSIS FUNCTIONS

• Conditions
• Exceptions
• Reporting Drilldown
• Drill down 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