SAP BI/BW

SAP Netweaver2004s overview

• Overview of Different Software Components in Netweaver.
• Overview of Business Intelligence. And Glance of all the New Features.

Enterprise Data Warehousing – Data Modeling

• Info Objects
• Data store objects (all three types).
• Infocubes and Virtual Providers
• Multiproviders and Infosets

Enterprise Data Warehousing – ETL

• Master data extraction from Flat file (Attribute and Text)
• Transaction data loading to Basic Infocube.
• Data loading to Standard DSO and DSO to Infocube.

Enterprise Data Warehouse – New concepts

• Direct Data acquisition Using Virtual Providers.
• Real time Data acquisition from SAP systems and Non SAP systems.
• Remodeling and Repartitioning.
• Migration aspects.

New Data Flow concepts in Netweaver 2004s

• Transformations and different types of Transformations.
• DTP and Types of DTPs.
• Source systems and Data sources.

Enterprise Reporting and Query Analysis

• Analyzer
• Query Designer
• Report Designer.
• Web Application Designer
• Visual Composer Reporting

BI Performance

• Aggregates
• BI accelerator
• BI Statistics

BI-Integrated Planning

• Planning Environment and Planning Functions
• Planning in the Excel
• Planning on the Web

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

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