SAP BW On Hana Certification Training

✔ Evolution of HANA Landscape
✔ SAP HANA Basics
✔ SAP BW on HANA

✔ Identifying Transformational Opportunities
✔ Understanding Your Needs, Enterprise Needs, and Data Needs
✔ Working with Existing Solutions: SAP HANA versus SAP NetWeaver BWA
✔ Does SAP HANA Replace BW on HANA?
✔ Pros and Cons of BW on HANA
✔ Pros and Cons of SAP HANA

✔ HANA-Optimized DataStore Object
✔ HANA-Optimized InfoCube
✔ Semantically Partitioned Object

✔ Purpose of Information Modeler
✔ Levels of Modeling in SAP HANA
✔ Attribute Views
✔ Analytic Views
✔ Calculation Views
✔ Export & Import

✔ Models in SAP BW on HANA
✔ Data Extraction and Data Flow within SAP BW on HANA
✔ Transformation
✔ DTP (Data Transfer Process)
✔ Administration of InfoCubes and Aggregates
✔ DSO (DATA STORE OBJECTS)
✔ Virtual Cubes and Multi Providers

✔ Virtual Provider
✔ Transient Provider
✔ Composite Provider
✔ DB Connect
✔ Importing SAP BW models in SAP HANA
✔ Importing HANA optimized info cubes
✔ Importing HANA optimizes DSO

✔ ECC Extractions
✔ Overview of ECC6.0 Extractions.
✔ Generic Extractions
✔ Business Content Extractions
✔ CO-PA Extractions (COST PROFITABLE ANALYSIS)
✔ LO-COCK PIT Extractions (LOGISTICS)

✔ Introduction to BI Enterprise Reporting
✔ Navigating in Reports
✔ First Steps in Query Designer
✔ Key Figures
✔ CHARACTERISTICS
✔ Attributes
✔ Exceptions and Conditions

✔ Hybrid provider
✔ Generic delta functionalities for further types of Data Sources
✔ Hierarchies
✔ Data Transfer Process (DTP)
✔ Open Hub Service
✔ Transformation
✔ SAP BODS (New ETL Tool of SAP) Integration

✔ The SAP BW Star Schema Concept
✔ Data warehousing Workbench (DWB)
✔ Info Objects
✔ Info Cubes

✔ Loading Master Data (Attributes, Texts, Hierarchies)
✔ Loading Transaction Data

✔ Overview of new Datasource
✔ Migration of 3.x data source to BW 7.4/on HANA data source (LOGISTICS)

✔ Transformation

✔ Overview of DTPS
✔ Trouble shooting techniques in DTPS
✔ Debugging ABAP routines Using DTPS

✔ Business Content (BCT)

✔ Managing Basic Cubes
✔ Aggregates

✔ Data Store Objects concept

✔ Virtual Cubes
✔ Multi Providers
✔ DATA EXTRACTIONS (ETL)
✔ ECC extractions using BW on HANA Data flows

✔ Types of ECC extractions

✔ Generic Extraction using
✔ Database Table
✔ View
✔ Classical Info sets.
✔ Functional Module.

✔ Overview of Business Content Extractions.
✔ Examples from Financial, Logistics, and HRMS modules.

✔ Real time examples on process Chains (Meta Chains)
✔ REPORTING

✔ The SAP BI Overview

✔ Query Designer
✔ Info providers in query Designer

✔ Restricted Key Figures
✔ Calculated Key Figures
✔ Properties of Key Figures

✔ Properties and Attributes of Characteristics
✔ Integrating attributes and hierarchies in reports.

✔ Exceptions
✔ Conditions

✔ NEW ENHANCEMENTS OF SAP BW on HANA

✔ Integration of hierarchies into process flow (DTP, Transformation)
✔ Remote hierarchies for direct access to hierarchies in the source system
✔ Loading hierarchies from flat file using the new Data Source and Transformation technology

✔ Data Transfer Process supports data extraction from Multi Providers
✔ Option to only load the last request from a given source (available for full load DTPs)
✔ Data Transfer Process supports referential integrity checks tor navigational attributes of the target
✔ Enhanced load performance by the possibility to Re- package small data packages within a request to bigger packages

✔ SAP Net Weaver BW data can be exported in XML format
✔ Possibility to change the format and length of BW data for export even into a non-SAP specific format
✔ Hierarchy extraction supported by Open Hub