skip to content
Enroll Now
headerbannervision

Course #: 11030e - SAP BW/BI - Business Warehouse / Business Intelligence

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
  •         Metachain
  •         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 throughMetaData 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

Recommended Prerequisites:

  • There are no mandatory prerequisites. Work experience in IT services is recommended.