SAP BI 7.0 Course Content:
• Data warehouse fundamentals
• Introduction to SAP R/3 ( ECC ) and BW
• BW architecture
• Multi dimensional Modeling
• Star Schema, BW extended Star Schema
• Administrator Work Bench
• InfoObjects ( attributes and texts and hierarchies)
• InfoCubes, Transactional ( Real-time ) InfoCubes,
• ODS ( DSO) – Standard, Transactional and Write Optimized
• PSA, Source Systems
• InfoSource
• InfoPackage
• Transfer Rules
• Update Rules
• Transformation
• Data Transfer Process
• Loading Master Data using flat files
• Loading transaction data using flat files
• ODS - Change Log, Active Table and New Table
• Managing Delta using ODS
Ÿ MultiProviders
Ÿ infoset
• Open Hub service
• Data Marts
• InfoSpokes
• Open Hub Destination
• Aggregates
• Activating the Business content
• Loading Master data from ECC
• Delta Management
• Various types of R3 Extractors
• Extraction from LO Cockpit
- Generic Extraction
- Flat file extraction
- Integrated Planning (IP)
- • SAP landscape and Transports
- • Real Time Data Acquisition
- • BEx reporting – BEx Query Designer, Calculated and Restricted Key
- Figures, Variables ( Characteristic, Formula and Text Variables ),
- Query properties, Exceptions and Conditions, BEx Analyzer,
- Workbooks, Report to Report Interface ( RRI )
- • Information Broadcasting
- Reporting Agent
- Meta data Repository
