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