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: 45-50 hrs
Mode of Training: Live Instructor-led hands on Training
Course Contents
- Data Ware Housing Concepts
- E-R MODEL/ MDM MODEL
- 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
- 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
- Resume Preparation Guidelines and Tips
- Mock Interviews and Interview Preparation Tips
- Certification Guidance
- Mini Project
- SAP BIBO COURSE ROAD MAP
Course Assignments
News forum
SAP BIBO Course Road Map
SAP BIBO COUSRE ROAD MAP
