SAP Business IntelligenceAll parts of the course have lectures, system demonstrations on all topics, customizing settings and hands on exercises for participants. At the end of the training there would be 2 sets of examination for preparing the participants for SAP BW Certification. We are confident that with our inputs and the active and dedicated learning hours put in by the participants, the exam would be a formality. The questions are from actual SAP BW certification examinations conducted by SAP.
Part I: Basics of Business Warehousing
This part of the course gives a complete understanding of how SAP BW works, how data is brought into SAP BW from R 3 and Flat files and the organization of different components of SAP BW. It lays a firm foundation for anyone to start off on a SAP BW assignment and enforce their learning further on the job through largely self learning
Basics of Data warehousing and Multi-Dimensional Modeling
SAP SAP BW and its Components, Plug In For R/3
Setting Up The SAP R 3 and SAP BW Link -Customizing settings on SAP BW
- SAP BW Business Content
- Implementing Business Content in SAP BW-Customizing
- Extracting Business Content Based Data From R 3
- Data Source and Transfer Structures
- Data Source Replication
- Setting Up The Source Systems
- Info Objects, types, standard and custom info objects
- Master Data Info objects
- Extracting Business Content Master Data from R 3
- Flat File Extractors For Master Data
- Creating Info sources for master data
- Data sources, types and mapping the Data Source and Info source.
- Creating Transfer Structures and communication Structures
- Transfer rules for data transformation and options offered by SAP.
- Info package Creation and Data Loading to PSA etc
Data Flow
- Transaction Data and Data Targets ODS and Info cubes
- Multi-Dimensional Modeling and Info cubes
- Star Schema and Extended Star Schema
- Designing the Cubes
- Extractors For Flat File Transaction Data
- Creating Info sources for Transaction Data
- Data sources and mapping the Data Source and Info source.
- Creating Transfer Structures
- Transfer rules for data transformation and options offered by SAP
- Info package Creation and Data Loading to PSA
- Update Rules and Options for Data Loading in Data Targets
- Data Loading into Data Targets
- Business Content Extractors For R 3 Transaction Data
- Creating Info sources for Transaction Data
- Data sources and mapping the Data Source and Info source.
- Creating Transfer Structures
- Transfer rules for data transformation and options offered by SAP
- Info package Creation and Data Loading to PSA
Part II: Data Extraction into Business Warehousing From SAP R 3 and Flat File Systems
This part of the course gives an in depth knowledge, understanding of how SAP BW extraction works, various ways and means of bringing in data SAP BW from R 3 and Flat files. This module transfers experience and knowledge of real time SAP BW experience which could take anyone at least six months to a year on-the-job experience to gather a similar level knowledge and gain expertise. This course makes a ready to deploy SAP BW Consultant out of participants in any major functional area of SAP R/3. It covers all functional areas from R 3 except for HR.
- Delta Loading
- Extraction from R/3
- Delta Extraction
- Logistics Extraction Using LIS Structures (SD, MM, PP etc.)
- Logistics Extraction Using LO Cockpit (SD, MM, PP etc.)
- FI Extraction
- CO-PA Extraction
- CO Extraction
- SPL Extraction
- R 3 Custom Tables Extraction
- Data Loading Administration on SAP BW and Customizing
- Sequencing of Data Load – Tips and Tricks
- Extractor checking, Data Loading and Monitoring Tools
- Performance Bottle Necks in R 3 and SAP BW, ways and means to improve performance
- Info package Groups
- Statistics on SAP BW
- Data Compression
- Indices and Partitioning
- Enhancing Extractors
- Sizing in SAP BW
- Special Topic: CTS
- Special Topic: ETL Tools and SAP BW
- Special Topic: Remote Cubes
- Special Topic: Using DB Connect For Data Loading in SAP BW
- Special Topic: New Extraction Features in SAP BW 30B
- Special Topic: Problems in upgrades and solutions
Part III. Reporting- The Purpose of SAP BW
This part of the course gives an overview knowledge, understanding of how reports are built, how query creation is dependent on ODs and Info cube Design, Queries on Multi-Cubes. This curriculam provides knowledge of real time SAP BW experience which would take anyone at least six months to gain the same expertise. This course makes a ready to deploy SAP BW Front End Development Consultant out of participants in any area of SAP R/3.
- Reporting in SAP BW using Bex Analyzer, Bex Browser
- Settings on Info objects, Data Targets for queries
- Queries
- Calculations and Formula Builder
- Different Types Of Key Figures
- Filters
- Conditions
- Variables
- Creation Of Variables
- Drilling Down
- Settings For Queries
- Multiple Queries
- Workbooks
- Workbook Templates
- Formatting, Graphs and Charts in Queries
- Geo-Coding
- Complex Queries
- Query Performance and Tools
- Bex Browser
- BDS - Business Document Store
- Queries and Workbooks in Bex Browser
- Third Party OLAP Tools and SAP BW
- Special Topic: R 3 Reports Through SAP BW
- Special Topics: Web reporting in ITS
- Special Topic: SAP BW 30B and the new Web Query Builder
4 Weeks
Click here to Enroll
Recommended Reading
Authors: Biao Fu , Henry Fu
Released: 23 July, 2002
ISBN: 0201703661
Author: Naeem Hashmi
Released: September 2000
ISBN: 0761523359
Naeem Hashmi, Founder and CTO for Information Frameworks, is a thought leader, author, speaker, and an expert on emerging e-business intelligence and integration technologies. Naeem has been a catalyst in defining technical architecture of several BI products including SAP SAP BW. Naeem authored the best selling book Business Information Warehouse for SAP. He is a member of Intelligent ERP magazine's board of editors, Business Intelligence Expert at searchSAP.com, and is a frequent speaker at IT industry conferences. He can be reached at nhashmi@infoframeworks.com
Author: Catherine Roze
Released: October, 2002
ISBN: 0761523359
The SAP Business Information Warehouse (SAP SAP BW) is the data warehousing solution developed by SAP AG for SAP-centric data warehouses. Professionals seeking to become SAP SAP BW application consultants need to pass the SAP SAP BW certification exam in order to prove that they have a fundamental knowledge of this particular area of the SAP system, as well as to demonstrate that they are able to apply this knowledge within a project environment. SAP SAP BW Certification: A Business Information Warehouse Study Guide provides candidates with the training and information they need in order to achieve certification.
