SAP BI/BO Curriculum
�� Introduction to SAP R/3 and ERP
�� SAP Overview
�� R/3 Foundation & Architecture
�� Business transactions and Objects
�� Business Scenarios
�� OLTP v/s OLAP
�� What is SAP BI/BW
�� Decision Support v/s Operational Reporting
�� SAP Business Information Warehouse
�� Evolution of SAP BI/BW
�� Data Models
�� Difference between data model in OLTP and BI/BW
�� The SAP BI/BW Extended Star Schema Concept
�� SAP BW Terminology
�� DWB (Data warehousing Workbench)
�� Extract structure
�� Transfer rules
�� Update rules
�� DTP (Data Transfer Process)
�� Data targets
�� Master data (Attributes, Texts, Hierarchies),
�� Data Flow
�� Data flow from SAP R3 Source system
�� Non SAP Source Systems
�� Create InfoOjects (Characteristics and Key figures), Loading Master Data
�� Infocube: How to create an Infocube. Various steps
�� Transformation: How to create a Transformation with reference to the data
�� Update rules: Creating Update rules and formulas in a Transformation.
�� Persistent Staging Area: Structure, Data in PSA
�� Load Transaction data using flat file
�� Data Store Object (DSO): Structure of DSO, Functions of ODS, Delta
�� Types of Update: Additive, Overwrite
�� Data flow to DSO: Create DSO, Create Transformation
�� Differences between update to cube and DSO (Overwrite option available,
Change log maintained)
�� Data Warehousing WorkBench (DWB)
�� Functions of DWB.
�� Transport Connection: What is transport, Creating Transport using “Transport
Connection”, alternate methods
�� Business Content: Activating business content, Options for activation, How to
activate at the start of a project, how to activate after implementation phase.
�� Activate business content in SD, MM and FI areas.
�� Technical content and BW Statistics: What is BW Statistics, Why activate.
�� Overview Metadata Repository: What is Meta data, What does Metadata
�� Extraction from SAP R/3 System
�� LO Cockpit: What is LO Cockpit, Delta management in LO Cockpit, Job control
�� Update modes (Unserialized V3 Update, Direct Delta, Queued Delta)
�� Where to view the update Queue (SM13 and LBWQ)
�� Modification of standard extractors
�� Extract structure modification - Adding fields, adding fields in “Append
�� Generic Datasources: Create generic datasource using, view, Infoset,
�� Extraction from CO-PA and FI-SL: Where to set up the extractors.
�� Add a field to a Master Data object by adding available field
�� Add a field not available by append Structure
�� Code in the exit
�� Extraction from Non SAP Sources:
�� XML Integration: How to create XML Data Source, Create XML Data Source
�� DB Connect: Concepts.
�� Loading Transaction data and Master data using Flat Files.
�� Data Mart Interface
�� Extraction within BW System (ODS to Cube update, Cube to Cube update)
�� Generating Export Datasource for ODS objects, Cubes and Master Data objects.
�� Virtual cubes and Multi providers, Infosets.
�� Performance Tuning
�� Managing Infocubes
�� Production Support
�� Job monitoring
�� Process chains, Event chains, Creating and triggering events, Common problems,
how to fix problems.
�� SAP BW Presentation Layer
�� Queries: BEx analyzer, Query builder, Queries in standard Excel interface,
Functions in queries, Formulas, Calculated and Restricted Key Figures, Tabular
�� Business Objects and BW integration:
�� Universe creation
�� Xcelcius Dashboard: Create a sample dashboard with dynamic charts and dials
including a What-If scenario
�� Crystal and WEBI queries with SAP BW
�� Best practices of BW-BOBJ integration
�� Q&A on all topics covered and any Ad-hoc questions
�� Project Methodology and Certification Discussion
�� Real time Business Scenarios
�� Real time Business Process Procedure
�� Best Practices
�� Certification and Industry Discussion