SAP NetWeaver BW 7.3



Course Description

SAP Business Information Warehouse (SAP BW) is the name of the Business Intelligence, analytical, reporting and Data Warehousing (DWH) solution which is one of the major enterprise software applications produced by SAP AG.

BW consists among other things of components for data management (Data Warehousing Workbench), extensive data modeling capabilities, an embedded analytical engine, a suite of rich front-end analytical tools referred to as Business Explorer (BEx), and operational tools used for importing the most current transactional data into the system. It may be helpful to consider three layers that make up the structure of SAP’s BI solution.

Extraction, Transformation and Load (ETL) layer – responsible for extracting data from a specific source, applying transformation rules, and loading it into SAP BW system.
Data warehouse area – responsible for storing the information in a various types of structures, including multidimensional structures called Info Cubes.Reporting – responsible for accessing the information in data warehouse area and presenting it in a user-friendly manner to the analyst or business user.

 SAP’s BI is a very pervasively employed data warehouse / analytical enterprise software solution, often utilized heavily by companies that essentially run their business on SAP operational systems such as SAP Enterprise Resource Planning (SAP ERP, traditionally known as SAP R/3).SAP’s BI solution contains a large number of predefined extractors, a very significant amount of pre-defined business content in the form of Info Cubes, master data (i.e. objects representing the entity for Customer or Material), authorization roles, query views and reports all delivered in the software by SAP.

Some of the significant benefits of this approach include the ability to leverage   SAP’s substantial business knowledge from many years of developing  extremely sophisticated software systems for the world’s largest companies typically shortening project development cycles in the process.

The pre-defined business content can be modified to meet an organization’s specific requirements, while at the same time taking advantage of general aspects of these delivered data models and reports that are somewhat foundational and have broad application in business, government, and education.

Course Duration: 30-35 hrs

Mode of Training: Live Instructor-led hands on Training

Course Contents

  • Data Ware Housing Concepts
  • Over view of SAP R/3 Types of Applications
  • OLTP  v OLAP
  • R/3 Architectures
  • Landscape of SAP
  • ASAP Methodology

Unit 1: The Multi-dimensional Model  in SAP BI

  • Overview of Star Schema
  • The SAP BW  Extended Star Schema Concept
  • Data Warehousing Workbench (DWB)
  • Info Area
  • Info Object Catalog
  • InfoObjects Characteristics and Key Figures
  • Info cubes

Unit 2: Data Extraction and Dataflow within SAP BI 7.X

  • Overview of BI 7.3 Data Flows
  • 3.x Dataflow concept
  • Loading Master Data (Text, Attributes, Hierarchies)
  • Loading Transaction Data

Unit 3: Data Source concept in BI 7.3

  • Overview of Source Systems SAP and NON-SAP
  • Overview of New data Source
  • PSA (Persistent Staging Area)
  • Emulation of Data source in BI 7.3
  • Data Source Lifecycle with in SAP  BI 7.3
  • Info Package
  • Migration of 3.x data Source to BI 7.X Data Source

Unit 4: Transformation in BI 7.X (ETL)

  • In depth Coverage of Transformation
  • Routines in Transformations ( Start Routine , End Routine, Expert Routine, Transformation routine) with several real time examples
  • Transformation Groups
  • Unit and Currency Conversions

Unit 5 : DTP (Data Transfer Process)

  • Overview of DTP
  • Error DTP
  • Trouble shooting techniques in DTP
  • Debugging  Transformation routines using DTP

Unit 6: Business Contents (BCT)

  • BCT Overview
  • Activation of BCT
  • Enhancement of BCT

Unit 7: Administration of InfoCubes and Aggregates

  • Managing of Basic Cubes
  • Aggregates, Rollups

Unit 8: DSO (Data Store Objects )

  • Data store Object Concept
  • Types of DSOs (Standard, Write Optimized, Direct DSO)
  • Role of DSO in Staging

Unit 1: Overview of ECC6.0 Extractions

  • Types of ECC Extractions

Unit 2: Generic Extraction

  • Database Tables/Views
  • Infoset Queries
  • Function Module

Unit 3: Business Content Extractions

  • Overview of Business Content Extractions
  • Example from Financial, Logistics, HRMS Modules

Unit 4: CO-PA Extractions (Cost Profitable Analysis)

Unit 5: LO Extractions (Logistics)

  • Overview of LO COCKPIT
  • Examples from Sales and Distribution (SD), Material Management (MM)

SAP CRM Extractions:

  • Marketing Extractions
  • CRM Sales Extractions
  • CRM SERVICE Extractions

Unit 6: Delta Management

  • Delta Management for SAP Source Systems
  • Delta Management for NON-SAP Source Systems

Unit 7: Master Data Extractions (Attributes, Text, Hirarchies)

Unit 8: Datasource Enhancements

  • Append Structure
  • CMOD
  • ABAP Coding to populate the added fields
  • Testing of ABAP Code through RSA3
  • Overview of Process Chain
  • Local Chain, Meta Chain
  • Designing a process chain
  • Scheduling a process Chain
  • Monitoring Process Chain
  • Real time Example of Meta Chain

Unit 1:  Introduction to BI Enterprise Reporting

  • Business Explorer (BEX) in detail
  • Business Object Reporting  Overview

Unit 2: Bex Query Designer

  • Overview of Query Designer
  • Info providers in query designer
  • Filters in query (local & Global)
  • Restricted Key figures
  • Calculated Key Figures
  • Properties of Key Figures
  • Structures and Cells
  • Properties and Attributes of Characteristics
  • Types of Variable
  • Processing Types of Variables
  • Exceptions and Conditions
  • Sample Queries from FI,SD AND MM

Unit 1: RRI (Report Report Interface)

Unit 2: Bex Analyzer

Unit 3: Bex Web Analyzer

Unit 4: Overview of Information Broadcaster

  • Overview of Enterpirise Portal
  • Publishing Reports

Unit 5: Web Reporting Using Web Application Designer(WAD)

  • In depth of web Reporting using New Web Application Designer
  • Detail Coverage of Dash Board Reports

Unit 6: Performance Tuning Techniques in depth

  • Data Model for Performance
  • Line Item Dimensions
  • Navigational attributes
  • BW Statistics: Query Analysis Tools
  • Compression
  • Partitioning
  • Aggregates: Creating Aggregates, Finding effective aggregates

  1. Resume Preparation Guidelines and Tips
  2. Mock Interviews and Interview Preparation Tips
  3. Certification Guidance
  4. Mini Project


int(9) int(0) array(3) { ["status"]=> bool(false) ["debug"]=> string(27) "{"course_id":9,"user_id":0}" ["warnings"]=> array(0) { } }

Course Assignments

News forum

SAP BIBO Course Road Map


Comments are closed.