SAP BPC - BI/BW Training

COURSE DETAILS & CURRICULUM

BPC COURSE DETAILS & CURRICULUM

1 Overview of Enterprise Performance Management

1.1 EPM Solutions and the Software tools

1.2 Introduction to Concepts in Planning, Budgeting, Forecasting and Consolidation

1.3 Introduction to Scenario Based Planing

 

2 Overview of SAP Business Planning and Consolidation

2.1 SAP BPC: Business User-Owned and managed

2.2 Unified Planning and Consolidation

2.3 SAP BPC for Netweaver Architecture

2.4 Introduction to SAP Netweaver BW Objects

2.5 Introduction to SAP BPC Objects

 

3 Designing a Model with SAP BPC

3.1 Case Study

3.2 Designing the Data Model in SAP Netweaver BW

3.3 Building the Model in SAP BPC

3.3.1 Environment Management

3.3.2 Dimension Management

3.3.3 Designing Models

3.3.4 Designing Security Model

3.4 Consulting Issues

 

4 Loading, Scheduling and Managing Data in SAP BPC

4.1 Loading Data from Source system to cube in SAP Netweaver BW

4.2 Loading Data from SAP Netwearver BW to SAP BPC

4.2.1 Creation of Transformation and Conversion File

4.2.2 Data Manager packages

4.2.3 Process Chains

4.2.4 Loading Master data from flat file into a dimension

4.2.5 Loading Master data from InfoObject into a dimension

4.2.6 Loading Hierarchy from an InfoObject into BPC dimension

4.2.7 Loading transaction Data from an Infocube into SAP BPC Model

4.2.8 Copying Data inside BPC Model

Consulting Issues

 

5 Reporting, Planning and Analysis in SAP BPC

5.1 Reporting and Analysis in SAP BPC

5.1.1 Introduction to SAP EPM Add-In interface for Excel

5.1.2 Creating Reports

5.1.3 Developing reports using dynamic templates

5.1.4 Developing reports using EPM Functions

5.1.5 Developing reports using EPM RetrieveData Functions

5.1.6 Develping Rolling Forecast reprot

 

 

SAP BUSINESS INTELLIGENCE SUITE COURSE DETAILS & CURRICULUM

1. SAP Introduction: 

• History of SAP
• Evolution of ERP
• ERP Packages
• SAP R/3 System – ERP Backbone
• SAP R/3 Modules – SD, MM, FI
• Types of all other ERP Packages in Market
• Advantages of SAP ERP Compared to other ERP Packages
• SAP R/3 (or) ECC Reporting
• Limitations of SAP R/3 (or) ECC Reporting.

 

2. SAP Case Study:

 

3. SAP Data warehousing: 

• Introduction to Data warehousing
• Fundamentals of Data warehouse
• Definition of Data Warehousing
• Key functions of Data Warehousing
• Applications & Types of SAP
• Difference between OLTP vs OLAP
• Types of Data in SAP
• Multi Dimensional Modelling
• Star Schema and Extended Star Schema

 

4. SAP BW/BI Introduction:

• Introduction to SAP BW/BI
• History of SAP BW/BI
• Necessity of SAP BW/BI

 

5. SAP BW/BI Architecture: 

• Source System & Target System
• Source system connections
• Data Modelling, Extraction & Loading
• Data Reporting

 

6. SAP BW Data Modelling: 

oData Warehousing Workbench

oInfo Obects & Types of Info Objects

oInfo Area4. Info Object Catalog

• Application Component6. Activation of Business Content
• Master data & Transaction data
• Data Source, Info Source
• Data transfer methods for SAP Systems (PSA and IDOC)
• Info cube
• DSO/ODS
• Info Set
• Info Provider
• Multi Provider
• Transformation
• Routi
• DTP
• Info Package
• Open Hub Destination
• Transfer Rules
• Update Rules
• Authorisations
• Roles

 

7. SAP BW Data Extraction: 

• Application Specific Extractors(BW Content Extractors & Customer Generated Extractors)
• Cross Application Specific Extractors ( Generic Extractors)
• LIS Extrction
• LO Extraction
• COPA Extraction
• Data Extraction using other tools
• BW Data Source Enhancement
• SAP BW Data Loading & Scheduling – 3 Hours
• Introduction to Process Chains
• Process Chains in SAP BW/BI
• Types of Views in Process Chains
• Process Chain Creation
• Process Chain Monitoring

 

8. BW Data Reporting: 

• Bex Query Designer
• Bex Analyzer
• Bex WAD
• Restricted & Calculated Key figure
• Filters
• Rows & Columns
• Free & Filter Characteristics
• Types of Variables
• Conditions & Exceptions

 

9. SAP BW Real Time/Project Scenarios: 

• Production Support Issues
• Implementation Project Issues
• Migration/Up gradation Project Issues
• Tickets Handling
• Batch Jobs Monitoring
• Ticketing Tool Tracker.
• SAP BW Clients & Projects Discussions:
• Importance of SAP BW Projects in Market
• Type of Domain Industries & Clients using SAP BW/BI

 

10. SAP BW Data Transportation: 

• System Landscape
• Transportation Landscape
• Overview of Transports
• Objects Collection in Transports
• Sequence of Transports Migration
• Transports Collection & Setting
• Transport Issues

 

11. SAP BW Performance Tuning Techniques: 

• Aggregates
• Partitioning
• Compressions
• PSA Tabe Deletions
• BI Accelerators

 

12. SAP Knowledge Sharing Sessions: 

• SAP OSS Notes
• SAP Marketplace
• SAP Developer Forum

• SAP Issues Forum