SAP BW BI 7.4

  • 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
  • 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)
  • 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

Course Video

The Course Videos Section.

Course Overview

The Course Overview Section.