SAP BW BI Technical


SAP Business Warehouse or Business Information system or SAP BI BW Technical as it is commonly known as has gained popularity among SAP users of late. But learning it can be tricky as there are many fraudsters around waiting to make some quick bucks at your expense. That’s why you need to trust an organization with impeccable market reputation. That where we at sap online training come in.

With our detailed syllabus on SAP BW BI and our expertise in this field, rest assured you will be able to handle any challenge in this field after you complete the course. The syllabus for this course has been prepared by some of the best mind in this field and if you look at this syllabus you will see that it covers each and every aspect leaving nothing to chance. Starting from an overview of the SAP – BW BI 7.4 and then taking a step by step approach to go to more technical areas like ASAP methodology and LO extraction.


  • Overview of the SAP- BW BI 7.4
      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
      Application Component
      Info Source
      Data Source
      Transfer Rules
      Update Rules
      Transfer Structure
      Communication Structure
      Info Package
      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
      Delta Updates
  • Info Providers
      Multi Providers
      Info set
      Virtual Providers
      Open-Hub Destination
      Data Marts
  • Info Cube Maintenance
  • Process Management
      Process Chains, Process Types
      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
      Variable Definition in Detail
      Characteristic values variables
      Text Variables
      Formula Variables
      Hierarchy Variable
  • Analysis Functions
      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

HILL VIEW APARTMENT, Mumbai -400084rnPhone:+91-9930840631rn