SAP BW-BI

SAP Business Intelligence

Introduction:

General Introduction

SAP Introduction

Data Warehousing/ BW/ BI Introduction

Objects, Master data, Attributes, Texts and Hierarchies

Data Modeling

InfoObjects: Definitions

Types: Characteristics, Key Figures, Time, and Unit.

InfoCubes: Definitions.

Types: Standards, Real time, Remote.

Design of InfoCube: Star Schema concepts

ODS / DSO

Types: Standards, Real time

InfoSets

MultiProviders: Scenarios to create Multiproviders

Infocube VS DSO

Standard Naming conventions in SAP and BI

Customization

Metadata and Document Management

Business Content: Definitions, How to install BI contents

MetaData Repository: Searching for MetaData

Data Extraction

Data Extraction from SAP Source Systems

Data Extraction from Non-SAP Source Systems

Data Extraction from SAP Flat Files

LO Cockpit

LO Extraction

Generic Extraction

DataSource Enhancement

Defining Transfer Rule & Update Rule

Creating Transfer Rule

Creating Update Rule
Transformation, DTP

Routines in Transfer Rule and Update Rule

Routines in InfoPackage

Creating InfoSource

Defining Data Flow

Creating Process Chains

Schedule Automatic Load

Full Load & Delta Load

OLAP

The OLAP Concept and differences between OLAP and OLTP

Scheduling and Monitoring

Checking process chain runs

Monitor for extraction processes

Performance Optimization:

Aggregates

Performance during Data load and in Reporting

Data Model for Performance: Line Item Dimensions, Navigational attributes

BW Statistics: Query Analysis Tools, Performance Tables

Reporting Performance: Effective query design, Line-Item, Compression, Partitioning

Data Load Performance: Parallelism, Impact of Aggregates

Authorizations

Setting up standard authorizations

Defining analysis authorizations

Creating Authorization Role

Transports

Transport Objects from Development to QA and Production Server

Discussion real time Transport Problems

Transport Sequence

BI SUITE: Business Explorer

Bex Query Designer

Queries: New queries, Restricting Characteristics, Formulas and Exception Cells

Query Design: Defining Exceptions, Conditions, Restricted and Calculated Key Figures

Variables: The Variable Wizard, Variable Types and Processing Types, query Properties

Component Properties: Properties of Characteristics, Attributes, Structure, Formula, Key Figures

Structures: Creating Re-Usable Structures

Functions on BW Server: Copying queries between Cubes, Deleting Query Elements

Bex Analyzer

Execute Queries

Creating Workbooks

Save multiple queries in Workbook

Workbook Design

Web Application Designer

WAD: Functions of WAD, Web Items Window, Template Window, Properties Window

Web Applications: Creating Web Applications, Settings, Style sheets, Symbols and Properties

Design: Designing the Layout of Web Templates, working with Library for Web Items

Web Items: Tables, Filters, Check boxes, Dropdown Box and other web items and their attributes

Bex Report Designer

If you have questions, please contact us at info@erpmastering.com .