Home > SAP Training > SAP Course Listing > SAP Business Intelligence > Business Warehouse > Course Outline

Course Outline for SAP Business Warehouse (BW) Training

Enterprise Data Warehousing

Introduction:

 

  • General Introduction
  • OLTP vs. OLAP
  • SAP introduction
  • Data warehousing/ BW/ BI Introduction
  • BW Architecture
  • OLAP Tools

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

ETL:

 

  • For SAP source systems: Creating Generic dataSource and maintaining SAP delivered dataSource
  • Or for files: Creating DataSources for File Source Systems
  • Transformations and different scenarios
  • DTP - Data Transfer Prcoesses
  • Process Chains

Performance Optimization:

 

  • Aggreagates
  • Partitions, Compression
  • Number Ranges, Query Cache, Dimensional Design Analysis
  • BI Accelrator Index

User Management:

 

  • Setting up standard authorizations
  • Defining analysis authorizations
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

Advanced Topics

Business Objects XI 3.X:

 

  • SAP BOBJ Connectivity Overview
    - Crystal Reports and BW
    - Creating Report with BW Query
    - Usinng BW Variables in Crystal Reports
    - Using BW Hierarchies in Crystal Reports
  • WebI with SAP NW BW
    - Creating Universe on SAP NW Metadata
    - Using BW Variables in WebI
    - Using Hierarchies in WebI
  • Xcelsius with SAP NW BW
    - Xcelsius Dashboards with Crystal Reports
    - Xcelsius Dashboards with WebI
    - Xcelsius Dashboards with Crystal Reports and Live Office
SAP Course Listing Return to SAP BW Course Description
Register
Course Pricing

To schedule a training session with ERPtips or to find out more information, email Training at ERPtips dot com.

SAP BW

ERPtips SAP Business Warehouse class takes you on the inside journey into step by step configuration of the required components of FI. Essentials such as setting up your company and the related financial parameters necessary to capture events that affect a company's financial position. Take a walk through a case study and set up a functioning financial organization with day to day management of financial inputs and outputs using the General Ledger, Accounts Payable, and Accounts Receivable.

Written by Klee
This course book was written by and published by Klee Associates, Inc. The information in our books come from the collective experience of our consultants. They have implemented SAP at dozens of client sites around the world.

Use our workbooks to better understand the power and functionality of SAP, basic and advanced setup, advanced tips and techniques that illustrate creative and powerful uses of the software, and best practices. Should you need consulting help, we will be glad to recommend to you the best consultants from our growing SAP consulting practice.

SAP Course Listing

Testimonials

"The ERPtips instructor geared this class to the students and their companies' Basis environments. We covered important topics that are hard to find practical information on, like kernel upgrades and hotpacks. I was later able to apply this knowledge to my company's own SAP system.

To get exposure to all the key material in this course, I might have had to take about three courses from SAP itself. The instructor went the extra mile to make sure that everyone's questions were answered."

Pete Peters, IT Manager, Prym Consumer USA

Training Testimonials