SAP Material PDF Review - BW330

Course Overview ............................................................ vii

Course Goals............................................. ....................................vii

Course Objectives .................................................. .........................vii

Unit 1: Enterprise Data Warehouse Architecture ........................1

Introduction − The Enterprise Data Warehouse (EDW) Architecture................... 2

Basic Principles − The Enterprise Data Warehouse (EDW) Architecture.............. 9

The Enterprise Data Warehouse Architecture .......................................... 15

The Data Mart Layer .......................................................... ............. 20

The Enterprise Data Warehouse Layer .................................................. 24

Operational Data Store Layer − Staging Layer ......................................... 35

Unit 2: The Modeling Process ............................................... 57

Overview ................. .................................. .............................. .... 58

The Modeling Process ..................................................................... 61

Logical Data Model ........................................................................ 102

BW Data Model ............................................................................ 122

Unit 3: BI Content ........................................................131

Overview of BΙ Content ............................................. ...................... 132

BΙ Content Analyzer ....................................................................... 142

BΙ Content Browser.................................................. ...................... 147

Comparing the Model with BΙ Content .................................................. 152

Unit 4: Master Data for Modeling ...........................................181

Technical Implementation in SAP BW ......................... ......................... 183

Characteristic InfoObjects ...... ............................................... ........... 202

Reference Characteristics ............ .................................................... 219

Key Figure InfoObjects.................................................................... 223

Tracking History......................................................................... ... 236

Unit 5: Multi−Dimensional Modeling.........................................253

The SAP BW Star Schema Concept .................................................... 255

Designing the Dimensions of the SAP BW InfoCube ............................. .... 274

Performance Features ..... ............................................................... 305

Partitioning InfoCubes (Optional) ........................................................341

Summary: Overview of Data Modeling . . . . . . . . . . . . . . . . . .. . .  . . . . . . . . .350

Unit 6: Remodeling..........................................................................359

Modifying a Data Model . . . . . . . . . . . . . . . . . . . . . . . . . . .  . . . . . . . . . . . . . . . . .360

Unit 7: DataStore Objects .................................................................383

DataStore Objects . .. .. . .. . .. . .. .. . .. . .. . .. .. . .. . .. ... .. . .. .. . .. . .. .. . .. . .. . .384

Real−Time Data Acquisition . .. .. . .. . .. . .. .. . .. . .. .. . ... .. . .. . .. .. . .. . .. .. . .. . .428

Unit 8: Enhanced InfoProvider Modeling ..............................................453

MultiProviders .. . .. . .. .. . .. . .. . .. .... . .. . .. . .. .. . .. . . .. .. . .. . .. ..... .. . .. . .. . .454

InfoSets . . .. . .. .. . .. . .. .. . .. . .. . .. ... .. . .. . .. .. . .. . ... . .. .. .. . ..  .. .. . .. . .. . .477

VirtualProviders . .. . .. .. . .. . .. . .. ... .. . .. . .. .. . .. . .. . .. .. . .. . .. .. .. .. . .. . .. . .499

Unit 9: Data Transfer...................... ..................................................519

Introduction to the Open Hub Service. . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . .520

Implementing the Open Hub Service . .. .. . .. . .. .. . .. . .. . ..... . .. .. . .. . .. .. . .. . .. . .525

Unit 10: Analysis Process Designer ....................................................561

Data Mining Overview. . .. . .. . .. .. . .. . .. . .. .. . .. . .. .. . .. . .. . ... .. . .. . .. .. . .. . .. . .562

The Analysis Process Designer . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . .574

Unit 11: Information Lifecycle Management. . . ........................................601

Information Lifecycle Management. .. . .. .. . .. . .. .. . .. . .. . .. .. . .. .. . .. . .. .. . .. . .. . .602

Unit 12: Exception Aggregation (Optional) . . . . ........................................641

Exception aggregation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .642

Inventory Management (Optional) . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . .647

Unit 13: Case Study.........................................................................665

Data Modeling Case Study − General . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .666

Case Study for Data Modeling − Description of the Request. . . . .  . . . . . . . . . . .669

Unit 14: Appendix ...........................................................................677

Elimination of Internal Business Volume (Optional) . . . . . . . . . . . . . . . . . . . . . . . .678

Index............................................................................................691