Onsite Training Catalog: SAP BW Training Outline

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
Return to course description
Register
Course Pricing

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

BW Outline

ERPtips BW 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.

Just like the ERPtips Journal, our training covers the entire SAP product line, from core SAP modules like Financials, Logistics, and HR/HCM, to NetWeaver-based components, to SAP's Business Suite applications, including CRM, SCM, and SRM. We train SAP implementation team members and super-users on any issues covered in the standard SAP course catalog, and we go beyond that to offer cutting edge configuration and reporting techniques that can fill the gap in your SAP know-how.

We help SAP clients and consultants solve business and technical problems with our library of undocumented features, timesaving solutions, and best practices. Request a free sample issue of ERPtips here.

return to catalog

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

more testimonials