Introduction to ERP/SAP

General Introduction ERP/SAP

Enterprise Data Warehousing

 Introduction to Data warehousing/ BW/ BI 

Master data; Attributes, Texts, and Hierarchies

Standard naming conventions in SAP and BI  

Modelling

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. 

Data Store objects (DSO)

Definition of DSO

Types of DSO

Standards DSO

Real time DSO

Real world Cases

 InfoSets

 Definition of DSO

Types of DSO

Real world Cases

 MultiProvider

Definition of multi provider

Real world Cases

 InfoCube VS DSO

 Metadata and Document Management

 BI Content

Definitions and how to install BI contents

Extractions

Defining Extraction -  SAP source systems

Creating Generic dataSource and maintaining SAP delivered dataSource

Creating DataSource for File Source Systems

Transformations

defining transformation

 SAP BI/BW Reporting 

 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

 Report Broadcasting and Publishing 

Information Broadcasting

Functions of the Broadcaster

- Precalculating and Exporting into Enterprise Portal

User Guide to Broadcasting

- Distributing Queries and Web Templates, Scheduling Broadcasting Settings

 OLAP

OLAP v OLTP

The OLAP Concept and differences between OLAP and OLTP

OLAP Functions 

Advance BI reporting

Aggregation

Currency Translation

Report-to-Report Interface

Metadata Repository: Searching for Metadata

Integrated Planning

Setting up planning structures

Manual planning and options for layout formatting

Defining generic planning functions

Designing end-user interfaces with the help of planning books and the Web Interface Builder

Integrating BI hierarchies and attributes