Efficient SAP NetWeaver BW Implementation and Upgrade Guide

27.07.2010

Englisch

9781592293360

Rheinwerk Publishing

SAP PRESS Englisch

Nein

Gary Nolan

532

2

Gebundene Ausgabe

NetWeaver, Business Warehouse, Database, Upgrade, Implementation

. Acknowledgments. 21 . Introduction. 23 1. The SAP NetWeaver BW Project Lifecycle. 27 . 1.1. SAP ECC vs. SAP NetWeaver BW Implementations. 28 . 1.2. Difference Between OLTP and OLAP Systems. 28 . 1.3. SAP NetWeaver BW from A to Z. 29 . 1.4. External Data: What is the Big Deal. 35 . 1.5. Build for the Present, Keep an Eye on the Future. 36 . 1.6. Dirty Data. 38 . 1.7. Can't SAP NetWeaver BW Just Clean the Data. 39 . 1.8. Understanding SAP NetWeaver BW. 40 . 1.9. Reasons for Implementing SAP NetWeaver BW. 40 . 1.10. Why Not Another Data Warehouse. 51 . 1.11. What SAP NetWeaver BW is Not Designed to Do. 54 . 1.12. SAP BusinessObjects Capabilities. 58 . 1.13. Ingredients for a Successful SAP NetWeaver BW Project Manager. 59 . 1.14. Conclusion. 68 2. Defining an Implementation Strategy. 69 . 2.1. Defining an Upgrade Strategy. 71 . 2.2. SAP NetWeaver BW Implementation Approach. 72 . 2.3. SAP NetWeaver BW Hardware Sizing. 73 . 2.4. Landscape Strategy. 74 . 2.5. Upgrade Landscape. 86 . 2.6. Transport Strategy. 86 . 2.7. New Release Rollout Strategy Challenges. 97 . 2.8. Upgrade Rollout Strategy. 99 . 2.9. Database Strategy. 100 . 2.10. EDW and Global Rollup Strategies. 101 . 2.11. Report Strategy. 104 . 2.12. Support Package Strategy. 109 . 2.13. Authorization Strategy. 112 . 2.14. Conclusion. 114 3. Common SAP NetWeaver BW Implementation Mistakes. 115 . 3.1. Unclear Definition of Goals and Scope. 115 . 3.2. Over-Ambitious Scope. 120 . 3.3. Unrealistic Time Line. 123 . 3.4. Governance. 126 . 3.5. Communication Issues. 129 . 3.6. Ownership Issues. 131 . 3.7. Data Quality Issues. 133 . 3.8. Data Alignment Issues. 139 . 3.9. Data Realignment. 143 . 3.10. Performance Issues. 147 . 3.11. Technical and Infrastructure Issues. 153 . 3.12. Resource Issues. 155 . 3.13. Political Issues. 160 . 3.14. Over-Customization. 160 . 3.15. Meeting and Decision Paralysis. 167 . 3.16. Change Control and Change Management. 169 . 3.17. Analyze Organization User Groups Using Different Reporting Tools. 173 . 3.18. Conclusion. 174 4. Project Planning in SAP NetWeaver BW. 177 . 4.1. The Data Warehouse Lifecycle. 178 . 4.2. The Upgrade Lifecycle. 180 . 4.3. Project Charter. 191 . 4.4. Detail Scope Documentation. 192 . 4.5. Planning for Information Lifecycle Management. 196 . 4.6. Typical Roles Needed for an SAP NetWeaver BW Project. 197 . 4.7. Staffing a SAP NetWeaver BW Project. 207 . 4.8. Outsourcing and SAP NetWeaver BW. 215 . 4.9. SAP NetWeaver BW Interview Process. 217 . 4.10. Training Requirements. 222 . 4.11. Conclusion. 223 5. Gathering and Analyzing SAP NetWeaver BW Requirements. 225 . 5.1. Requirements Gathering. 226 . 5.2. Information Request Form. 232 . 5.3. Gathering a Report Inventory. 232 . 5.4. Functional Model Document. 234 . 5.5. SAP NetWeaver BW Key Figure or KPI Matrix. 243 . 5.6. Steps to Obtain SAP NetWeaver BW Star Schema Model from the KPI Matrix. 244 . 5.7. Budgeting or Estimating SAP NetWeaver BW Time Lines. 246 . 5.8. SAP NetWeaver BW Physical Model. 252 . 5.9. Business Content Evaluation. 255 . 5.10. Design Reviews. 261 . 5.11. Conclusion. 264 6. Sound SAP NetWeaver BW Development Strategies. 265 . 6.1. Extracting and Loading Data from SAP Source Systems. 266 . 6.2. Loading Data from Non-SAP Source Systems. 276 . 6.3. Extracting Data From the SAP NetWeaver BW System. 281 . 6.4. Loading and Transforming Data into SAP NetWeaver BW. 283 . 6.5. Appending or Changing Standard SAP NetWeaver BW Objects. 296 . 6.6. Data Modeling. 297 . 6.7. Designing Process Chains. 303 . 6.8. Issue Resolution and Issue Tracking. 303 . 6.9. Query Performance Analysis in SAP NetWeaver BW. 305 . 6.10. Conclusion. 318 7. Preparing for Go-Live and the Go-Live Process. 321 . 7.1. Data Model and System Review. 322 . 7.2. Documenting SAP NetWeaver BW Configuration. 324 . 7.3. SAP NetWeaver BW Document Management Tool. 328 . 7.4. SAP Solution Manager. 329 . 7.5. Transport Management in SAP NetWeaver BW. 330 . 7.6. Testing in SAP NetWeaver BW. 337 . 7.7. Organizational Change Management. 341 . 7.8. Cutover Planning. 343 . 7.9. Go-Live Checklist. 345 . 7.10. Run Initial Loads in SAP NetWeaver BW. 347 . 7.11. SAP Safeguarding Service for SAP NetWeaver BW Go-Live. 356 . 7.12. Conclusion. 356 8. After SAP NetWeaver BW Go-Live. 357 . 8.1. Post-Implementation Review. 357 . 8.2. Building a Production Support Center of Excellence (COE. 358 . 8.3. Transitioning from SAP NetWeaver BW Development to Production-Support COE. 360 . 8.4. Ongoing SAP NetWeaver BW Reconciliation and Validation. 365 . 8.5. Periodic Jobs to Run in an SAP NetWeaver BW Environment. 369 . 8.6. Develop an Ongoing SAP NetWeaver BW Support Package Strategy. 372 . 8.7. Retaining and Motivating Staff for Future Rollouts. 377 . 8.8. Prepare for Future Rollouts. 378 . 8.9. Conclusion. 378 9. Enhance Quality: The Six Sigma Way. 379 . 9.1. Introduction to Six Sigma. 379 . 9.2. Reasons to Implement Six Sigma in an SAP NetWeaver BW Project. 386 . 9.3. Phase 1: Define. 387 . 9.4. Phase 2: Measure. 390 . 9.5. Phase 3: Analyze. 393 . 9.6. Phase 4: Improve. 398 . 9.7. Conclusion. 399 10. Reporting and Analytics in an SAP NetWeaver BW Environment. 401 . 10.1. SAP + BusinessObjects. 401 . 10.2. SAP SAP NetWeaver BW Presentation Layer. 402 . 10.3. SAP BusinessObjects Installation Guides. 405 . 10.4. OLAP Universe Design Based on SAP NetWeaver BW. 407 . 10.5. Web Intelligence Report Design on Universe. 418 . 10.6. Query as a Web Service (QaaWS. 424 . 10.7. Xcelsius. 427 . 10.8. Microsoft Office Integration with Live Office. 432 . 10.9. Crystal Reports. 437 . 10.10. Information Discovery with Polestar. 439 . 10.11. Pioneer: The Best of the Both Worlds. 443 . 10.12. Other Tools Provided by SAP BusinessObjects. 445 . 10.13. Summary. 447 11. Epilogue. 449 . 11.1. Using this Book. 449 . 11.2. Common Issues and Challenges. 450 . 11.3. Important Things to Remember. 450 . 11.4. Conclusion. 452 . Appendices. 453 . A. Sample Project Plan. 455 . B. Important Checklists. 473 . C. Document Templates. 487 . D. Common Issues When Upgrading from SAP NetWeaver BW Version 3.x to NW 2004s. 505 . E. Sample SAP NetWeaver BW Naming Standards Document. 511 . F. SAP NetWeaver BW Integration Test Script. 515 . G. Bibliography. 519 . H. The Authors. 521 . Index. 523

229 mm

17.5 cm