02 Jul

Course Content for SAP BI 7.0/BW 7.3:

Introduction to SAP Business Intelligence

  •  SAP Net weaver BI Architecture / BI Platform
  •  Star Schema and Extended Star Schema
  •  Multidimensional modeling
  •  Entity Relationship Modeling
  •  Enterprise Data Modeling
  • Enterprise Reporting, Query and Analysis
  •  SAP BW vs Other Data warehousing Tools
  •  Data Acquisition / Data Extraction concepts

SAP BW Phases

  •  Modeling
  •  Extraction
  •  Reporting

Modeling

  •  Info Area ,Info Object Catalogs
  •  Info Objects(Characteristics & Key Figures)
  •  Application Component
  •  Data Source
  •  Transfer Rules
  •  Info Source
  •  Update Rules
  •  Different types of Routines
  •  Info Package
  •  Transformations
  •  Data Transfer Process(DTP)
  •  Error DTP
  •  Metadata Repository

BI 7.0 Info Providers

  •  Master Data – Attributes, Texts, Hierarchies
  •  Standard DSO
  •  Write-optimized DSO
  •  Direct Update DSO
  •  Standard Info Cube
  •  Virtual Providers
  •  InfoSet
  •  MultiProvider
  •  Aggregation Level
  •  Others
  •  Open Hub Destination
  •  Analysis Process designer

BW 7.3 Info Providers

  •  SAP NetWeaver BW 7.3 Features Overview
  •  Graphical Data Modeling
  •  Graphical Data Flow Modeling Basics
  •  Data Flow Copying
  •  Data Flow Generation
  •  Data Flow Migration
  •  Advanced InfoProviders
  •  Semantically Partitioned Object (SPO)
  •  Hybrid InfoProviders
  •  Transient Providers
  •  The New BW 7.3 Hierarchy ETL

Business Content

  •  Importance of Business Content
  •  Business Content Installation & Activation
  •  Business Content Data Source, DSO’s, Cubes, Reports, etc…
  • Data Acquisition / Data Extraction
  •  Flat file Extraction
  •  Business Content Extractions using MD/TD SD,MM and FI
  •  Logistics Extraction
  •  Generic Data Extraction using MD/TD Tables
  •  Delta mechanism
  •  CO-PA Extraction
  •  FI-SL Extraction
  •  Data source Enhancement

Process Chains

  •  Process Chains, Process Types
  •  Scheduling
  •  Monitor (Header, Status, Details)
  •  Real time scenarios from support projects

Transport Mechanism

  •  Review of system Landscape
  •  Collecting Objects
  •  Creating Transports
  •  Releasing Transport
  •  Importing and Monitoring Transport

Reporting:

  •  Introduction of Various Reporting Tools
  •  Functional Overview of Business Explorer Query Designer
  •  Introduction of BEx Query
  •  Reusable Query Elements
  •  Filters, Columns & Rows
  •  Characteristic Restrictions & Free Characteristics
  •  Formulas & Calculated Key Figures
  •  Restricted Keyfigures and Variables with Texts
  •  Report to Report Interface or Jump Starts
  •  Query Extracts using RSCRM_BAPI
  •  Exceptions, Conditions, Structures, Cell Definitions and others

Business Explorer Analyzer

  •  Introduction to BEx Analyzer
  •  Filtering Option
  •  Properties available in AnalyzerSAP BW BI Online Training

Performance Improvement

  •  Aggregates
  •  Compression
  •  Re-Modeling
  •  Re- Partitioning
  •  Indexes and DB Statistics
  •  Number Range Buffering
  •  Read Mode & OLAP cache
  •  Line Item Dimension & High Cardinality
  •  Read Mode & OLAP cache
  •  Business Warehouse Accelerator
  •  Others

Types of Projects

  •  Real Time Implementation Projects
  •  Up-Gradation project
  •  Enhancements to the existing Implementation project
  •  Support projects

Introduction to SAP ABAP

 What is SAP

  •  SAP Architecture and where ABAP fits in
  •  ABAP Development Workbench Tools
  •  Object Navigator
  •  Workbench Organizer
  •  Data Dictionary

ABAP Dictionary

  • Tables
  •  Views
  •  Lock Objects

ABAP Programming Techniques

  •  Reports Statement
  •  Line Size
  •  Line-count
  •  Message
  •  Page Heading
  •  Report Comment Section
  •  Declarations
  •  Tables
  •  Includes
  •  Variables (Data Types and Data Objects)
  •  Structures
  •  Internal Table
  •  Constants

ABAP for SAP BI Consultant

  • Field level Routine
  •  Start Routine
  •  End Routine
  •  Expert Routine
  •  Infopackage level Routine
  •  DataSource Enhancements