SAP BI 7.0 Course
Unit 1: Introduction
- Data warehouse Concepts
- Over view of BW Concepts
- Over view of SAP R/3
- OLTP
- OLAP
- R/3 Architectures
- Landscape of SAP
- Standard Naming conventions in SAP and BI
Unit 2: Data Modeling
- Types of Data
- Master data
- Text Data
- Attribute Data
- Hierarchy Data
- Transaction data
- Header data
- Item data
- Meta Data
- Info Objects
- Characteristics
-
- Time
- Unit
- Info package
- Time
- Key Figures
- Time
- Unit
- Time
- Info Source
- Data source/PSA
- Info providers
- Data Store Objects
- Standard DSO
- New data table
- Active data table
- Change log table
- Write optimize DSO
- Direct Update DSO
- Standard DSO
- Infocubes
- Standard
- real time
- Virtual providers
- Info sets
- Multi providers
- Info packages
- Transformations
- Object- object
- Constant
- Formula
- Routines
-
- Start
- End
- expert
- No Transformations
- Read Only MD
- Data Transfer Process (DTP)
- Standard DTP
- Error DTP
- Direct Update DTP
- BI Content Installation
- 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
- Scheduling and monitoring
- Performance issues
- Roll up
- Aggregate
- Compress (Collapse)
- Indexes
- Deletion of data from data Targets
- Complete deletion of data
- Deleting data by request id
- Selective deletions
- Partitioning
- Re-modeling
- Re-partitioning
- 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
- Attribute change run
- Open Hub Destination
- APD – Analysis Process Design
Unit 3: Extraction
- Initial/Full and Delta Updates
- Flat files(CSV, ASCII)
- Attribute data
- Text data
- Hierarchy data
- Transaction data
- Application Specific
- Logistics Cockpit
- CO-PA
- Cross Application
- Generic Extraction
-
- Table
- View
- Info set
- Function Module
- Business content extraction
- Generic delta
- Different Source Systems
- File Interface
Unit 4: Reporting
- BEX SUITE
- Query Designer
- Query Analyzer
- Report Designer
- Web Application Designer
- BEX Broadcaster
- Selections
- Formula
- Filters
- Free Characteristics
- Conditions
- Exception Cell
- Variables
- Properties
- Restricted Key Figures
- Calculated Key Figures
- Exception Aggregation
- Structures
- Cell definitions
- Query performance
Career Related Support
- Resume Building with sample resumes
- Frequently asked interview questions
- Common Production Issues with Real Time Scenarios
- Real Time Project support for 1 month after placement