India +91 9030088524/5/6
USA +1 7197996528
Online Payment
ExpertSoft Facebook
ExpertSoft Twitter
ExpertSoft LinkedIn
ExpertSoft Google+
SAP Techno Functional
Leading SAP online training provider, SAP training tutorials and SAP training materials that explains step by step
with real time experts and projects.

SAP Techno Functional

SAP BI/BW(Business Information Warehouse)CONTENT

SAP Business Information Warehouse (SAP BW) is the name of the Business Intelligence, analytical, reporting and Data Warehousing (DW) solution which is one of the major enterprise software applications produced by SAP AG. It was originally named SAP BIW, (Business Information Warehouse), but is now known as "SAP NetWeaver BI". For the modern enterprise, time wasted due to data loss and inconsistencies is unacceptable,particularly when this can often be remedied easily through the use of a data warehouse. SAP introduced Business Warehouse Information Systems (BW) in the first half of 1997. This system approach consolidates the external and the internal sources of data into a single repository and provides preconfigured data that aids the organizations and enterprises in dealing with the data management and archiving. The SAP environment therefore expanded its horizon with the introduction and implementation of SAP BW to encompass new applications for the SAP R/3 administrators responsible for administering and maintenance of these data reserves.

Overview and Concepts

  1. Over view of SAP R/3
  2. Necessity of SAP BW
  3. Versions of SAP BW
  4. Over view of SAP BW
  5. OLAP and OLTP
  6. Data Ware Housing Concepts
  7. Landscape of SAP BW
  8. Homogeneous + Heterogeneous
  9. Integration of BW system with different systems
  10. ERM  + MDM + Star Schema
  11. Extended Star Schema

Architecture of SAP BW
Objects in SAP BW

  1. Info Area + Info Objects  Catalogs
  2. Characteristics
  3. Key Figures-Cumulative and Non Cumulative
  4. PSA + Transfer Structure/Data Source
  5. Transfer Rules
  6. Info Sources/Communication Structure
  7. ODS + Info Cubes
  8. Types  of  Info Cubes + Update Rules

Data  loading using flat files

  1. Master data + Attributes data
  2. Texts data + Hierarchies’ data
  3. Transactions data + Delta data loading

Data filtration techniques

  1. Transfer rules level
  2. Update rules level
  3. Start routines

SAP BI  7.0
Business Intelligence Concepts and Overview
Modeling: Data warehousing workbench

  1. Components of  Data Warehousing workbench
  2. InfoObjects + DataSources
  3. Types of DSOs + DataSources Repository
  4. Migration of 3.*DataSources and recovery of 3.*


  1. Differences between ODS(Operational Data Store) and DSO
  2. Data Loading: Master Data
  3. Attributes Data Loading using flat files in BI 7.0
  4. Texts Data Loading using flat files in BI 7.0
  5. Hierarchies Data Loading in 3.*
  6. Concepts on Transformations
  7. Controlling the Data flow with Info Packages

and Data Transfer Process(DTPs)

  1. Data flow concepts in SAP BI 7.0
  2. Transactions Data Loading in BI 7.0
  3. Flat files data loading to Info Cubes
  4. Flat files data loading to DSO
  5. Delta loading to Info Cube Via DSO


  1. Standard + Direct
  2. Write Optimized


  1. Creating Transformations
  2. Types of Transformations

Routines at Transactions

  1. Field Level Routines  + Start Routines
  2. End Routines + Expert Routines

BEx Query Desinger

  1. Introduction to BEx Query designer
  2. Filters in the query
  3. Characteristic Restrictions
  4. Rows and Columns
  5. Free Characteristics
  6. Formulas –Calculated KeyFigures
  7. New Selection-Restricted KeyFigures
  8. Structure + Hierarchies
  9. Attributes + Navigational Attributes
  10. Variables + Text Variables
  11. Characteristics Variables
  12. Different Types of Variables
  13. Conditions + Exceptions
  14. Cell Definitions
  15. Report to Report Interface(RRI)
  16. How to use replacement path and customer exit


  1. Customer exit Programs
  2. Properties of the Components

Web Application Desingner

  1. Creating Web Template
  2. Web Items
  3. Properties of  Web Template
  4. Table + Text Elements
  5. Generic Navigation Block
  6. Drop down boxes
  7. Radio Buttons and Check boxes
  8. Filters + List of  Exceptions
  9. Conditions + Integrating with the charts
  10. Ad-hoc Query designer

Business Explorer Analyzer

  1. Introduction to BEx Analyzer
  2. Filters in BEx Analyzer
  3. Drag and Drop Function
  4. Various functions used in Analyzer
  5. Creating New Workbook

Demo project
Types of Project

  1. Project Preparation + Blue print phase
  2. Requirements Gathering
  3. Functional Spec design
  4. Technical Spec Design
  5. AS IS Process
  6. Unit testing
  7. Integration Testing
  8. Final preparation
  9. Cutover activities

Up-gradation Project

  1. Up-gradation check list
  2. Activities to be performed during up-gradation

Enhancement to the existing Implementation

  1. Activities in enhancement to existing

Implementation project
Support Project

  1. Various support activities
  2. Handling Tickets
  3. Support issues/errors
  4. Resolving support issues

Advanced Topics in BI 7.0

  1. Modeling/Remodeling
  2. Partitioning/Repartitioning
  3. Data Mart
  4. Open Hub Destinations
  5. SAP-BO
Student Say
I suggest ExpertSoft institute for all the students who are interested to learn SAP any module. I have attended SAP CRM Technical Training. The tutor is very good in knowledge transfer and also we have 24 hours lab facility. The tutors and all staff are user friendly, very responsive and they clarified all my doubts. They are providing mock interviews.
- Swathi Prakash

I am Ramesh from Bangalore. I have taken SAP ABAP online training from ExpertSoft. The course content is very well structured and well explained with connection with real time which is helped me to learn quickly.
Thank you for all the support. -