SAP BW BI Online Training

SAP BW BI Course Content

Data Ware Housing Concepts

Over View Concepts of BW

Over view of SAP R/3 Types of Applications

OLTP

OLAP

R/3 Architectures

Landscape of SAP

Transportation

Package

Request no

Return codes

Types of Data

  • Master data
  • Transaction data

Master Data

  • Attribute data
  • Text data
  • Hierarchy data

Transaction data

  • Header data
  • Item data
  • Scheduline data.

Star Scheme Concepts

  • Classical star schema.(DW)
  • Extended star schema.(BW)

Modeling & Extraction Objects

Info area

Info objects Catalog

Info objects

Info source

Direct update

Flexible update

Data source

Source system

Application component

Transfer rules

Transfer structure

Communication structure

Info providers

Data targets

Info cubes

  • Standard Info Cube
  • Real-Time Info Cube

ODS

DSO

  • Standard DSO
  • DSO for Direct Update

Write-optimize DSO

Update rules

Transformations

DTP – Data Transfer Process

  • Standard DTP
  • Error DTP
  • RDA DTP
  • Direct DTP

Info package

Extract structure

PSA

  • Standard PSA
  • Error Stack PSA

Data Acquisition

  • Standard
  • Real Time

Re-modeling

Re-partitioning

APD – Analysis Process Design

 

Visual Composer

IP – Integrated Planning

Data loading using flat files

  • Attribute data
  • Text data
  • Hierarchy data
  • Transaction data
  • Live concepts of using MDM
  • Reusability of master data

Designing the transfer rules, transfer structure and communication according to data  using different techniques Dynamic calculation ,suppressing data adding new functionality to the data of the transfer rules and update rule level while loading data.

Handling data function while loading data

BW Architecture

PSA Maintenance

  • Scheduling the data
  • Data packet by data packet
  • Complete data scheduling
  • Scheduling in background
  • Debugging the Data while loading
  • Transfer rule level
  • Update rule level

PSA Processing types

  • Terminating errors while loading the data
  • Increasing the data packet size
  • Application serer file concept _AL11
  • Scheduling the data in background

Monitoring the data loading

Scheduling the jobs based on periodic values

Canceling and deleting the back ground jobs

ODS

  • New data table
  • Active data table
  • Change log type

ODS SETTING

  • Automatic
  • Manual

Details

  • 9 cases of deltas with real scenario
  • Error handling in deltas

Data Mart

  • ODS – Info Cube
  • Info Cube _ Info Cube

ODS –ODS

Multi providers

Info set

Partitioning

Line items dimensions

Performance issues

  • Roll up
  • Aggregate
  • Collapse
  • Reconstruction
  • Deletion of data from data Targets
  • Complete deletion of data
  • Deleting data by request id
  • Selective deletions

Process Chain

  • Direct Schedule
  • Meta chain
  • Error handling in process chain
  • Monitoring process chain
  • Message integration
  • Success
  • Error
  • Always
  • Scheduling process chain based on Periodic values
  • Cancelling the process chain jobs
  • Rescheduling the process chain
  • Folder creation for a specific process chain
  • Creating a variant for ABAP programs and integrating in process chain
  • ALE Remote jobs
  • Attribute change run

Transportation

  • Assigning object to the requests
  • Releasing the Request No and their Dependency
  • Return code
  • Mail drafting to basis team regarding transportation
  • Searching objects locally and business
  • Contents through Meta Data Repository

Fact less Fact Tables

SQVI-quick views

Business content

  • Definition
  • Activation

Open hub service

Info spoke

EXTRACTION

  • Flat files
  • LOS
  • LIS
  • Generic Extraction
  • Master data
  • Transaction data
  • CO-PA
  • FI-SI
  • DB connect
  • Business content extraction
  • Generic delta

REAL TIME SCENARIO

  • Product Issues
  • Ticket Handling
  • Ticket tool tracker
  • Error handling

Reporting

  • BEX Analyzer
  • BEX Browser
  • WAD
  • BEX query designer

Role maintains

  • Creating a role
  • Assigning a role

Variables

  • Types
  • Represent
  • Entry
  • Process

Conditions

Formula

Calculated Key Figures

Restricted key figures

Exceptions

Filters

Free characteristics

Structures

Cell definitions

Query performance

Brain Errors

Forcing variables

Information broadcasting

Cache inactive

Query Monitoring

RRI (report-to-report interface)

Query properties

Debugging reports while Executing