SAP BI Online Training
SAP BI

   Introduction

  • 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 Star Schema (Classical Approach)
  • Multi-Dimensional Star Schema in BW (Extended star Schema)
  • The OLAP Concept and 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
  • Formulae
  • 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

SPRY Web Technologies