SAP BW BI Course Curriculum

 

 

 

Overview of the SAP- BW BI

 

  • Module One: Enterprise Structure Introduction to ERP
  • SAP, Data Warehouse Overview of BW, BI, Data Base.
  • Overview of BW Architecture, Landscape Basic Modeling:
  • Create a valid Schema Multi-Dimensional Model – The Star
  • Schema (Classical Approach) Multi-Dimensional Star
  • Schema in
  • BW (Extended star Schema) The OLAP Concept
  • Differences between OLAP and OLTP Business Modeling
  • Info Area
  • Info Object Catalogs
  • Info Objects
  • PSA
  • Application Component
  • Info Source
  • Data Source
  • Transfer Rules
  • Update Rules
  • Transfer Structure
  • Communication Structure
  • Info Package
  • Transformation
  • Data Transfer Process
  • Loading Transactional Data into BW info Cube Loading MD
  • with TD into BW System BW and BI Comparisons Master
  • data loading-new(BI) ETL process
  • Info cube & Types
  • Standard Info cube and Loading with new ETL Process
  • Generate Report with BI master and Transaction Data
  • Manual Uploading of MD like Attributes, Text, Hierarchy
  • Different Types of Attributes Transformations

 

Rule types Routines

 

  • Start Routine
  • End Routine
  • Expert Routine

 

DTP (Data Transfer Process)

 

  • Standard DTP
  • Error DTP
  • Direct Access DTP
  • Real time DTP

 

DSO (Data Store Object)

 

  • Standard DSO
  • Write optimized DSO
  • Direct update DSO
  • APD (Analysis Process & Design)
  • Update Methods
  • Full updates
  • Initialization
  • Delta Updates

 

Info Providers

 

  • Multi Providers
  • Info set
  • Virtual Providers
  • Re-Modeling
  • Re-Partitioning
  • Open-Hub Destination
  • Data Marts

 

Info Cube Maintenance

 

  • Aggregates
  • Roll-up
  • Compression
  • Reconstruction

 

Process Management

 

  • Process Chains, Process Types
  • Scheduling
  • Monitor (Header, Status, Details)

 

Reporting - Business Explorer

 

  • BEX Query designer
  • BEX Analyzer
  • BEX WAD
  • BEX Report Designer
  • Visual Composer
  • Functional Overview of Bex Query
  • Designer Reusable Query Elements
  • Query Controls with Variables
  • Calculated Key Figures
  • Restricted Key Figures
  • Formulas
  • Structures
  • Variable Definition in Detail
  • Characteristic values variables
  • Text Variables
  • Formula Variables
  • Hierarchy Variable

 

Analysis Functions

 

  • Conditions
  • Exceptions
  • Reporting Drilldown
  • Drilldown to DSO from Info Cube (RRI)
  • Copying Queries from Cubes
  • Bex Analyzer Bex WAD Bex Report Designer
  • Visual Composer Migration Objects from BW 3.x to BI 7.0
  • Transportation Extraction
  • Generic Data Extraction using MD/TD Tables
  • COPA Extraction
  • Business Content Extractions using MD/TD
  • LO-COCKPIT Data Extraction
  • Delta types for
  • Generic Extraction
  • LO Extraction
  • ASAP methodology