SAP BI

SAP Netweaver 2004s BI

ERP Overview

• What is ERP?
• Why we need ERP?
• Advantages of ERP
• Major ERP Packages

SAP BW/BI Overview

• Chronology of SAP & BI

SAP Architecture

• R3 Architecture
• Client Server Technology, Landscape
• Creation of User
• Data, Tables, Rows, Columns?
• Types of Data
• OLTP Vs OLAP

Modelling
RSA1 (Data Warehouse Work bench)


Info object,
Types of Info Object

• Characteristic Info Object
• Keyfigure Info Object
• Technical Characteristic
• Time Characteristic
• Unit Characteristic

Creating Master Data info Object

Data Sources Creation
Types of Data Sources

• Master Data sources
• Text Data sources
• Transaction Data sources
• Hierarchical Data source

Loading Master Data, Text Data from Flat file
Info Package & Datasource in Details

Data Transfer Process (DTP)
Types of DTP’s

• Standard DTP
• Direct Access DTP
• Error DTP

Data Flow BW 3.5 Vs BI 7.0

Star Schema
Extended Star Schema

Info Cube – creation
Loading info cube from flat file
Transformation,

• Start Routine
• End Routine
• Expert routine
• Field/Characteristic Routine

Info Cube – Administration
Real time Cube


Virtual Info provider

• Based on DTP Direct access allowed
• Based on Function Module
• Based on BAPI

Data Store Object (DSO)
Types of DSO’s

• Standard DSO
• Write Optimized DSO
• Direct Update DSO

Load DSO from flat file
DSO Administration, Repair Full Update


Info Set

• Left Outer Join
• Right Inner Join
• Temporal Join

Multi-Provider
Open Hub Destination
Process Chains

• Process Types
• Monitoring Process Chains
• Local Chains
• Meta Chains

Performance Tuning Concepts
Compression
Aggregates
Index
Line Item Dimension
Cardinality
Partitioning, Repartitioning
BI Statistics
BI Accelerator

Miscellaneous Topics
Net weaver
Remodeling
Migration from 3.x to BI 7.0
Transportation
BI Content Installation
Information Broadcasting

Extraction
Data Extraction from R3
Source System, Data Source
Load Master Data from R3 System
Generic Extraction – Table
Generic Extraction – View
Generic Extraction – Delta
Generic Extraction – FM based
Logistics Extraction
Logistics – Delta
Data source Enhancements

• Using Customer-Exits
• Using BAdI

FI – GL, AR, AP Extraction
COPA Extraction
Real Time Extraction

Business Explorer (BEx) Reporting

• Query Designer
• Web Analyzer
• BEx Analyzer
• Web Application Designer (WAD)
• Report Designer

Reporting Over View
Characteristics – Properties
Key figure – Properties
Query Properties
New Selection, Restricted key figure
New Formula, Calculated key figure
Hierarchies
Structure
Cell Editor
Exception
Condition
Filters, Restrictions
Variables

• Characteristic Values
• Hierarchies
• Hierarchy Nodes
• Texts
• Formula Elements

Processing Types

• Manual Entry/Default Value
• Replacement Path
• Customer-Exit
• SAP Exit
• Authorization

Jump Query (RRI)
Business Objects –Overview

• Crystal Reports
• Xcelsius