§... Acknowledgments ... 17§§... Introduction ... 19§§1 ... The Business Scenario: ABCD Corp. ... 23§§1.1 ... Marketing Network ... 24§§1.2 ... The Sales and Billing Process ... 25§§1.3 ... Business Intelligence Requirements ... 28§§1.4 ... The Business Planning Scenario ... 29§§1.5 ... Summary ... 30§§2 ... Overview of SAP Business Warehouse ... 31§§2.1 ... Evolution of SAP BW ... 31§§2.2 ... SAP BW Layers ... 35§§2.3 ... Basic Navigation ... 41§§2.4 ... The Data Warehousing Workbench Functions ... 53§§2.5 ... Activation of SAP Business Content ... 55§§2.6 ... Implementation and Architecture Options ... 63§§2.7 ... Additional Resources ... 69§§2.8 ... Summary ... 70§§3 ... InfoObjects and Master Data ... 71§§3.1 ... Types of InfoObjects ... 72§§3.2 ... Creating an InfoArea ... 74§§3.3 ... Creating an InfoObject Catalog ... 76§§3.4 ... Creating a Custom Characteristic InfoObject ... 79§§3.5 ... Configuring a Characteristic InfoObject ... 82§§3.6 ... Creating a Key Figure InfoObject ... 103§§3.7 ... Configuring a Key Figure InfoObject ... 105§§3.8 ... Creating a Unit InfoObject ... 120§§3.9 ... Summary ... 122§§4 ... DataStore Objects ... 123§§4.1 ... Introduction to DSOs ... 123§§4.2 ... Architecture of the Standard DSO ... 127§§4.3 ... Designing a DSO ... 134§§4.4 ... Configuration of the Standard DSO ... 136§§4.5 ... Configuration of Write-Optimized DSOs ... 144§§4.6 ... Configuration of Direct-Update DSOs ... 146§§4.7 ... Usage Scenarios for DSOs ... 148§§4.8 ... Summary ... 149§§5 ... InfoCubes ... 151§§5.1 ... Modeling InfoCubes ... 152§§5.2 ... Types of InfoCubes ... 162§§5.3 ... Creating an InfoCube ... 166§§5.4 ... Provider-Specific Properties ... 186§§5.5 ... Summary ... 190§§6 ... InfoProviders ... 191§§6.1 ... MultiProviders ... 192§§6.2 ... InfoSets ... 208§§6.3 ... VirtualProviders ... 232§§6.4 ... Semantically Partitioned Objects (SPOs) ... 233§§6.5 ... HybridProvider ... 249§§6.6 ... Transient Providers ... 257§§6.7 ... Analytical Index ... 259§§6.8 ... CompositeProvider ... 259§§6.9 ... Open ODS View ... 267§§6.10 ... Summary ... 281§§7 ... Extraction, Transformation, and Loading ... 283§§7.1 ... Introduction to ETL ... 283§§7.2 ... Loading Master Data from a Flat File to an InfoObject ... 290§§7.3 ... Loading Transaction Data from a Flat File to a DSO ... 335§§7.4 ... Loading Data from a DSO to an InfoCube ... 354§§7.5 ... Query as DataSource ... 361§§7.6 ... Temporary Storage Areas and Error Stacks ... 364§§7.7 ... Graphical Modeling ... 372§§7.8 ... Special Topics for SAP HANA ... 383§§7.9 ... Summary ... 391§§8 ... Data Extraction from Source Systems ... 393§§8.1 ... Configuring an SAP Source System for Extraction ... 393§§8.2 ... Using SAP Business Content for Extraction: Logistics DataSources ... 395§§8.3 ... Using Generic DataSources for Extraction ... 400§§8.4 ... Data Extraction from Non-SAP Systems ... 413§§8.5 ... Introduction to Operational Data Provisioning/Operational Delta Queue ... 416§§8.6 ... SAP LT Replication Server for SAP BW ... 425§§8.7 ... Summary ... 426§§9 ... Creating Queries Using BEx Query Designer ... 427§§9.1 ... BEx Tools Landscape ... 428§§9.2 ... Introduction to BEx Query Designer ... 430§§9.3 ... Creating a Simple BEx Query ... 435§§9.4 ... Introduction to OLAP Variables ... 445§§9.5 ... Creating OLAP Variables Using the Variable Editor ... 450§§9.6 ... Creating Filters ... 463§§9.7 ... Creating Structures ... 467§§9.8 ... Creating Selections and Formulas ... 471§§9.9 ... Creating Key Figures ... 479§§9.10 ... Properties of Query Elements ... 483§§9.11 ... Creating Conditions ... 496§§9.12 ... Creating Exceptions ... 500§§9.13 ... Configuring Report-to-Report Interfaces ... 504§§9.14 ... Summary ... 508§§10 ... Reporting and Analysis Tools ... 511§§10.1 ... Running Queries in BEx Analyzer ... 512§§10.2