SAP Business Warehouse (BW) is part of the overall SAP NetWeaver platform. In the overall SAP NetWeaver documentation prior to SAP NetWeaver 7.4, BW is referred to as SAP NetWeaver Business Warehouse, key capability Business Intelligence, by its corresponding IT scenarios Business Planning and Analytical Services, Enterprise Reporting, Query, and Analysis, Enterprise Data Warehousing or by its use case Data Warehousing.

• Training by Realtime Expert trainer
• Live Online Classes
• Free study material
• Online virtual Classes available in morning, evening and weekend

Prerequisties

• All attendees should have a basic knowledge of data warehousing concepts.

Duration

Online

• The format is 40% theory, 60% Hands-on.
• It is a 20 days program and extends up to 2hrs each.

Corporate

• The format is 40% theory, 60% Hands-on.
• It is a 5 days program and extends up to 8hrs each.

Classroom

• Private Classroom arrenged on request and minimum attendies for batch is 4.

Course Content

Overview & Concepts

• Overview of SAP R/3
• Necessity of SAP BW & Version of BW
• OLAP & OLTP
• Data Ware Housing Concepts
• Landscape of SAP BW
• Integration of BW system with different systems
• ERM, MDM, Star Schema & Extended Star Schema.

Objects in SAP BW

• Info Area, Info Object Catalogs
• Characteristics
• Key Figures-Cumulative & Non Cumulative
• PSA- Transfer Structure/Data sources
• Transfer Rules
• Info Source/Communication Structure
• ODS- Info Cubes
• Types of Info Cubes- Update Rules

Data Loading Using Flat Files

• Master Data – Attributes, Texts, Hierarchies
• Transaction data-Delta data loading

Data Filtration Techniques

• Transfer Rules level
• Update Rules level
• Start Routines

PSA-Maintenance scheduling the data

• Data Packet by Packet
• Complete scheduling
• Scheduling in background
• Transfer Rules & Update Rules
• PSA-Processing Types
• Monitoring & scheduling data loading
• Scheduling the jobs on periodic values
• Cancellation & Deleting the back ground jobs