Classes
SAP COURSES
SAP BI/BW


Duration: 40 Classroom Hours, weekends and weekday evenings.
SAP Access: 2 Months SAP access for practice and home study from the date of enrollment.


Enterprise Data Warehousing

Introduction

  • General Introduction.
  • SAP introduction.
  • Data warehousing/ BW/ BI Introduction
  • Master data; Attributes, Texts, and Hierarchies.
  • Standard Naming conventions in SAP and BI
  • Data Modeling
  • InfoObjects: Definitions
  • Types: Characteristics, Key Figures, Time, and Unit.
  • InfoCubes: Definitions.
  • Types: Standards, real time, remote.
  • Design of Infocube: Star Schema concepts. Precautions.
  • DataStore objects (DSO)
  • Types: Standards, Real time.
  • InfoSets
  • MultiProviders: Scenarios to create Multiproviders.
  • Infocube VS DSO
  • Metadata and Document Management
  • BI Content: Definitions, How to install BI contents,  
  • Defining extraction
  • For SAP source systems: Creating Generic dataSource and maintaining SAP
    delivered dataSource.
  • Or for files: Creating DataSources for File Source Systems
  • Defining transformations
  • Transformations and different scenarios.
  • Defining the data flow
  • Creating data transfer processes
  • Creating process chains
  • Scheduling and monitoring
  • Checking process chain runs
  • Monitor for extraction processes and data transfer processes
  • Performance optimization
  • Creating the first aggregate for an InfoCube
  • Using the BIA index maintenance wizard
  • User management
  • Setting up standard authorizations
  • Defining analysis authorizations
  • Transports
  • Real business scenarios on different system environments, Moving objects from one
    system to another.  
  • BI SUITE: Business Explorer
  • BEx Query Designer
  • Queries: New queries, Restricting Characteristics, Formulas and Exception Cells
  • Query Design: Defining Exceptions, Conditions, Restricted and Calculated KeyFigures
  • Variables: The Variable Wizard, Variable Types and Processing Types, query
    Properties
  • Component Properties: Properties of Characteristics, Attributes, Structure, Formula,
    KeyFigures
  • Structures: Creating Re-usable structures
  • Functions on BW Server: Copying queries between Cubes, Deleting Query Elements
  • Web Application Designer
  • WAD: Functions of WAD, Web Items Window, Template Window, Properties Window
  • Web Applications: Creating Web Applications, Settings, Stylesheets, Symbols and
    Properties
  • Design: Designing the Layout of Web Templates, working with Library for Web Items
  • Web Items: Tables, Filters, Checkboxes, Dropdown Box and other web items and their
    attributes
  • Activities
  • BEx Analyzer
  • BEx Web Application Designer
  • BEx Report Designer
  • BI Platform
  • Information Broadcasting
  • Functions of the Broadcaster: Precalculating and Exporting into Enterprise Portal
  • User Guide: Distributing Queries and Web Templates, Scheduling Broadcasting
    Settings
  • Example Scenarios: Monthly Sales Reports, Ad-hoc Distribution Options.
  • OLAP
  • OLAP v OLTP: The OLAP Concept and differences between OLAP and OLTP
  • OLAP Functions: Aggregation, Currency Translation, Report-to-Report Interface
  • MetaData Repository: Searching for MetaData
  • Overview of Planning with SEM-BPS.
  • Architecture of BPS components.
  • Planning Models (Planning Area, Planning Level, Planning Functions, Planning
    Layouts, Packages).
  • Characteristic relationships, Variables.
  • Data Slice
  • Web Interface and Planning Folders.
  • Performance in depth
  • Data Model for Performance: Line Item Dimensions, Navigational attributes, Time-
    Dependent
  • BW Statistics: Query Analysis Tools, Performance Tables
  • Reporting Performance: Effective query design, Line-Item, Compression, Partitioning
  • Aggregates: Creating Aggregates, Finding effective aggregates
  • Data Load Performance: Parallelism, Impact of Aggregates
  • Partitioning: Logical Partitioning, Table Partitioning.
Request more information
online or call us at
510-440-1200 or via email
info@mtiedge.com