SAP BI Online training
Category : FunctionalDuration : 35 to 40 hrsTiming : Week Days (and) WeekendsMethod : Online TrainingTrainer: Certified
SAP BI Contents:
SAP BI7.0/BW7.3 Training Contents
Overview of the BW structureOverview of the SAP data warehousing strategyOLTP Vs OLAPStandard Naming Convention in SAP- BIExtended Star SchemaDIM/ SID TablesSAP System LandscapeTypes of Data
Master Data (Attributes, Texts, Hierarchies)
Transactional Data
Objects of Business Intelligence 7.0
Info area, Info objects, Info object Catalogs
Info abject Definitions: Characteristics, Key Figures, Time and Unit
Transformation and DTP’s
Dimension/ Key Figures
Info cube & Types of Infocubes
DSO & Types of DSO’s
Multiprovider
Infoset
Flat File Extraction
Data Modelling
Dimension Design
Staging Design
Data Flow in BI
Business content
Business content components
Role based and industry-based content,
Installing business content, transport connection.
Rule Groups & Rule Types
Reporting
Introduction to BW reporting
Components of Bex reporting
Working with business content queries
Getting started with the Bex Query Designer: Creating a query, changing a query, navigating through the analysis, filtering data, adding text elements.
Working with key figures and characteristic: Calculate key figures, properties of key figures, currency translation, and properties of characteristics, restricted key figures, hierarchies, attributes, variables, and global and local structures.
Query properties: Properties of queries, inserting, moving and deleting queries, detaching and refreshing queries.
Variables & Processing Types(Customer & SAP Exit)
Exception and condition: Integrating an exception in to a query result by specifying an exception.
Special topics: Web Application Designer, Work Books, Jump Queries, Currency Translations.
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, Unserialized V3 update), V1, V2, V3.
Delta Management.
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
Special topics:
Performance Tuning (Load performance & Query performance)
Aggregates
Transportation
Process Chains
Routines
Authorizations
BI Statistics
Remodelling & Repartioning
Real time errors – Error Handling
CV Preparation with Ongoing Projects
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
Data Flow Wizard and Data Flow Copy tool
Data Flow Migration Tool
Enhancements to RDA
Info package Enhancements