| The Objective of this course is to have 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 curriculum provides knowledge of real time BW experience which would take anyone at least six months to gain the same expertise. |
| |
| Target Audience |
| |
| This course is intended for Professionals seeking to become SAP BW application consultants. They need to pass the 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. |
| |
| Course Topic: |
| |
| Introduction to ERP |
| |
| Data Warehouse Architecture
| |
| Business Warehouse |
| Architecture | |
| |
|
| |
| Reporting |
| |
| Info providers and Info objects
| |
| Business Content |
| Business Explorer | |
| The Bex Browser |
| Bex Query Designer | | | |
|
| |
| Bex Map |
| |
| Query Designer | |
| Analysis and Reporting in the Bex Analyzer |
| Calculated and Restricted key Figures | |
| Hierarchies |
| Query Properties | |
| Exceptions and Conditions |
| Report / Report Interface | |
| Reporting Agent - the follow-up actions |
| Bex Web Application Designer | |
| Web Items - Properties |
|
| |
| Introduction to Data Modelling |
| |
| Dimension Modelling
| |
| Star Schema |
| Structure of Dimension tables | |
| Info Objects |
| Characteristics / Attributes | |
| Navigation Attributes |
| Status Attributes | |
| Types of Info Providers |
| Multi Providers | |
| Data Targets |
|
| |
| Ware House Management |
| |
| Administrator Workbench Functions
| |
| Scheduler |
| Monitor Source Systems | |
| Source Systems |
| Info Objects | |
| Text, Attributes, Hierarchies |
| Compounded Info Objects | |
| Data Flow in BW |
| Transfer Rules | |
| Update Rules |
| Business Content Activation | |
| Storing Data in BW |
| Data Targets | |
| Types |
| Architecture | |
| Data Target - Administration |
| Aggregate Maintenance | |
| Metadata Manager |
|
| |
| Data Extraction |
| |
| Data Flow
| |
| Extraction from SAP source Systems |
| Non SAP source Systems | |
| Transfer Methods (PSA Idoc) |
| Data Sources | |
| Extraction from CO-PA |
| Creating a Data source | |
| Data Extraction Logistics |
| LO Cockpit Functions | |
| LO Data sources Dataflow in R/3 |
| Structure of Delta method for LO cockpit Data source | |
| Connecting LIS Info Structures to SAP BW |
| Delta Method | |
| Delta Queue Functions |
| Enhancing Business Content | |
| Extraction with Flat Files |
| Extracting Transaction and Master Data using Flat Files | |
| DB Connect |
| Data Mart Interface | | | |
|
| |
| Performance Tuning |
| |
| Line item Dimension | |
| Data Partitioning |
| Data Archiving | |
| Authorizations |
| Process Chains | |
| Open Hub Service |
| Currency Conversion | |
| |
|
| |
