SAP BW / BI

SAP BW / BI

SAP BW / BI ONLINE TRAINING

  •    Rating
  •   Duration 30-35 Hours
  •      Fee $ 390

Request Free Demo

SAP BW / BI TRAINING VIDEOS

  •    Rating
  •   Duration 25 Hours
  •      Fee $ 290

Buy Now



What is SAP BW/BI Training

SAP BW Accelerator includes indexes that are vertically inverted reproductions of all the data included in InfoCubes (i.e., fact and dimension tables as well as master data). Note that there is no relational or other database management systems in BW Accelerator. There is only a file system, and indexes are essentially held as flat files. The second primary component of SAP BW Accelerator is the engine that processes the queries in memory - it uses the SAP TREX Search enqine The software is running on an expandable rack of blade servers. The operating system used for BW Accelerator is 64-bit SUSE Linux Enterprise Server (SLES).

SAP BW/BI Course Content

Week-1

Introduction of the SAP- BW BI 7.4

Module One: Enterprise Structure Introduction to ERP

SAP, Data Warehouse Overview of BW, BI, Data Base.

Overview of BW Architecture, Landscape Basic Modeling:

Create a valid Schema Multi-Dimensional Model – The Star

Schema (Classical Approach) Multi-Dimensional Star

Schema in

BW (Extended star Schema) The OLAP Concept

Differences between OLAP and OLTP Business Modeling

Info Area

Info Object Catalogs

Info Objects

PSA

Application Component

Info Source

Data Source

Transfer Rules

Update Rules

Transfer Structure

Communication Structure

Info Package

Transformation

Data Transfer Process

Loading Transactional Data into BW info Cube Loading MD

With TD into BW System BW and BI Comparisons Master

data loading-new(BI) ETL process

Info cube & Types

Standard Info cube and Loading with new ETL Process

Generate Report with BI master and Transaction Data

Manual Uploading of MD like Attributes, Text, Hierarchy

Different Types of Attributes Transformations

Week-2

Rule types Routines

Start Routine

End Routine

Expert Routine

DTP (Data Transfer Process)

Error DTP

Direct Access DTP

Real time DTP

DSO (Data Store Object)

Standard DSO

Write optimized DSO

Direct update DSO

APD (Analysis Process & Design)

Update Methods

Full updates

Initialization

Delta Updates

Info Providers

Multi Providers

Info set

Virtual Providers

Re-Modeling

Re-Partitioning

Open-Hub Destination

Data Marts

Info Cube Maintenance

Aggregates

Roll-up

Compression

Reconstruction

Week-3

Process Management

Process Chains, Process Types

Scheduling

Monitor (Header, Status, Details)

Reporting – Business Explorer

BEX Query designer

BEX Analyzer

BEX WAD

BEX Report Designer

Visual Composer

Functional Overview of Bex Query

Designer Reusable Query Elements

Query Controls with Variables

Calculated Key Figures

Restricted Key Figures

Formulae

Structures

Variable Definition in Detail

Characteristic values variables

Text Variables

Formula Variables

Hierarchy Variable

Week-4

Analysis Functions

Conditions

Exceptions

Reporting Drilldown

Drilldown to DSO from Info Cube (RRI)

Copying Queries from Cubes

Bex Analyzer Bex WAD Bex Report Designer

Visual Composer Migration Objects from BW 3.x to BI 7.0

Transportation Extraction

Generic Data Extraction using MD/TD Tables

COPA Extraction

Business Content Extractions using MD/TD

LO-COCKPIT Data Extraction

Delta types for

Generic Extraction

LO Extraction

ASAP methodology

 

 

 

 

 

Quick Enquiry