SAP Material PDF Review - BW310
BW310 : Data Warehousing
- Course Version: 2006 Q2
- Material Number: 50080162
Content
Course Overview ............................................................................. vii
Course Goals.................................................................................vii
Course Objectives .......................................................................... viii
Unit 1: SAP Net Weaver and BI: Overview, Positioning and Fundamentals ......1
Fundamentals of Data Warehousing and Business Intelligence .......................3
SAP NetWeaver Business Intelligence (BI) Overview ................................. 13
SAP NetWeaver Solution Delivery: IT Practices, Scenarios, and Usage Types ... 31
SAP NetWeaver Business Intelligence: Data Warehousing Overview .............. 41
Unit 2: Objects in the BI Data Warehouse Layer ...................................... 53
Data Warehousing Workbench ........................................................... 55
InfoProviders: Business Purpose......................................................... 68
InfoObjects: Characteristics............................................................... 74
InfoObjects: Key Figures .................................................................. 99
The BI InfoCube: An Extended Star Schema.......................................... 111
Creating InfoCubes........................................................................126
Unit 3: Data Acquisition and Transformation from SAP Source Systems .....153
Data Flow: Overview......................................................................155
Loading Master Data from an SAP Source System...................................165
Loading Transaction Data from an SAP Source System .............................208
ETL Processes and Loading Hierarchies...............................................238
Unit 4: Data Acquisition from Other Systems ........................................251
Extraction from Non-SAP Systems: Overview.........................................252
Flat File Loading ...........................................................................260
Unit 5: BI Content ...........................................................................319
BI Content Discovery (Metadata Repository) .........................................320
BI Content Activation......................................................................336
Unit 6: Other InfoProviders ...............................................................347
DataStore Objects .........................................................................349
VirtualProviders and Real-Time Data Acquisition .....................................397
MultiProviders and BI InfoSets...........................................................409
Unit 7: Administration of Data Targets .................................................437
System Administration Tasks in BI: Overview..........................................439
Administration of InfoCubes ..............................................................446
Administration of DataStore Objects ....................................................463
Process Chains ............................................................................474
Unit 8: Introduction to Query Performance Optimization..........................495
Introduction to Query Performance Optimization in BI................................497
BI Aggregates ..............................................................................502
BI Accelerator ..............................................................................532
Statistics Overview ........................................................................540
Glossary .......................................................................................551