SAP Techno Functional

SAP BI/BW(Business Information Warehouse)CONTENT

SAP Business Information Warehouse (SAP BW) is the name of the Business Intelligence, analytical, reporting and Data Warehousing (DW) solution which is one of the major enterprise software applications produced by SAP AG. It was originally named SAP BIW, (Business Information Warehouse), but is now known as "SAP NetWeaver BI". For the modern enterprise, time wasted due to data loss and inconsistencies is unacceptable,particularly when this can often be remedied easily through the use of a data warehouse. SAP introduced Business Warehouse Information Systems (BW) in the first half of 1997. This system approach consolidates the external and the internal sources of data into a single repository and provides preconfigured data that aids the organizations and enterprises in dealing with the data management and archiving. The SAP environment therefore expanded its horizon with the introduction and implementation of SAP BW to encompass new applications for the SAP R/3 administrators responsible for administering and maintenance of these data reserves.

SAP-BW

Overview and Concepts
  • Over view of SAP R/3
  • Necessity of SAP BW
  • Versions of SAP BW
  • Over view of SAP BW
  • OLAP and OLTP
  • Data Ware Housing Concepts
  • Landscape of SAP BW
  • Homogeneous + Heterogeneous
  • Integration of BW system with different systems
  • ERM + MDM + Star Schema
  • Extended Star Schema

Architecture of SAP BW

Objects in SAP BW

  • Info Area + Info Objects Catalogs
  • Characteristics
  • Key Figures-Cumulative and Non Cumulative
  • PSA + Transfer Structure/Data Source
  • Transfer Rules
  • Info Sources/Communication Structure
  • ODS + Info Cubes
  • Types of Info Cubes + Update Rules

Data loading using flat files

  • Master data + Attributes data
  • Texts data + Hierarchies´┐Ż data
  • Transactions data + Delta data loading

Data filtration techniques

  • Transfer rules level
  • Update rules level
  • Start routines

SAP BI 7.0

Business Intelligence Concepts and Overview

Modeling: Data warehousing workbench

  • Components of Data Warehousing workbench
  • InfoObjects + DataSources
  • Types of DSOs + DataSources Repository
  • Migration of 3.*DataSources and recovery of 3.*

DataSources

  • Differences between ODS(Operational Data Store) and DSO
  • Data Loading: Master Data
  • Attributes Data Loading using flat files in BI 7.0
  • Texts Data Loading using flat files in BI 7.0
  • Hierarchies Data Loading in 3.*
  • Concepts on Transformations
  • Controlling the Data flow with Info Packages

and Data Transfer Process(DTPs)

    and Data Transfer Process(DTPs)
  • Data flow concepts in SAP BI 7.0
  • Transactions Data Loading in BI 7.0
  • Flat files data loading to Info Cubes
  • Flat files data loading to DSO
  • Delta loading to Info Cube Via DSO

DSO

  • Standard + Direct
  • Write Optimized

Transformations

  • Creating Transformations
  • Types of Transformations

Routines at Transactions

  • Field Level Routines + Start Routines
  • End Routines + Expert Routines

BEx Query Desinger

  • Introduction to BEx Query designer
  • Filters in the query
  • Characteristic Restrictions
  • Rows and Columns
  • Free Characteristics
  • Formulas ´┐ŻCalculated KeyFigures
  • New Selection-Restricted KeyFigures
  • Structure + Hierarchies
  • Attributes + Navigational Attributes
  • Variables + Text Variables
  • Characteristics Variables
  • Different Types of Variables
  • Conditions + Exceptions
  • Cell Definitions
  • Report to Report Interface(RRI)
  • How to use replacement path and customer exit

Variables

  • Customer exit Programs
  • Properties of the Components

Web Application Desingner

  • Creating Web Template
  • Web Items
  • Properties of Web Template
  • Table + Text Elements
  • Generic Navigation Block
  • Drop down boxes
  • Radio Buttons and Check boxes
  • Filters + List of Exceptions
  • Conditions + Integrating with the charts
  • Ad-hoc Query designer

Business Explorer Analyzer

  • Introduction to BEx Analyzer
  • Filters in BEx Analyzer
  • Drag and Drop Function
  • Various functions used in Analyzer
  • Creating New Workbook

Demo project

Types of Project
  • Project Preparation + Blue print phase
  • Requirements Gathering
  • Functional Spec design
  • Technical Spec Design
  • AS IS Process
  • Unit testing
  • Integration Testing
  • Final preparation
  • Cutover activities
Up-gradation Project
  • Up-gradation check list
  • Activities to be performed during up-gradation
Enhancement to the existing Implementation
  • Activities in enhancement to existing
Implementation project

Support Project

  • Various support activities
  • Handling Tickets
  • Support issues/errors
  • Resolving support issues

Advanced Topics in BI 7.0

  • Modeling/Remodeling
  • Partitioning/Repartitioning
  • Data Mart
  • Open Hub Destinations
  • SAP-BO

Why Choose Us

  • Empower your SAP end users with SAP training courses.
  • Provides centralized managerial and administrative support services.
  • Professional training accomplished the past 12 years
  • Training courses are designed as per the current industry standards
  • After training complication candidate can go for certification exams
  • Trainers are certified professionals with 10+ years of experience