SAP BI

Introduction to SAP Business Warehouse

• • SAP Net weaver BW Architecture / BI Platform
  • Star Schema and Extended Star Schema
  • Multidimensional modeling
  • Enterprise Reporting, Query and Analysis
  • SAP BW vs Other Data warehousing Tools
  • Data Acquisition / Data Extraction concepts

Modeling

• • Info Area ,Info Object Catalogs
  • Info Objects(Characteristics & Key Figures)
  • Data Source
  • Transfer Rules
  • Different types of Routines
  • Info Package
  • Transformations
  • Data Transfer Process(DTP)
  • Metadata Repository

Info Providers

• • Master Data – Attributes, Texts, Hierarchies
  • Standard DSO
  • Write-optimized DSO
  • Direct Update DSO
  • Standard Info Cube
  • Virtual Providers
  • InfoSet
  • MultiProvider

Business Content

• • Importance of Business Content
  • Business Content Installation & Activation
  • Business Content Data Source, DSO’s, Cubes, Reports, etc

Data Extraction

• • Flat file Extraction
  • Extraction from standard sources with ECC as target
  • Logistics Extraction
  • Generic Data Extraction
  • Delta mechanism
  • Data source Enhancement

Process Chains

• • Process Chain creation
  • Scheduling
  • Monitor
  • Real time scenarios from support projects

SAP Transport Mechanism

• • Basic SAP Landscape
  • Collecting Objects
  • Creating Transports and release
  • Importing and Monitoring Transport

Reporting

• • Introduction of BEx Query
  • Filters, Columns & Rows
  • CKF and RKF
  • Exceptions, Conditions, Structures, Cell Definitions and others

Business Explorer Analyzer

• • Introduction to BEx Analyzer
  • Filtering Option
  • Properties available in Analyzer

Performance Improvement

• • Indexing and DB stats
  • Aggregates
  • Compression
  • Read Mode & OLAP cache
  • Line Item Dimension & High Cardinality
  • Read Mode & OLAP cache

Projects Discussion

• Implementation Projects
• Up-Gradation project
• Enhancements to the existing Implementation project
• Support projects