SAP BW经典教材，word版本，值得收藏下载

Introduction xxv Chapter 1 The Origins of Business Intelligence 1 Early Data Processing Applications 1 Enter Extract Files 2 What Is a Data Warehouse? 4 The Data Model 5 Different Physical Tables 6 Integration and Transformation ProcessingGranular Data 8 Historical Data 9 Timestamping 10 Data Relationships 10 Generic Data versus Specific Data 11 Data Quality 11 Volumes of Data 12 Removing Dormant Data 12 Meta Data 13 Evolution of Information Processing 13 Setting the Stage for Business Intelligence 16 Summary 17 ix x Contents Chapter 2 The SAP Business Intelligence Solution 19 Evolution of SAP 20 The SAP Business Intelligence Solution 24 SAP BW 24 Enterprise Portal 26 Portal Server 27 Knowledge Management 29 Business Unification 31 Summary 33 Chapter 3 SAP Business Information Warehouse Architecture 35 SAP BW Architectural Components 36 Administration Services 36 Meta Data Modeling 37 Scheduling 38 Monitoring 38 Reporting Agent 39 Meta Data Services 40 ETL Services 40 Staging Engine 42 DataSource Manager 43 BW Service API 44 DB Connect Interface 45 File Interface 45 XML Interface 45 Staging BAPI 46 Storage Services 47 Master Data Manager 47 ODS Object Manager 47 InfoCube Manager 48 Aggregate Manager 48 Archiving Manager 48 Analysis and Access Services 49 Information Provider Interface 50 OLAP Engine 50 OLAP BAPI 50 XML for Analysis 50 Business Explorer API 51 Open Hub Service 51 Analytic Services and Data Mining Engine 51 Content Management Framework 51 Presentation Services 51 BEx Analyzer 52 BEx Query Designer 53 BEx Web Application Designer 53 BEx Web Services 53 Contents xi BEx Formatted Reporting 53 Internet Graphics Server 54 Front-End Tools 54 SAP BW Meta Data Objects 54 InfoObjects 54 InfoObject Catalogs 57 InfoCubes 57 Aggregates 59 ODS Objects 59 Data Target 59 InfoProviders 59 MultiProviders 60 InfoAreas 60 Source Systems 60 InfoSources 61 Application Hierarchy 62 DataSources 62 Transfer Rules 62 Update Rules 63 InfoPackages 64 Process Chains 66 Queries 66 Query Workbooks 67 Reporting Agent 68 InfoSets 68 Open Hub Destination 68 InfoSpokes 69 Users 69 Authorizations 69 Roles 69 Currency Translation Types 70 Mapping the Corporate Information Factory to SAP BW components 70 The Operational Data Store 73 The Data Warehouse Layer 73 The InfoMart Layer 74 The Architectural Roots of SAP BW 75 SAP Web Application Server Architecture 76 Core Components 78 Software Development 79 Software Logistics 79 Security 79 Administration 81 Additional Functionality 81 System Landscape Considerations 82 Summary 87 xii Contents Chapter 4 Information Modeling 89 Information Modeling Prerequisites 90 Understanding the SAP BW Meta Data Model 93 Master-Data Data Model 95 The InfoCube Data Model 99 The ODS Object Data Model 102 Understanding the Business Content 103 Developing an Information Model 106 Modeling the Operational Data Store 107 Modeling the Data Warehouse 108 Modeling InfoMarts 113 Dimensions 114 Key Figures 118 Master Data 127 Virtual Key Figures and Characteristics 142 Additional Options for Information Modeling 142 Transactional Data Targets 142 Multilevel Staging Considerations 143 Modeling Virtual InfoProviders 144 Information Flow Modeling 146 Typical Information Flow Models 146 SAP BW Interfaces for Information Flow Modeling 151 Summary 152 Chapter 5 Understanding Business Content 153 What Is Business Content? 154 Business Content Progression 157 Horizontal Growth 157 Vertical Growth 158 Business Content and Analytic Applications 159 Business Content and Analytic Applications in the Corporate Information Factory 161 Using Business Content 164 Business Content Value Proposition 164 Myths 165 Usability 166 Challenges 168 How Business Content Models Information 172 Strategic Buying 173 Consolidation Reporting 182 Human Resources Strategic Analysis 192 The Future of Business Content 196 Technological Innovations 197 Disintermediation 197 Summary 198 Contents xiii Chapter 6 ETL Services 201 Extraction 205 Basic Principles 205 Classes of Data 206 Data Flow and Integration 208 Dimensions of Data Extraction 210 OLTP Technology Considerations 213 SAP Source Systems 216 Architecture 216 Meta Data Flow 217 Data and Control Flow 219 Example of an Application Specific Extractor 222 Generic Extraction 223 Client-Specific Data Extraction Options 224 Flat-File Interface 226 Architecture 226 Data and Control Flow 227 DB Connect 227 Architecture 227 Data and Control Flow 229 Staging BAPI 229 Architecture 229 Data and Control Flow 231 Ascential DataStage 232 XML Interface 234 Architecture 234 Data and Control Flow 235 Closing the Loop 235 Transformation 237 Common Transformation Operations 237 Data Integration Transformations 237 Application Logic Transformations 239 Reference Objects for Transformations 240 Data Transformation in SAP BW 241 Architecture and Data Flow 241 Persistency Considerations 242 Multilevel Staging Considerations 243 Transfer Rules 245 Conversion Exits 246 InfoObject Assignment Option 246 Constant Value Assignment Option 247 Formula Option 247 Routine Option 249 Start Routine 254 xiv Contents InfoObject Transfer Routines 255 Rules of the Game 257 Update Rules 258 Characteristics/Key Field Update Rules 258 Key Figure/Data Field Update Rules 264 Start Routine 266 Rules of the Game 267 Loading 271 Master Data Loading 271 Master Data Attributes 272 Master Data Texts 273 Master Data Hierarchies 274 InfoCube Loading 274 Loading ODS Objects 275 Summary 277 Chapter 7 Information Access, Analysis, and Presentation 279 Architecture 280 Query Processing Overview 280 Presentation Services 283 Business Explorer Components 283 BEx Query Designer 284 BEx Analyzer 295 BEx Formatted Reporting 298 Business Explorer Web Application Designer 301 BEx Mobile Intelligence 309 Information Analysis and Access Services 310 Information Provider Interface 310 Physical InfoProviders 312 Virtual InfoProviders 312 OLAP Engine 314 Analytical Services 314 Data Mining Services 315 Other Core Services 315 Report-to-Report Interface 316 Personalization 317 Currency Conversion 319 Content Management Framework 321 Attaching Documents 321 Internet Graphics Server 322 Information Access Interfaces 322 Interface Options for Third-Party Presentation Tools 324 Preparing for Third-Party Access 328 The Business Explorer API 330 Summary 331 Contents xv Chapter 8 Analytic Applications 333 Analytic Application Architecture 334 Customer Relationship Analytics 337 Analytic Engines 339 Customer Behavior Analysis 339 Customer Lifetime Value Analysis 350 RFM Analysis 352 Supply Chain Analytics 355 SCOR Model 356 Architecture 360 Supply Chain Cockpit 361 Demand Planning 363 Design Impacts 364 Case Study 365 Business Content 369 Strategic Enterprise Management 371 Corporate Performance Management 372 Balanced Scorecard 372 Enterprise Planning 378 Architecture 378 Planning Applications 382 Consolidation 387 Information Model 388 Summary 392 Notes 393 Chapter 9 Administration in the SAP Business Information Warehouse 395 Process-Oriented Administration 396 Process Chains 396 Dependencies 398 Data Management Processes 401 Data Load Process Variants 402 Miscellaneous Process Type Variants 411 Reporting Agent Processes 411 Exception Reporting 412 Printing 413 Web Templates 415 Value Sets 416 Monitoring 416 Data Monitor 416 Troubleshooting 420 System-Oriented Administration 421 Archiving 421 xvi Contents Security 424 User versus Role 427 Object versus Data 428 Transports 431 Transport Connection Tool 431 Transport Dependencies 432 Activation 434 Upgrades 436 Summary 438 Chapter 10 Performance Planning and Management 439 Performance Planning 441 Managing User Expectations 441 Information Modeling 442 InfoCube Modeling 442 ODS Object Modeling 446 Master Data Modeling 447 Remote Cubes 448 MultiProviders 448 Database Partitioning 449 Complex Aggregations 453 Multiple Staging Levels 453 Information Flow Modeling 456 System Landscape Design and Setup 456 Database and Web Application Servers 456 Client Systems 463 Network Considerations 463 Performance Impact on Source Systems 464 Process Design 465 Performance Management 465 The Technical Business Content 466 Reporting and Analysis 469 Data Loading and Data Management 478 Data Extraction 479 Data Staging 480 System Performance 480 Application Server 481 Database Server 483 Hardware and Operating System 486 Exceptions 487 Transaction and Menu Summary 488 Summary 489 Bibliography 491 Books 491 Papers and Articles 492 Standards and Internet Resources 492