Click to Print This Page

  Back

Business Warehousing / Business Intelligence Warehousing (BW / BI)

FIVE Classes

Mentoring Sessions  |  Resume Review  |  Interview Tips.
Online Trainees should make travel and hotel arrangements for a three-day trip to Atlanta to attend these sessions.

Study Material  |  SAPGUI Software  |  SAP Access

Course Topics

Enterprise Data Warehousing

Introduction

  1. General Introduction.

  2. SAP introduction.

  3. Data warehousing/ BW/ BI Introduction

  4. Master data; Attributes, Texts, and Hierarchies.

  5. 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