SAP Material PDF Review - TBW10

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 ........................................................... 40

Unit 2: Objects in the BI Data Warehouse Layer.................. 51

Data Warehousing Workbench...................................... 53

InfoProviders: Business Purpose................................... 64

InfoObjects: Characteristics ......................................... 69

InfoObjects: Key Figures ............................................ 95

The BI InfoCube: An Extended Star Schema ....................107

Creating InfoCubes ..................................................122

Unit 3: Data Acquisition and Transformation from SAP Source

Systems ...................................................................145

Data Flow: Overview ................................................147

Loading Master Data from an SAP Source System .............156

Loading Transaction Data from an SAP Source System .......196

ETL Processes and Loading Hierarchies .........................226

Unit 4: Data Acquisition from Other Systems....................239

Extraction from Non-SAP Systems: Overview...................240

Flat File Loading .....................................................247

Unit 5: Business Content .............................................303

BI Content Discovery (Metadata Repository) ....................304

BI Content Activation ................................................320

Unit 6: Other InfoProviders ..........................................331

DataStore Objects ...................................................333

VirtualProviders and Real-Time Data Acquisition................377

MultiProviders and BI InfoSets .....................................388

Unit 7: Administration of Data Targets.............................415

System Administration Tasks in BI: Overview....................417

Administration of InfoCubes ........................................424

Administration of DataStore Objects ..............................441

Process Chains ......................................................451

Unit 8: Introduction to Query Performance Optimization .....471

Introduction to Query Performance Optimization in BI ..........473

BI Aggregates ........................................................478

BI Accelerator ........................................................508

Statistics Overview...................................................516

Glossary...................................................................527