BW310-BW310.pdf

Course Overview ............................................................................. vii Course Goals.................................................................................vii Course Objectives .......................................................................... viii Unit 1: Data Warehousing: Overview......................................................1 Fundamentals .................................................................................2 SAP Business Information Warehouse ...................................................9 Unit 2: The Multi-dimensional Model in SAP BW ..................................... 23 The SAP BW Star Schema Concept ..................................................... 25 Administrator Workbench (AWB) I........................................................ 38 InfoObjects .................................................................................. 44 InfoCubes.................................................................................... 79 Technical Implementation in SAP BW ................................................... 99 Unit 3: Data Extraction from SAP Source Systems and Data Flow within SAP BW ..............................................................................................119 Administrator Workbench (AWB) II ......................................................121 Loading Master Data (Attributes, Texts, Hierarchies) .................................132 Loading Transaction Data ................................................................166 Direct and Flexible Updating .............................................................188 Unit 4: Extraction from Additional Data Sources and Data Flow in SAP BW .199 Third Party Extraction Tools ..............................................................201 Integration of XML Data into SAP BW Data Staging and DB Connect .............209 Loading Master Data from Flat Files ....................................................221 Loading Transaction Data from Flat Files ..............................................267 Unit 5: Business Content ..................................................................289 Business Content (BCT) ..................................................................290 Technical Content: BW Statistics........................................................301 Unit 6: Administration of InfoCubes and Aggregates...............................315 Persistent Staging Area...................................................................317 Managing BasicCubes ....................................................................325 Aggregates .................................................................................338 Unit 7: Data Mart Interface.................................................................371 Data Mart Interface ........................................................................372 Unit 8: ODS Objects.........................................................................381 Operational Data Store Objects .........................................................382 Unit 9: Virtual Cubes and MultiProviders ..............................................429 Virtual Cubes ...............................................................................430 MultiProviders ..............................................................................439 Unit 10: Archiving (optional)..............................................................457 Archiving in the SAP BW System........................................................458