Course Detail

Course Description

Learn the basic concepts of ERP / SAP BW 7.4 (Traditional) & ERP/SAP HANA
(Architecture, Data Provisioning, Modeling & Reporting).

Understand the functionality and features of ERP / SAP BW 7.3/7.4 with ERP/SAP HANA 1.0
Learn how to do ERP / SAP BW 7.3/7.4 modelling & use reporting tools

Course Content:

Introduction to ERP/SAP BW concepts
Introduction to ERP/SAP R/3, ECC and BW
BW architecture
Multi-dimensional Modeling, Star Schema, BW extended Star Schema
Administrator Work Bench
Info Objects (attributes and texts and hierarchies)
Info Cubes, Transactional Info Cubes
ODS (DSO) –Standard, Transactional and Write Optimized
PSA, Source Systems
Info Source, Info Package, Transfer Rules, Update Rules, Transformation
Data Transfer Process
Loading Master Data using flat files
Loading transaction data using flat files
ODS -Change Log, Active Table and New Table
Managing Delta using ODS

Introduction to ERP/SAP HANA concepts

ERP/SAP HANA Implementation & Modeling concepts ERP/SAP HANA studio, Architecture,
Data Provisioning, Modeling & Reporting.

Introduction to ERP / SAP BW 7.4 on HANA

Evolution of HANA Landscape
ERP/SAP HANA Basics
ERP/SAP NetWeaver BW 7.4

ERP/SAP HANA and Business Strategy

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

ERP/SAP HANA Architecture

In Memory Computing (Row Store, Column Store, Persistency Layer,
Architectural Concept)

HANA based Real-time Operational Analytics
HANA based Agile Data Marts for Rapid Prototyping with Analytic Models
New Modelling Paradigm in order to provide agility and flexibility from business
question to report.

HANA-optimized Data Store Object and Info Cube

HANA-Optimized DataStore Object
HANA-Optimized Info Cube
Semantically Partitioned Object

ERP/SAP HANA modelling

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

MODELLING of ERP/SAP BW 7.4 with ERP/SAP HANA

Models in ERP/SAP BW 7.4
Data Extraction and Data Flow within ERP/SAP BW 7.4 NW 2004S
New Data source Concept of BW 7.4
Transformation in BW 7.4(ETL) DTP (Data Transfer Process)
FROM 3.X TO BW 7.4
Business Content UPGRADING DATAFLOWS
Administration of InfoCubes and Aggregates
DSO (DATA STORE OBJECTS)
Virtual Cubes and Multi Providers

Consuming HANA Models in BW

Virtual Provider
Transient Provider
Composite Provider
DB Connect
Importing ERP/SAP BW models in ERP/SAP HANA
Importing HANA optimize info cubes
Importing HANA optimize DSO

G) DATA EXTRACTIONS (ETL)

1)ECC Extractions Using BI BW 7.4 Dataflow

Overview of ECC6.0 Extractions.
Generic Extractions
Business Content Extractions
CO-PA Extractions (COST PROFITABLE ANALYSIS)
LO-COCK PIT Extractions (LOGISTICS)
FI-SL Extractions (Financial special purpose ledger)

2)ERP/SAP CRM Extractions

Delta Management
Extracting Master Data from CC (Attributes, Text, Hierarchies)
Data source Enhancement
Process Chains in Detail covering all process Types
Upgrading process Chains from 3.x to BW 7.4
APDS (Analysis Process Designers)
New Enhancement of ERP/SAP BW 7.3,7.4

H) REPORTING

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

Transporting Objects (CTO)

New Enhancements of ERP/SAP BW 7.4

Hybrid provider
New monitors in BW Administration cockpit
Generic delta functionalities for further types of Data Sources
Hierarchies
Data Transfer Process (DTP)
Open Hub Service
Transformation
ERP/SAP BODS (New ETL Tool of ERP/SAP) Integration ERP/SAP hands on practice and mini
-project

Hands on practice with real life examples
Mini–project