SAP BW

Overview

Business Warehouse, earlier known as Business Information Warehouse is a comprehensive and packaged Business Intelligence product optimized for SAP R/3 environment around a data warehouse. BW delivers Reporting, Analysis and Interpretation of business data to optimize and enable the organizations to meet the necessity and to take crucial business decisions. SAP BW enables OLAP (Online Analytical Processing) for analyzing the information from huge amount of historical and operative data.

What will you learn?

·       Learn about InfoObject and InfoCube in SAP

·       Data store objects functionality

·       Learn LO-Cockpit description and Data Sources

·       Business Explorer web application and query

·       Using BEx Analyzer for Restrictions and Exceptions

 Pre-requisites for SAP BW Online Training:

§  Basic Knowledge of SQL, Data Warehousing and data integration concepts.

§  Any Graduate can do this Course, preferably BE/B tech/MCA/BCA.

§  Awareness on Any Programming Skill (e.g. : PHP, java etc) will be an added advantage.

§  Anyone can pursue this Course from End user to the Management Level.

Who is it targeted to?

·       Data Warehousing professionals

·       SAP Technical & OLAP Consultants

·       Software Analysts and Mainframe professionals

·       Project Managers and Business Objects Professionals

·       Those aspiring for a career in SAP BW

COURSE CONTENT

Introduction (1 Hr.)

• Introduction to ERP, SAP, Data Warehouse
• Overview of BW, BI, Data Base.
• Overview of BW Architecture, Landscape

Basic Modeling (2 hr.)

• Multi-Dimensional Star Schema (Classical Approach)
• Multi-Dimensional Star Schema in BW (Extended star Schema)
• The OLAP Concept and differences between OLAP and OLTP

Business Modeling (20 Hr.)

• Info Area
• Info Object Catalogs
• Info Objects
• PSA
• Application Component
• Info Source
• Data Source
• Transfer Rules
• Update Rules
• Transfer Structure
• Communication Structure
• Info Package
• Transformation
• Data Transfer Process
• Loading Transactional Data into BW info Cube
• Loading MD with TD into BW System
• BW and BI Comparisons
• Master data loading-new (BI) ETL process
• Info cube & Types
• Standard Info cube and Loading with new ETL Process
• Generate Report with BI master and Transaction Data
• Manual Uploading of MD like Attributes, Text, and Hierarchy
• Different Types of Attributes
• Transformations, Rule types

Routines (2 Hr.)

• Start Routine
• End Routine
• Expert Routine

DTP (Data Transfer Process) (1 Hr.)

• Standard DTP
• Error DTP
• Direct Access DTP
• Real time DTP

DSO (Data Store Object) (1 Hr.)

• Standard DSO
• Write optimized DSO
• Direct update DSO
• APD (Analysis Process & Design)

Update Methods (1 Hr.)

• Full updates
• Initialization
• Delta Updates

Info Providers (5 Hr.)

• Multi Providers
• Info set
• Virtual Providers
• Re-Modeling
• Re-Partitioning
• Open-Hub Destination
• Data Marts

Info Cube Maintenance (2 Hr.)

• Aggregates
• Roll-up
• Compression
• Reconstruction

Process Management (2 Hr.)

• Process Chains, Process Types
• Scheduling
• Monitor (Header, Status, Details)

Reporting (15Hrs)

• Business Explorer
• BEX Query designer
• BEX Analyzer
• BEX WAD
• BEX Report Designer

Functional Overview of Bex Query Designer

Reusable Query Elements

• Query Controls with Variables
• Calculated Key Figures
• Restricted Key Figures
• Formulae
• Structures

Variable Definition in Detail

• Characteristic values variables
• Text Variables
• Formula Variables
• Hierarchy Variable
• Hierarchy Node Variable…

Process Types

Manual input

Customer exit

Replacement path

SAP Exit

Authorization

• Analysis Functions
• Conditions
• Exceptions
• Reporting Drilldown
• Drilldown to DSO from Info Cube (RRI)
• Copying Queries from Cubes
• Bex Analyzer
• Bex WAD
• Bex Report Designer
• Migration Objects from BW 3.x to BI 7.0
• Transportation
• Extraction
• Generic Data Extraction using MD/TD Tables
• COPA Extraction
• Business Content Extractions using MD/TD
• LO-COCKPIT Data Extraction
• Delta types for
• Generic Extraction
• LO Extraction
• ASAP methodology