SAP NETWEAVER BUSINESS WAREHOUSE 7.3.
1. SAP BI Overview.
ERP overview.
- What is ERP and Why ERP?
SAP history and different Sap Products.
- Sap Cross Industry Applications
- Sap Industry Specific solutions.
Role of SAP BI.
- Implementation
- Support
- Upgrade and Migration.
Basics of Data Warehousing.
- Star Schema
- Extended Star Schema
- Advantages of Extended Star Schema
Terminology and Project Orientation
2. Data Modeling, DW Design and Data loading From File sys.
BI System architecture.
- Data warehouse
- ETL
- Bex Suite
- Functions of Data warehousing workbench.
- Development of Info objects.
- Characteristics
- Key Figures
- Development of Attributes and all the Tabs of Chars and Key figure.
- Display attribute
- Navigational attributes
- Transitive attribute
- Compounding attribute
- Designing the different types of Infocubes and DSO
- Master Data loading—Attribute/Text/Hierarchy
- Transaction data loading—-Loading to DSO and Info cube.
- Full upload
- Initialization
- Delta uploads
- Real time Data acquisition and Direct data Access (Virtual Provider)
- Error Stack and Error Dtp //Issues in data Loading
- Installing Objects from BI content.
- Info sets and Multi Providers.
- Inner Join/Left Outer Join
- Union
- Placing Flat Files in Application Server.
- Data Modeling Tasks in a Project Environment
3. Data loading from SAP ERP and Database systems.
- Source system interfaces and logical systems. Remote function calls.
- Source system application and data source overview. Types of Extractors.
- Logistics Data Extraction
- Full upload
- Initialization of data source
- Delta uploads
- Generic Extraction
- Full upload
- Initialization of data source
- Delta uploads
- DB extraction
- Controlling Data Extraction.
- Full upload
- Initialization of data source
- Delta uploads
- Finance Extractors.
- Master data Extraction from Sap ERP sys.
- Data source Enhancement.
4. Business Explorer Business Intelligence.
- Basics of Reporting. Components and Tools of Reporting.
- Query Designer and Different Elements
- Free chars
- Filters/Restriction
- Conditions/Exceptions
- Restricted key figure/Calculated key figure/New selection/New formula
- Variables-all types.
- Analyzer
- Design Mode
- Analysis Mode
- Report Designer and Formatting Techniques of Report Designer.
- Web application Designer and Web Analyzer.
- Bex Broadcaster.
- Visual Composer Reporting.
5. BW 7.0 Topics & Supporting.
- Start , End & Expert routines
- Remodeling
- BI Accelerator,
- BW Statistics.
- Performance Issues.
- Query Performance
- Compression
- Aggregates/Rollup
- Indexes
- Line item Dimension, Cardinality Height
- Query trace/SQL Trace
- Attribute and Hierarchy change run/etc…
- Extraction performance
- PSA partitioning/PSA and Change log Table Data Deletion
- Transportation
- Process chains Designing and Monitoring
- Supporting Issues, Tickets and Miscellaneous topics.
6. BW 7.3 DeltaS
- Hybrid Providers
- Composite Providers
- Transient Providers.
- Scenarios For New Info providers.
- Semantic partitioned objects
- DSO Partitioning
- Data Flow Copy and Data Flow Migration tool
- Loading Hierarchies By using 7.3
- Other 7.3 Features.