SAP BI/BW ONLINE TRAINING | SRYIT SOLUTIONS

1
SAP BIBW OVERVIEW

• www.sryitsolutions.com
• USA 1-319-804-4998 India91-9948030675
• Email id sryitsolutions_at_gmail.com

2
INTRODUCTION

• Overview of the BW structure
• Overview of the SAP data warehousing strategy
• OLTP Vs OLAP
• Standard Naming Convention in SAP- BI
• Extended Star Schema
• DIM/ SID Tables
• SAP System Landscape

3
Types of Data

• Master Data (Attributes, Texts, Hierarchies)
• Transactional Data

4
Objects of Business Intelligence 7.0

• Info area, Info objects, Info object Catalogs
• Info abject Definitions Characteristics, Key
  Figures, Time and Unit
• Transformation and DTPs
• Dimension/ Key Figures
• Info cube Types of Info cubes
• DSO Types of DSOs

5
Flat File ExtractionData Modeling

• Dimension Design
• Staging Design
• Data Flow in BI

6
Business content

• Business content components,
• Role based and industry-based content,
• Installing business content, transport
  connection.

7
Rule Groups Rule TypesReporting

• Introduction to BW reporting
• Components of Bex reporting
• Working with business content queries.
• Getting started with the Bex Query Designer

• Working with key figures and characteristic
  Calculate key figures, properties of key figures,
  currency translation, and properties of
  characteristics, restricted key figures,
  hierarchies.

8
Extraction

• LO Extraction
• FI, CO extraction, COPA extraction
• Generic extraction using Function Module and
  View.
• Enhancement of data source

• Steps to consider before doing transportation of
  enhanced data source
• Update modes in LO extraction (Direct, Queued,
  Unsterilized V3 update), V1, V2, V3.
• Delta Management.

9
BW 3.5 Data Flow

• Info sources
• Transfer Rules
• Update Rules
• Data Loading using 3.5 flow(Master data load,
  Transactional data load)

• Migrating the Dataflow from 3.x to BI7.0
• Routines in 3.X dataflow
• Data marts
• 3.x Info sources in BI 7.0

10
Special topics

• Performance Tuning (Load performance Query
  performance)
• Aggregates
• Transportation
• Process Chains
• Routines

• Authorizations
• BI Statistics
• Remodeling Repartioning
• Real time errors Error Handling
• CV Preparation with Ongoing Projects

11
New Features of SAP BW 7.3

• Loading Hierarchies using BI7.0 Data source
• Generic delta functionalities for Non -SAP data
  sources to extract data from Non SAP source
  systems

• Semantic Partitioning
• Hybrid Info provider
• Transformation Enhancements
• DTP Enhancements
• Multiprovider as a source
• Process Chain Enhancements

12
Offered Other Modules

• SAP SAP BPC, BASIS, ABAP,BO,ADMIN,FICO,MDM,CRM
  TRAINING,HANA TRAININGFSCM,IS UTILITIESBO DATA
  SERVICES, APO.
• DWH AB INITIO TRAINING,AJAX TRAINING,INFORMATICA
  TRAINING,DATA STAGE TRAINING, HANDOOP TRAINING,
  WEBSPHERE TRAINING.

13
Contact us for more details and Session Schedules
at USA 1-319-804-4998 India91-9948030675 Emai
l sryitsolutions_at_gmail.com Web
www.sryitsolutions.com