Tuesday, September 7th, 2010

SAP BI


Overview: SAP BI ( Business Intelligence )

Business Content is delivered as an add-on to SAP BW. The naming is BI Content 3.5.3 Add-On SP06. This will be referred to as Business Content below.

Contact Us for a free no-obligation consultation and she shall guide you via our 5 step RNG Online Training using E Learning Methodology.

(732) 734-0354
info@rngusa.com

Course Outline

SAP BI Over View  / Introduction

Data Warehousing

 Data Warehouse Concept

Architecture of a Data Warehouse

  • Persistent staging area
  • Data warehouse
  • Architected data marts
  • Operational data store

Data modeling

  • Multidimensional Model of SAP BW (Data Modeling)
  • Star Schema
  • Data Warehousing Workbench (Old Administrative Workbench Overview )
  • PSA – Persistent Staging Area
  • InfoObjects: Characteristics ,  Key Figures
  • DataStore objects Old ( ODS)
  • InfoCubes
  • InfoSets , MultiProviders

Data Acquisition

  • Source Systems :
  • File Source Systems
  • SAP source systems
  • Generic and SAP delivered. – ( LoCockpit  etc.,) and custom
  • DataSource for UD Connect
  • Creating transformations ( OLD Transfer Rules & Update Rules )
  • Update Modes : Full , INIT and Delta .
  • Creating Info Packages
  • Loading MD from Flat Files
  • Loading Transaction Data from Flat File
  • Loading MD, Text and Hierarchies from SAP source
  • Loading Transactional Data from SAP source

Installing BI Content and introduction to Technical Content

Data Warehouse Management

  • Creating process chains ( and New process of BW 7.0)
  • Information Lifecycle Management
  • Remodeling of InfoProviders
  • Using the data mart interface
  • data transfer process
  • Creating open hub destinations
  • Creating aggregate for InfoCube

Miscellaneous

  • User Exits enhancement to R\3 data sources.
  • User management and  authorizations
  • Performance Tunings.
  • Partitioning , Clustering ,Multidimensional Clustering
  • Transports.
  • BI Suite: Business Explorer
  • Variables , Formulas , Calculated KF , Restricted KF  Variable Process    Types SAP , User Exits overview .
  • Web Application Designer.
  • Report Designer.

Reporting and Analysis

  • Data Warehousing Work Bench
  • Data Store Object
  • Data Transfer Processes
  • Bex web Analizer
  • Query Designer
  • Real Time Info Cube
  • Extraction Monitor
  • BI Run Time Statistics Monitor
  • Emulation, Migration & Restoring Data Sources
  • Publishing to Enterprise Portal.