SAP BI ONLINE TRAINING
Contact : skype id : keylabstraining ,US : +1-908-366-7933, India : +91 -9550645679
SAP BI Online Training Content
Introduction:
- Data Ware Housing Concepts
- Over View Concepts of BW
- Over view of SAP R/3 Types of Applications
- OLTP
- OLAP
- R/3 Architectures
- Landscape of SAP
- Types of Data
- Master data
- Transaction data
- Master Data
- Attribute data
- Text data
- Hierarchy data
- Transaction data
- Header data
- Item data
- Scheduled line data
- Star Scheme Concepts
- Classical star schema.(DW)
- Extended star schema.(BW)
- MODELLING
- Info area
- Info objects Catalog
- Info objects
- Info source
- Data source
- Source system
- Application component
- Transfer rules
- Transfer structure
- Communication structure
- Info providers
- Data targets
- Info cubes
- Standard Info Cube
- Real-Time Info Cube
- DSO
- Standard DSO
- DSO for Direct Update
- Write-optimize DSO
- DSO Structure
- New data table
- Active data table
- Change log type
- DSO SETTING
- Automatic
- Manual
- Data Mart
- Transformations
- Transformation Process
- Start Routine
- End Routine
- Expert Routine
- DTP – Data Transfer Process
- Standard DTP
- Error DTP
- RDA DTP
- Direct DTP
- Info package
- PSA
- Standard PSA
- Error Stack PSA
- Data Acquisition
- Standard
- Real Time
- Data loading using flat files
- Attribute data
- Text data
- Hierarchy data
- Transaction data
- Reusability of master data
- Info cube
- Types of Info cubes
- Physical data stores
- Virtual data stores
- Multi providers
- EXTRACTION
- Master data
- Transaction data
- Flat files
- LIS
- LO
- Generic Extraction
- CO-PA
- FI-SI
- DB connect
- Business content extraction
- REPORTING
- BEX Analyzer
- BEX Browser
- WAD
- BEX query designer
- Role maintains
- Creating a role
- Assigning a role
- Variables
- Types
- Processing types
- Conditions
- Formula
- Calculated Key Figures
- Restricted key figures
- Exceptions
- Filters
- Free characteristics
- Structures
- Cell definitions
- Query performance
- Information broadcasting
- Cache inactive
- Query Monitoring
- RRI (report-to-report interface)
- Query properties
- Debugging reports while Executing
- OTHER TOPICS
- Process Chain
- Direct Schedule
- Meta chain
- Error handling in process chain
- Monitoring process chain
- Message integration
- Success
- Error
- Always
- Scheduling process chain based on Periodic values
- Cancelling the process chain jobs
- Rescheduling the process chain
- Folder creation for a specific process chain
- Creating a variant for ABAP programs and integrating in process chain
- ALE Remote jobs
- Attribute change run
- Performance Tuning
- Roll up
- Aggregate
- Collapse
- Reconstruction
- Deletion of data from data Targets
- Complete deletion of data
- Deleting data by request id
- Partitioning
- Line items dimensions
- Selective deletions
- Re-modeling
- Re-partitioning
APD
– Analysis Process Design
- Transportation
- Assigning object to the requests
- Releasing the Request No and their Dependency
- Return code
- Mail drafting to basis team regarding transportation
- Searching objects locally and business contents through Meta Data Repository
- Business content
- Definition
- Activation
- Open hub service
- Info spoke
- REAL TIME SCENARIO
- Product Issues
- Ticket Handling
- Ticket tool tracker
- Error handling
SAP-BI/BW Project/Real-Time Training Contents
Modeling
·
Tasks in implementation project and support project
·
Hierarchy & Attribute loads
·
Attribute change run
·
Info sources in BW 3.x & BI 7.0?
·
Business Content
·
Info cube, ODS
·
Scenario for three types of ODS
·
Discuss about the staging (when to use ODS and Cube)
·
Types of DTP'S
·
What are Rule Groups, Rule Types?
·
Multi provider & Info set
·
Routines
·
Modeling approach - Dimension Design, Account Based
Model & Key Figure Model
·
Difference between BW3.5 and BI7.0?
Reporting
·
Structures, Conditions, Exceptions, Cell
Restrictions, Variables, Jump queries, Information Broadcasting, Filters,
Free Characteristics, Selections, Formula, RKF, CKF, Percentage functions, Data
functions, Boolean Functions.
·
5 Variables,
·
5 Processing types with scenarios
Extraction
·
LO Extraction
·
FI, COPA extraction
·
Functional Process of MM,SD,FI
·
SD, MM,FI reports developed
·
Converting Functional Specifications to technical
specifications with MM example
·
SD Case Study
·
Enhancement of data source
·
Steps to consider before doing transportation of
enhanced data source
·
Update modes (Direct, Queued, Unserialized V3
update), V1, V2, V3
·
Generic extraction using Function Module and View
·
Delta Management
·
Performance (load performance & Query
performance)
·
Aggregates
·
Transportation
·
Process Chains
·
Authorizations
·
BI Statistics
·
Remodeling & Reporting
·
Real time errors - Error Handling
·
Questionnaire for Interviews
- CV Preparation.
