- Gebundenes Buch
- Merkliste
- Auf die Merkliste
- Bewerten Bewerten
- Teilen
- Produkt teilen
- Produkterinnerung
- Produkterinnerung
With this practical guide you ll find a clear and easy-to-follow path for an efficient SAP BW implementation or upgrade. The book begins by defining a typical NetWeaver BW project lifecycle, and then progresses to teach you the proper project management and upgrade strategies, including understanding common mistakes, resource requirements, and project planning and development. Topics are presented and flow together in a linear, intuitive, project based scenario, to help you navigate through pre-project considerations, actual project guidance, as well as the Go-Live and Post-Live monitoring and…mehr
With this practical guide you ll find a clear and easy-to-follow path for an efficient SAP BW implementation or upgrade. The book begins by defining a typical NetWeaver BW project lifecycle, and then progresses to teach you the proper project management and upgrade strategies, including understanding common mistakes, resource requirements, and project planning and development. Topics are presented and flow together in a linear, intuitive, project based scenario, to help you navigate through pre-project considerations, actual project guidance, as well as the Go-Live and Post-Live monitoring and maintenance considerations.
The book addresses the technical and functional upgrades introduced with BW 7.0, as well as new considerations for coordinating and using the front-end BusinessObjects tools.
The book addresses the technical and functional upgrades introduced with BW 7.0, as well as new considerations for coordinating and using the front-end BusinessObjects tools.
Produktdetails
- Produktdetails
- SAP Press
- Verlag: Rheinwerk Verlag
- 2. Aufl.
- Seitenzahl: 532
- Erscheinungstermin: Juni 2010
- Englisch
- Abmessung: 690mm x 90mm
- Gewicht: 964g
- ISBN-13: 9781592293360
- ISBN-10: 1592293360
- Artikelnr.: 28246503
- Herstellerkennzeichnung Die Herstellerinformationen sind derzeit nicht verfügbar.
- SAP Press
- Verlag: Rheinwerk Verlag
- 2. Aufl.
- Seitenzahl: 532
- Erscheinungstermin: Juni 2010
- Englisch
- Abmessung: 690mm x 90mm
- Gewicht: 964g
- ISBN-13: 9781592293360
- ISBN-10: 1592293360
- Artikelnr.: 28246503
- Herstellerkennzeichnung Die Herstellerinformationen sind derzeit nicht verfügbar.
Nolan, Gary
Gary Nolan is a Platinum BW Consultant, and has worked with BW since version 1.2B. He is also a technical editor and a regular author for the BW Expert and SCM Expert newsletters. A frequent speaker at numerous Sapphire, ASUG, and BW Portals Conferences, Gary has consulted at more than 40 BW client sites and has worked with them from the planning phase through post-implementation support.
Khaitan, Debasish
Debasish Khaitan is an experienced BI/BW consultant currently working for Capgemini. He has more than 4 years of experience working in SAP BW design and development. He re-ceived the SAP BW 3.5 certification and has played an integral role in several SAP BW end-to-end implementation projects. He is an SAP BW trainer and has conducted several training sessions. He's currently writing an article in SDN on SAP BW. He hosts a personal blog site: (www.saphelp.dkhaitan.com) which focuses on SAP BW related articles.
Gary Nolan is a Platinum BW Consultant, and has worked with BW since version 1.2B. He is also a technical editor and a regular author for the BW Expert and SCM Expert newsletters. A frequent speaker at numerous Sapphire, ASUG, and BW Portals Conferences, Gary has consulted at more than 40 BW client sites and has worked with them from the planning phase through post-implementation support.
Khaitan, Debasish
Debasish Khaitan is an experienced BI/BW consultant currently working for Capgemini. He has more than 4 years of experience working in SAP BW design and development. He re-ceived the SAP BW 3.5 certification and has played an integral role in several SAP BW end-to-end implementation projects. He is an SAP BW trainer and has conducted several training sessions. He's currently writing an article in SDN on SAP BW. He hosts a personal blog site: (www.saphelp.dkhaitan.com) which focuses on SAP BW related articles.
... 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 LoadingIntroduction
1 The BW Project Lifecycle
Summary: Provides an explanation of a typical BW project lifestyle and highlights the key considerations for each step in the cycle.
1.1 ECC vs. BW Implementations
1.2 BW from A-Z
1.3 External Data: What is the Big Deal?
1.4 Build for the Present, Keep an Eye on the Future
1.5 Dirty Data
1.6 Can't BW Just Clean the Data?
1.7 Understanding BW
1.8 Reasons for Implementing SAP BW
1.9 Why Not Another Data Warehouse?
1.10 What BW is Not Designed to Do
1.11 Ingredients for a Successful SAP BW Project Manager
(New: Different Quality Matrices a Manager Should Know)
1.12 Summary
2 Defining an Upgrade Strategy
Summary: Offers a definition of proven upgrade strategy, including technical landscape, database issues, authorization strategy etc.
2.1 Defining an Upgrade Strategy
2.2 Upgrade Landscape
2.3 Transport Strategy
2.4 New Release Rollout Strategy Challenges
2.5 Upgrade Rollout Strategy
2.6 Database Strategy
2.7 Enterprise Data Warehouse and Global Rollup Strategies
2.8 Choosing Right Data Target for Data Load and Reporting
2.9 When to Choose Which Data Target
2.10 Data base table administration
2.11 Authorization Strategy
2.12 Web Template
2.13 Focus on Roles strategy
2.14 Conclusion
3 Common BW Implementation Mistakes
Summary: Covers common mistakes made during BE implementation projects and offers guidance on how to avoid making the same mistakes.
3.1 Unclear Definition of Goals/Scope
3.2 Over-Ambitious Scope
3.3 Unrealistic Timeline
3.4 Governance
3.5 Communication Issues
3.6 Ownership Issues
3.7 Data Quality Issues
3.8 Data Alignment Issues
3.9 Data Realignment
3.10 Performance Issues
3.11 Technical and Infrastructure Issues
3.12 Resource Issues
3.13 Political Issues
3.14 Over-Customization
3.15 Meeting and Decision Paralysis
3.16 Change-Control and Change-Management
3.17: Information Consumers
3.18 Conclusion
4 Project Planning in BW
Summary: Examines the key components of a successful BW project plan.
4.1 The Data Warehouse Lifecycle
4.2 The Upgrade Lifecycle
4.3 Scope Documentation
4.4 Typical Roles Needed for a BW Project
4.5 Staffing a BW Project
4.6 Outsourcing and BW
4.7 BW Interview Process
4.8 Training Requirements
4.9 Upgrade Strategy for Multi Region BW System
4.10 Conclusion
5 Gathering and Analyzing BW Requirements
Summary: Provides a detailed and comprehensive look at BW project resource requirements.
5.1 Requirements Gathering
5.2 Gathering a Report Inventory
5.3 Functional Model Document
5.4 BW Key Figure or KPI Matrix
5.5 Budgeting or Estimating BW Timelines
5.6 BW Physical Model
5.7 Business Content Evaluation
5.8 Design Reviews
5.9 Focus on Documentation requirement.
5.10 Conclusion
6 Sound BW Development Strategies
Summary: Outlines the technical development and build strategy that will allow data to start flowing into the BW system.
6.1 Extracting and Loading Data from SAP Source Systems
6.2 Loading Data from Non-SAP Source Systems
6.3 Extracting Data From the BW System
6.4 Loading and Transforming Data into BW
6.5 Appending or Changing Standard BW Objects
6.6 Data Modeling
6.7 Issue Resolution and Issue Tracking
6.8 Query Performance Analysis in BW
6.9 Conclusion
7 Preparing for Go-Live and the Go-Live Process
Summary: Outlines the BW review process after the system has been developed and built to ensure all technical and resource issues have been accounted for before the system is put into service.
7.1 Data Model and System Review
7.2 Documenting BW Configuration
7.3 Transport Management in BW
7.4 Testing in BW
7.5 Organizational Change Management
7.6 Cutover Planning
7.7 Go-Live Checklist
7.8 Run Initial Loads in BW
7.9 Focus on Final Pre-Go-Live Check List Inspection
7.10 Go-Live Flow Chart
7.11 Ho 8 After BW Go-Live
Summary: Provides an outline of everything the project team needs to know and do after the BW systems has been deployed and is being used.
8.1 Building a Production Support Center of Excellence (COE)
8.2 Transitioning from BW Development to Production-Support COE
8.3 Ongoing BW Reconciliation and Validation
8.4 Periodic Jobs to Run in a BW Environment
8.5 Develop an Ongoing BW Support Package Strategy
8.6 Retaining and Motivating Staff for Future Rollouts
8.7 Prepare for Future Rollouts
8.8 Ticket Handling Strategies, SLA Compliance
8.8 Conclusion
Chapter 9: Enhance Data Quality: The Six Sigma Way
Summary: Focuses on the Six Sigma methodologies for SAP BW projects, which help to diagnose, fix and control BW data quality related issues.
9.1 What is Six Sigma
9.2 Six Sigma Methodology
9.2 Diagnosing Data Quality in 100+ User Environments
9.3 Fixing Data Quality Issues
9.4 Monitoring and Maintaining Data Quality
9.6 Conclusion
10 Reporting and Analytics in a BW Environment
Summary: Offers a primer on configuring and using the BusinessObjects and BEx tools for business intelligence against the BW system.
10.1 Common Integration Scenarios
10.2 BusinessObjects vs. BEx
10.3 Creating the Architecture
10.4 Creating a Universe
10.5 Creating RapidMarts
10.6 Reporting
10.7 Drill-down Analytics
10.8 Planning
10.9 Consolidations
10.10 Dashboards
10.11 Performance management
10.12 Conclusion
Appendix
A: Sample Project Plan
B: Important Checklists
C: Document Templates
D: Common Issues When Upgrading from BW Version 3.x to NW 2004s
E: Sample BW Naming Standards Document
F: BW Integration Test Script
G: Bibliography
... 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 LoadingIntroduction
1 The BW Project Lifecycle
Summary: Provides an explanation of a typical BW project lifestyle and highlights the key considerations for each step in the cycle.
1.1 ECC vs. BW Implementations
1.2 BW from A-Z
1.3 External Data: What is the Big Deal?
1.4 Build for the Present, Keep an Eye on the Future
1.5 Dirty Data
1.6 Can't BW Just Clean the Data?
1.7 Understanding BW
1.8 Reasons for Implementing SAP BW
1.9 Why Not Another Data Warehouse?
1.10 What BW is Not Designed to Do
1.11 Ingredients for a Successful SAP BW Project Manager
(New: Different Quality Matrices a Manager Should Know)
1.12 Summary
2 Defining an Upgrade Strategy
Summary: Offers a definition of proven upgrade strategy, including technical landscape, database issues, authorization strategy etc.
2.1 Defining an Upgrade Strategy
2.2 Upgrade Landscape
2.3 Transport Strategy
2.4 New Release Rollout Strategy Challenges
2.5 Upgrade Rollout Strategy
2.6 Database Strategy
2.7 Enterprise Data Warehouse and Global Rollup Strategies
2.8 Choosing Right Data Target for Data Load and Reporting
2.9 When to Choose Which Data Target
2.10 Data base table administration
2.11 Authorization Strategy
2.12 Web Template
2.13 Focus on Roles strategy
2.14 Conclusion
3 Common BW Implementation Mistakes
Summary: Covers common mistakes made during BE implementation projects and offers guidance on how to avoid making the same mistakes.
3.1 Unclear Definition of Goals/Scope
3.2 Over-Ambitious Scope
3.3 Unrealistic Timeline
3.4 Governance
3.5 Communication Issues
3.6 Ownership Issues
3.7 Data Quality Issues
3.8 Data Alignment Issues
3.9 Data Realignment
3.10 Performance Issues
3.11 Technical and Infrastructure Issues
3.12 Resource Issues
3.13 Political Issues
3.14 Over-Customization
3.15 Meeting and Decision Paralysis
3.16 Change-Control and Change-Management
3.17: Information Consumers
3.18 Conclusion
4 Project Planning in BW
Summary: Examines the key components of a successful BW project plan.
4.1 The Data Warehouse Lifecycle
4.2 The Upgrade Lifecycle
4.3 Scope Documentation
4.4 Typical Roles Needed for a BW Project
4.5 Staffing a BW Project
4.6 Outsourcing and BW
4.7 BW Interview Process
4.8 Training Requirements
4.9 Upgrade Strategy for Multi Region BW System
4.10 Conclusion
5 Gathering and Analyzing BW Requirements
Summary: Provides a detailed and comprehensive look at BW project resource requirements.
5.1 Requirements Gathering
5.2 Gathering a Report Inventory
5.3 Functional Model Document
5.4 BW Key Figure or KPI Matrix
5.5 Budgeting or Estimating BW Timelines
5.6 BW Physical Model
5.7 Business Content Evaluation
5.8 Design Reviews
5.9 Focus on Documentation requirement.
5.10 Conclusion
6 Sound BW Development Strategies
Summary: Outlines the technical development and build strategy that will allow data to start flowing into the BW system.
6.1 Extracting and Loading Data from SAP Source Systems
6.2 Loading Data from Non-SAP Source Systems
6.3 Extracting Data From the BW System
6.4 Loading and Transforming Data into BW
6.5 Appending or Changing Standard BW Objects
6.6 Data Modeling
6.7 Issue Resolution and Issue Tracking
6.8 Query Performance Analysis in BW
6.9 Conclusion
7 Preparing for Go-Live and the Go-Live Process
Summary: Outlines the BW review process after the system has been developed and built to ensure all technical and resource issues have been accounted for before the system is put into service.
7.1 Data Model and System Review
7.2 Documenting BW Configuration
7.3 Transport Management in BW
7.4 Testing in BW
7.5 Organizational Change Management
7.6 Cutover Planning
7.7 Go-Live Checklist
7.8 Run Initial Loads in BW
7.9 Focus on Final Pre-Go-Live Check List Inspection
7.10 Go-Live Flow Chart
7.11 Ho 8 After BW Go-Live
Summary: Provides an outline of everything the project team needs to know and do after the BW systems has been deployed and is being used.
8.1 Building a Production Support Center of Excellence (COE)
8.2 Transitioning from BW Development to Production-Support COE
8.3 Ongoing BW Reconciliation and Validation
8.4 Periodic Jobs to Run in a BW Environment
8.5 Develop an Ongoing BW Support Package Strategy
8.6 Retaining and Motivating Staff for Future Rollouts
8.7 Prepare for Future Rollouts
8.8 Ticket Handling Strategies, SLA Compliance
8.8 Conclusion
Chapter 9: Enhance Data Quality: The Six Sigma Way
Summary: Focuses on the Six Sigma methodologies for SAP BW projects, which help to diagnose, fix and control BW data quality related issues.
9.1 What is Six Sigma
9.2 Six Sigma Methodology
9.2 Diagnosing Data Quality in 100+ User Environments
9.3 Fixing Data Quality Issues
9.4 Monitoring and Maintaining Data Quality
9.6 Conclusion
10 Reporting and Analytics in a BW Environment
Summary: Offers a primer on configuring and using the BusinessObjects and BEx tools for business intelligence against the BW system.
10.1 Common Integration Scenarios
10.2 BusinessObjects vs. BEx
10.3 Creating the Architecture
10.4 Creating a Universe
10.5 Creating RapidMarts
10.6 Reporting
10.7 Drill-down Analytics
10.8 Planning
10.9 Consolidations
10.10 Dashboards
10.11 Performance management
10.12 Conclusion
Appendix
A: Sample Project Plan
B: Important Checklists
C: Document Templates
D: Common Issues When Upgrading from BW Version 3.x to NW 2004s
E: Sample BW Naming Standards Document
F: BW Integration Test Script
G: Bibliography
... 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 LoadingIntroduction
1 The BW Project Lifecycle
Summary: Provides an explanation of a typical BW project lifestyle and highlights the key considerations for each step in the cycle.
1.1 ECC vs. BW Implementations
1.2 BW from A-Z
1.3 External Data: What is the Big Deal?
1.4 Build for the Present, Keep an Eye on the Future
1.5 Dirty Data
1.6 Can't BW Just Clean the Data?
1.7 Understanding BW
1.8 Reasons for Implementing SAP BW
1.9 Why Not Another Data Warehouse?
1.10 What BW is Not Designed to Do
1.11 Ingredients for a Successful SAP BW Project Manager
(New: Different Quality Matrices a Manager Should Know)
1.12 Summary
2 Defining an Upgrade Strategy
Summary: Offers a definition of proven upgrade strategy, including technical landscape, database issues, authorization strategy etc.
2.1 Defining an Upgrade Strategy
2.2 Upgrade Landscape
2.3 Transport Strategy
2.4 New Release Rollout Strategy Challenges
2.5 Upgrade Rollout Strategy
2.6 Database Strategy
2.7 Enterprise Data Warehouse and Global Rollup Strategies
2.8 Choosing Right Data Target for Data Load and Reporting
2.9 When to Choose Which Data Target
2.10 Data base table administration
2.11 Authorization Strategy
2.12 Web Template
2.13 Focus on Roles strategy
2.14 Conclusion
3 Common BW Implementation Mistakes
Summary: Covers common mistakes made during BE implementation projects and offers guidance on how to avoid making the same mistakes.
3.1 Unclear Definition of Goals/Scope
3.2 Over-Ambitious Scope
3.3 Unrealistic Timeline
3.4 Governance
3.5 Communication Issues
3.6 Ownership Issues
3.7 Data Quality Issues
3.8 Data Alignment Issues
3.9 Data Realignment
3.10 Performance Issues
3.11 Technical and Infrastructure Issues
3.12 Resource Issues
3.13 Political Issues
3.14 Over-Customization
3.15 Meeting and Decision Paralysis
3.16 Change-Control and Change-Management
3.17: Information Consumers
3.18 Conclusion
4 Project Planning in BW
Summary: Examines the key components of a successful BW project plan.
4.1 The Data Warehouse Lifecycle
4.2 The Upgrade Lifecycle
4.3 Scope Documentation
4.4 Typical Roles Needed for a BW Project
4.5 Staffing a BW Project
4.6 Outsourcing and BW
4.7 BW Interview Process
4.8 Training Requirements
4.9 Upgrade Strategy for Multi Region BW System
4.10 Conclusion
5 Gathering and Analyzing BW Requirements
Summary: Provides a detailed and comprehensive look at BW project resource requirements.
5.1 Requirements Gathering
5.2 Gathering a Report Inventory
5.3 Functional Model Document
5.4 BW Key Figure or KPI Matrix
5.5 Budgeting or Estimating BW Timelines
5.6 BW Physical Model
5.7 Business Content Evaluation
5.8 Design Reviews
5.9 Focus on Documentation requirement.
5.10 Conclusion
6 Sound BW Development Strategies
Summary: Outlines the technical development and build strategy that will allow data to start flowing into the BW system.
6.1 Extracting and Loading Data from SAP Source Systems
6.2 Loading Data from Non-SAP Source Systems
6.3 Extracting Data From the BW System
6.4 Loading and Transforming Data into BW
6.5 Appending or Changing Standard BW Objects
6.6 Data Modeling
6.7 Issue Resolution and Issue Tracking
6.8 Query Performance Analysis in BW
6.9 Conclusion
7 Preparing for Go-Live and the Go-Live Process
Summary: Outlines the BW review process after the system has been developed and built to ensure all technical and resource issues have been accounted for before the system is put into service.
7.1 Data Model and System Review
7.2 Documenting BW Configuration
7.3 Transport Management in BW
7.4 Testing in BW
7.5 Organizational Change Management
7.6 Cutover Planning
7.7 Go-Live Checklist
7.8 Run Initial Loads in BW
7.9 Focus on Final Pre-Go-Live Check List Inspection
7.10 Go-Live Flow Chart
7.11 Ho 8 After BW Go-Live
Summary: Provides an outline of everything the project team needs to know and do after the BW systems has been deployed and is being used.
8.1 Building a Production Support Center of Excellence (COE)
8.2 Transitioning from BW Development to Production-Support COE
8.3 Ongoing BW Reconciliation and Validation
8.4 Periodic Jobs to Run in a BW Environment
8.5 Develop an Ongoing BW Support Package Strategy
8.6 Retaining and Motivating Staff for Future Rollouts
8.7 Prepare for Future Rollouts
8.8 Ticket Handling Strategies, SLA Compliance
8.8 Conclusion
Chapter 9: Enhance Data Quality: The Six Sigma Way
Summary: Focuses on the Six Sigma methodologies for SAP BW projects, which help to diagnose, fix and control BW data quality related issues.
9.1 What is Six Sigma
9.2 Six Sigma Methodology
9.2 Diagnosing Data Quality in 100+ User Environments
9.3 Fixing Data Quality Issues
9.4 Monitoring and Maintaining Data Quality
9.6 Conclusion
10 Reporting and Analytics in a BW Environment
Summary: Offers a primer on configuring and using the BusinessObjects and BEx tools for business intelligence against the BW system.
10.1 Common Integration Scenarios
10.2 BusinessObjects vs. BEx
10.3 Creating the Architecture
10.4 Creating a Universe
10.5 Creating RapidMarts
10.6 Reporting
10.7 Drill-down Analytics
10.8 Planning
10.9 Consolidations
10.10 Dashboards
10.11 Performance management
10.12 Conclusion
Appendix
A: Sample Project Plan
B: Important Checklists
C: Document Templates
D: Common Issues When Upgrading from BW Version 3.x to NW 2004s
E: Sample BW Naming Standards Document
F: BW Integration Test Script
G: Bibliography
... 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 LoadingIntroduction
1 The BW Project Lifecycle
Summary: Provides an explanation of a typical BW project lifestyle and highlights the key considerations for each step in the cycle.
1.1 ECC vs. BW Implementations
1.2 BW from A-Z
1.3 External Data: What is the Big Deal?
1.4 Build for the Present, Keep an Eye on the Future
1.5 Dirty Data
1.6 Can't BW Just Clean the Data?
1.7 Understanding BW
1.8 Reasons for Implementing SAP BW
1.9 Why Not Another Data Warehouse?
1.10 What BW is Not Designed to Do
1.11 Ingredients for a Successful SAP BW Project Manager
(New: Different Quality Matrices a Manager Should Know)
1.12 Summary
2 Defining an Upgrade Strategy
Summary: Offers a definition of proven upgrade strategy, including technical landscape, database issues, authorization strategy etc.
2.1 Defining an Upgrade Strategy
2.2 Upgrade Landscape
2.3 Transport Strategy
2.4 New Release Rollout Strategy Challenges
2.5 Upgrade Rollout Strategy
2.6 Database Strategy
2.7 Enterprise Data Warehouse and Global Rollup Strategies
2.8 Choosing Right Data Target for Data Load and Reporting
2.9 When to Choose Which Data Target
2.10 Data base table administration
2.11 Authorization Strategy
2.12 Web Template
2.13 Focus on Roles strategy
2.14 Conclusion
3 Common BW Implementation Mistakes
Summary: Covers common mistakes made during BE implementation projects and offers guidance on how to avoid making the same mistakes.
3.1 Unclear Definition of Goals/Scope
3.2 Over-Ambitious Scope
3.3 Unrealistic Timeline
3.4 Governance
3.5 Communication Issues
3.6 Ownership Issues
3.7 Data Quality Issues
3.8 Data Alignment Issues
3.9 Data Realignment
3.10 Performance Issues
3.11 Technical and Infrastructure Issues
3.12 Resource Issues
3.13 Political Issues
3.14 Over-Customization
3.15 Meeting and Decision Paralysis
3.16 Change-Control and Change-Management
3.17: Information Consumers
3.18 Conclusion
4 Project Planning in BW
Summary: Examines the key components of a successful BW project plan.
4.1 The Data Warehouse Lifecycle
4.2 The Upgrade Lifecycle
4.3 Scope Documentation
4.4 Typical Roles Needed for a BW Project
4.5 Staffing a BW Project
4.6 Outsourcing and BW
4.7 BW Interview Process
4.8 Training Requirements
4.9 Upgrade Strategy for Multi Region BW System
4.10 Conclusion
5 Gathering and Analyzing BW Requirements
Summary: Provides a detailed and comprehensive look at BW project resource requirements.
5.1 Requirements Gathering
5.2 Gathering a Report Inventory
5.3 Functional Model Document
5.4 BW Key Figure or KPI Matrix
5.5 Budgeting or Estimating BW Timelines
5.6 BW Physical Model
5.7 Business Content Evaluation
5.8 Design Reviews
5.9 Focus on Documentation requirement.
5.10 Conclusion
6 Sound BW Development Strategies
Summary: Outlines the technical development and build strategy that will allow data to start flowing into the BW system.
6.1 Extracting and Loading Data from SAP Source Systems
6.2 Loading Data from Non-SAP Source Systems
6.3 Extracting Data From the BW System
6.4 Loading and Transforming Data into BW
6.5 Appending or Changing Standard BW Objects
6.6 Data Modeling
6.7 Issue Resolution and Issue Tracking
6.8 Query Performance Analysis in BW
6.9 Conclusion
7 Preparing for Go-Live and the Go-Live Process
Summary: Outlines the BW review process after the system has been developed and built to ensure all technical and resource issues have been accounted for before the system is put into service.
7.1 Data Model and System Review
7.2 Documenting BW Configuration
7.3 Transport Management in BW
7.4 Testing in BW
7.5 Organizational Change Management
7.6 Cutover Planning
7.7 Go-Live Checklist
7.8 Run Initial Loads in BW
7.9 Focus on Final Pre-Go-Live Check List Inspection
7.10 Go-Live Flow Chart
7.11 Ho 8 After BW Go-Live
Summary: Provides an outline of everything the project team needs to know and do after the BW systems has been deployed and is being used.
8.1 Building a Production Support Center of Excellence (COE)
8.2 Transitioning from BW Development to Production-Support COE
8.3 Ongoing BW Reconciliation and Validation
8.4 Periodic Jobs to Run in a BW Environment
8.5 Develop an Ongoing BW Support Package Strategy
8.6 Retaining and Motivating Staff for Future Rollouts
8.7 Prepare for Future Rollouts
8.8 Ticket Handling Strategies, SLA Compliance
8.8 Conclusion
Chapter 9: Enhance Data Quality: The Six Sigma Way
Summary: Focuses on the Six Sigma methodologies for SAP BW projects, which help to diagnose, fix and control BW data quality related issues.
9.1 What is Six Sigma
9.2 Six Sigma Methodology
9.2 Diagnosing Data Quality in 100+ User Environments
9.3 Fixing Data Quality Issues
9.4 Monitoring and Maintaining Data Quality
9.6 Conclusion
10 Reporting and Analytics in a BW Environment
Summary: Offers a primer on configuring and using the BusinessObjects and BEx tools for business intelligence against the BW system.
10.1 Common Integration Scenarios
10.2 BusinessObjects vs. BEx
10.3 Creating the Architecture
10.4 Creating a Universe
10.5 Creating RapidMarts
10.6 Reporting
10.7 Drill-down Analytics
10.8 Planning
10.9 Consolidations
10.10 Dashboards
10.11 Performance management
10.12 Conclusion
Appendix
A: Sample Project Plan
B: Important Checklists
C: Document Templates
D: Common Issues When Upgrading from BW Version 3.x to NW 2004s
E: Sample BW Naming Standards Document
F: BW Integration Test Script
G: Bibliography