Share this link via
Or copy link
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.
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
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