Wednesday, July 3, 2013
What is SAP BI?
Why SAP BI?
How SAP BI?
Why SAP BI?
How SAP BI?
- Architecture
of SAP NetWeaver BI 7.0
- Introduction
to SAP R/3 (ECC).
- Introduction
to BI Architecture.
- Multi
dimensional Modeling, Star Schema, BW extended Star Schema
Master Data in the Real Business.
Transaction Data in the Real Business.
Transaction Data in the Real Business.
MODELLING:
Defining BI Data Target Objects:
InfoObjects:
Attributes
Texts
Defining BI Data Target Objects:
InfoObjects:
Attributes
Texts
InfoCubes:
Standard InfoCubes
Virtual InfoCubes
Standard InfoCubes
Virtual InfoCubes
Data
Store Objects (DSO):
Standard DSO
Write Optimized DSO
Direct Update DSO
Standard DSO
Write Optimized DSO
Direct Update DSO
Source Systems:
- File
- SAP
- Database
- Web
Service
Data Sources:
- Data
Source for Flat File
- Data
Source SAP Systems.
- Data
Source for Data Base System.
- Data
Source Web Services.
Extraction BI Objects:
- Inserting
Characteristic as an info provider
- InfoPackage
- Data
Transfer Process
Other SAP BI Objects:
- InfoProviders
- InfoSource
- MultiProviders
- Transformation
- InfoSets
- Aggregates
Down Stream BI Objects:
- Open
Hub Destination
Designing Data Flow Design and Loading of Master
Data into BI from FLAT FILE:
- Data
Flow Design to load Master Data Attributes into InfoObject using Flat
Files.
- Data
Flow Design to load Master Data Texts into InfoObject using Flat Files.
Designing Data Flow Design and Loading of
Transaction Data into BI from FLAT FILE:
- Data
Flow Design to load Transaction Data into InfoCubes using Flat Files.
- Data
Flow Design to load Transactional into InfoCube through DSO using Flat
File.
SAP BI Content:
- Benefits
and use of the business content
- Introduction
to administration of BI data targets
- Transports
and Landscapes
BEx – Reporting:
Query Design and Query Analyzer:
Query Design and Query Analyzer:
- Architecture
and functions of the SAP BI Analysis Tools
- Creating
Query Definitions with the BEx Query Designer
- Analyzing
the Query in the BEx Analyzer
- Filters
and
- Free
Characteristics
- Exceptions
and
- Conditions
- Calculated
Key Figures and
- Restricted
Key Figures
- Variables
( Characteristic based single values)
- Variables
( Characteristic based multiple single values)
- Variables
( Characteristic based interval values)
- Variables
( Characteristic based select option values)
- selection
- Formulas
SAP R3 ECC- BI Extraction:
SAP BI Content:
SAP BI Content:
- Standard InfoObject
- Standard InfoCub
- Standard DataStoreObject
- Collecting Objects
- Grouping Objects
- Installing Objects
Components of the data flow and extracting data
from SAP Source Systems in the BI
Various types of Standard R3 Extractions:
Various types of Standard R3 Extractions:
- Master
data Extraction.
- Extraction
from Master Data Table.
- Transaction
Data Extraction.
- Extraction
from SD and FI
Generic Extractions from SAP R3 System:
- Master
data Extraction.
- Extraction
from Master Data table.
- Transaction
Data Extraction.
- Extraction
from Transaction Data Table.
BI – Performance
Tuning: Reporting and support
- Effective
query design, Compression, Partitioning
- Aggregates:
Creating Aggregates.
- Infocube
Partitioning,
- InfoCube
Remodeling
BI – Miscellaneous Topics:
- Interview tips and Mock interviews
0 comments:
Post a Comment
Your useful comments, suggestions are appreciated.Your comments are moderated.