SAP Business Planning and Consolidation

Foreword ... 13
Acknowledgments ... 19
Introduction ... 21
1. Overview of SAP Enterprise Performance Management ... 27

1.1 ... Enterprise Performance Management ... 27

1.2 ... Planning, Budgeting, and Forecasting ... 32

1.3 ... Consolidation ... 42

1.4 ... Summary ... 45

2. Overview of SAP BPC ... 47

2.1 ... SAP BPC: Business User-Owned and Managed ... 48

2.2 ... Unified Planning and Consolidation ... 55

2.3 ... SAP BPC for NetWeaver Architecture ... 59

2.4 ... Introducing SAP NetWeaver BW ... 62

2.5 ... Terminology and Objects in SAP BPC ... 70

2.6 ... Summary ... 76

3. Designing a Model with SAP BPC for NetWeaver ... 77

3.1 ... Rich Bloom Case Study ... 77

3.2 ... Building the Data Model in SAP NetWeaver BW ... 81

3.3 ... Building Models in SAP BPC ... 101

3.4 ... Summary ... 133

4. Loading, Scheduling, and Managing Data in SAP BPC for NetWeaver ... 135

4.1 ... Loading Data into an InfoCube in SAP NetWeaver BW ... 136

4.2 ... Loading Data into SAP BPC ... 149

4.3 ... Copying Data Inside an SAP BPC Model ... 198

4.4 ... Summary ... 201

5. Reporting, Planning, and Analysis in SAP BPC ... 203

5.1 ... Reporting and Analysis in SAP BPC ... 204

5.2 ... Planning in SAP BPC Using Input Forms ... 255

5.3 ... Other Features ... 261

5.4 ... Summary ... 262

6. Developing Business Logic in SAP BPC ... 263

6.1 ... Dimension Logic ... 264

6.2 ... Logic Script ... 270

6.3 ... Business Rules Overview ... 291

6.4 ... Currency Translation ... 294

6.5 ... Allocations ... 305

6.6 ... Using BAdIs to Code Logic ... 309

6.7 ... Validation ... 312

6.8 ... Controls ... 317

6.9 ... Summary ... 318

7. Process Management and Collaboration ... 319

7.1 ... Work Status ... 320

7.2 ... Comments ... 327

7.3 ... Distribution and Collection ... 337

7.4 ... Book Publishing ... 350

7.5 ... Integrating SAP BPC Data into Word and PowerPoint ... 361

7.6 ... Summary ...

Kumar Srinivasan is a senior business intelligence/SAP business planning and consolidation consultant for Zebra Consulting, Inc., in Houston, Texas. He holds a master's degree in finance from Loyola College in Chennai, India. He is also a certified cost accountant.Kumar has almost two decades of experience in information technology and has been working with SAP products since 1999. He is certified by SAP AG for the SAP BusinessObjects Business Intelligence and SAP Business Planning and Consolidation (BPC) products. Kumar has expertise providing solutions in the areas of SAP NetWeaver Business Warehouse (BW), SAP Business Planning and Simulation (BPS), SAP BI Integrated Planning (BI-IP), and SAP BPC. He provides diverse solutions to clients in areas that cover both back-end configuration and development of front-end user interfaces. His articles on topics related to SAP NetWeaver BW and BPC have been published in "BWExpert."Before working with Zebra Consulting, Inc., Kumar was employed with The World Bank as an information officer. During this time, he worked with relational database management systems, including Ingress, Informix, and Oracle. He also has extensive experience in the development of applications using messaging tools such as Lotus Notes.Kumar lives with his family in Cary, North Carolina. He can be reached at kshrini77@yahoo.com.