New Announcements and Updates




SAP Business Planning and Consolidation (3rd Edition)

Image 1
Click to enlarge
Price:
Starting From $69.99
Product Code:
H3280
Average Rating:
( 4 product reviews )
Availability:
In stock!
Format:
Quantity:

Write your own product review

Product Details

ISBN:
978-1-59229-445-9
Author:
Sridhar Srinivasan and Kumar Srinivasan
Type:
Hardcover, 497 pages
Year:
2013

Product Description and Table of Contents

 - A complete overview of SAP BPC solutions
- Master the features, functions, and integration of SAP BPC with other components and applications
- Updated and revised for SAP BPC 10.0
- 3rd Edition SAP NetWeaver Version

Explore how SAP BPC 10.0 can impact your organization. This updated and expanded edition gives you a comprehensive overview of the SAP BPC features, functions, and best practices. Referencing a detailed case study, find out how to use SAP BPC for NetWeaver for budget planning, forecasting, and consolidation—the building blocks of a complete planning and consolidation solution. Learn what to expect from a BPC application—and how to get it using SAP BPC 10.0.

Features and Functions
Discover how data management, process management, and reporting work in BPC.

Reporting and Analysis
Extensive coverage of the reporting and analysis framework will walk you through the steps and tools used to report, plan, and analyze data.

Best Practices Revealed
Incorporate best practices into your budget planning, forecasting, and consolidation using SAP BPC for NetWeaver.

Integration Basics
Learn how you can coordinate a comprehensive BPC solution by integrating with other SAP components.

Case Study
Follow the fictitious Rich Bloom, Inc. as it deploys SAP BPC for NetWeaver to improve its operational efficiency and create a robust planning system.


Highlights

-          SAP BPC for NetWeaver architecture

-          Loading, scheduling, and managing data

-          Process management and collaboration

-          Business process workflows

-          Consolidation

-          Business logic

-          Application building and modeling

-          Reporting, planning, and analysis

-          Business rules


The Authors

Sridhar Srinivasan and Kumar Srinivasan work for Zebra Consulting, Inc., in Houston,TX. They have several years of experience implementing solutions using SAP NetWeaver BW and SAP Business Planning and Consolidation products. They have also published another SAP PRESS book, SAP NetWeaver BI Integrated Planning for Finance.


Table of Contents

  • ... 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.2.1 ... Planning Horizon ... 33
  • 1.2.2 ... Planning Types ... 34
  • 1.2.3 ... Planning Areas ... 36
  • 1.2.4 ... Common Scenarios for Planning in Business ... 38
  • 1.2.5 ... Considerations in Planning ... 40
  • 1.3 ... Consolidation ... 42
  • 1.3.1 ... Elimination of Intercompany Transactions ... 43
  • 1.3.2 ... Consolidation of Investments ... 44
  • 1.4 ... Summary ... 45
  • 2 ... Overview of SAP BPC ... 47
  • 2.1 ... SAP BPC: Business User-Owned and Managed ... 48
  • 2.1.1 ... Software Designed to Support Change ... 48
  • 2.1.2 ... SAP BPC (Microsoft and SAP NetWeaver) ... 50
  • 2.1.3 ... SAP BPC for NetWeaver ... 54
  • 2.2 ... Unified Planning and Consolidation ... 55
  • 2.2.1 ... Planning in SAP BPC ... 56
  • 2.2.2 ... Consolidation in SAP BPC ... 56
  • 2.3 ... SAP BPC for NetWeaver Architecture ... 59
  • 2.3.1 ... BPC Clients ... 59
  • 2.3.2 ... Connectivity ... 60
  • 2.3.3 ... SAP NetWeaver Application Server ... 61
  • 2.3.4 ... Database Server ... 61
  • 2.4 ... Introducing SAP NetWeaver BW ... 62
  • 2.4.1 ... Objects Used in SAP NetWeaver BW ... 62
  • 2.4.2 ... Extracting, Transforming, and Loading Data in SAP NetWeaver BW ... 64
  • 2.4.3 ... Process Chains ... 67
  • 2.4.4 ... Business Content ... 67
  • 2.4.5 ... Key Features in SAP NetWeaver BW 7.3 ... 68
  • 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.1.1 ... Business ... 78
  • 3.1.2 ... Offices ... 78
  • 3.1.3 ... Products ... 78
  • 3.1.4 ... Currency ... 79
  • 3.1.5 ... Case Study ... 79
  • 3.1.6 ... Decision to Use SAP BPC for NetWeaver ... 80
  • 3.2 ... Building the Data Model in SAP NetWeaver BW ... 81
  • 3.2.1 ... Creating and Activating InfoObjects ... 84
  • 3.2.2 ... Creating an InfoArea ... 94
  • 3.2.3 ... Creating a Sales InfoCube ... 95
  • 3.3 ... Building Models in SAP BPC ... 101
  • 3.3.1 ... Accessing the SAP BPC System ... 103
  • 3.3.2 ... Environment ... 107
  • 3.3.3 ... Dimensions ... 113
  • 3.3.4 ... Model ... 123
  • 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.1.1 ... Creating a DataSource ... 136
  • 4.1.2 ... Creating Transformations ... 140
  • 4.1.3 ... Creating the Data Transfer Process ... 142
  • 4.1.4 ... Creating InfoPackages ... 144
  • 4.1.5 ... Loading Data from the PSA to the Data Target ... 147
  • 4.2 ... Loading Data into SAP BPC ... 149
  • 4.2.1 ... Transformation and Conversion ... 150
  • 4.2.2 ... Data Manager Packages ... 158
  • 4.2.3 ... Process Chains ... 165
  • 4.2.4 ... Loading Master Data from a Flat File into a Dimension ... 165
  • 4.2.5 ... Loading Master Data from an InfoObject into an SAP BPC Dimension ... 176
  • 4.2.6 ... Loading Hierarchy Data from an InfoObject into an SAP BPC Dimension ... 186
  • 4.2.7 ... Loading Data from an InfoCube into an SAP BPC Model ... 190
  • 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.1.1 ... SAP EPM Add-In Interface for Excel: Connecting to a Model ... 206
  • 5.1.2 ... Creating Reports ... 215
  • 5.1.3 ... Developing Reports Using Dynamic Templates ... 234
  • 5.1.4 ... Developing Reports Using EPM Functions ... 235
  • 5.1.5 ... Developing Reports Using the EPMRetrieveData Function ... 239
  • 5.1.6 ... Developing a Static EPM Report – Rolling Forecast Report ... 240
  • 5.1.7 ... Developing Customized Reports ... 245
  • 5.1.8 ... Quick Links ... 249
  • 5.1.9 ... Migrating 7.5 Version EvDRE Reports ... 250
  • 5.1.10 ... Developing Reports Using the New API for EPM ... 250
  • 5.1.11 ... Developing Reports Using the SAP BPC Web Client ... 252
  • 5.2 ... Planning in SAP BPC Using Input Forms ... 255
  • 5.2.1 ... Standard Templates for Input Forms ... 256
  • 5.2.2 ... Developing an Input Form ... 257
  • 5.2.3 ... Using the EPMSaveData Function to Save Data ... 260
  • 5.3 ... Other Features ... 261
  • 5.3.1 ... Drill-Through Feature ... 261
  • 5.3.2 ... Integration with SAP Business Objects Dashboards ... 261
  • 5.4 ... Summary ... 262
  • 6 ... Developing Business Logic in SAP BPC ... 263
  • 6.1 ... Dimension Logic ... 264
  • 6.1.1 ... Dimension Formulas ... 264
  • 6.1.2 ... Solve Order ... 265
  • 6.2 ... Logic Script ... 270
  • 6.2.1 ... Logic Script Construct ... 270
  • 6.2.2 ... Executing Logic Script ... 279
  • 6.2.3 ... Creating Logic Script to Revalue Plan Data ... 279
  • 6.2.4 ... Creating Logic Script to Push Data from the YTD to PERIODIC Models ... 289
  • 6.2.5 ... Logic Script Files Provided by SAP ... 290
  • 6.3 ... Business Rules Overview ... 291
  • 6.3.1 ... Currency Translation ... 291
  • 6.3.2 ... Carry Forward ... 292
  • 6.3.3 ... Account Transformation ... 292
  • 6.3.4 ... Intercompany Matching/Booking ... 292
  • 6.3.5 ... Intercompany Elimination ... 293
  • 6.3.6 ... Eliminations and Automatic Adjustments ... 293
  • 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.2.1 ... Adding Comments ... 328
  • 7.2.2 ... Viewing Comments ... 331
  • 7.2.3 ... Reporting on Comments ... 334
  • 7.2.4 ... EPM Functions for Comments ... 337
  • 7.3 ... Distribution and Collection ... 337
  • 7.3.1 ... Creating a Distribution Template ... 339
  • 7.3.2 ... Offline Distribution Wizard ... 344
  • 7.3.3 ... Collection ... 349
  • 7.4 ... Book Publishing ... 350
  • 7.4.1 ... Creating a Book Publishing Template ... 352
  • 7.4.2 ... Book Publication ... 356
  • 7.5 ... Integrating SAP BPC Data into Word and PowerPoint ... 361
  • 7.6 ... Summary ... 365
  • 8 ... Essential Tools for Building Models ... 367
  • 8.1 ... Transporting SAP BPC Objects ... 368
  • 8.2 ... Concurrency Locking ... 375
  • 8.2.1 ... Approaches to Locking ... 375
  • 8.2.2 ... Locking Features in SAP BPC for NetWeaver ... 375
  • 8.2.3 ... Locking Process in SAP BPC for NetWeaver ... 376
  • 8.3 ... Administration Parameters ... 380
  • 8.4 ... Statistics ... 387
  • 8.5 ... Audit ... 390
  • 8.6 ... Documents ... 393
  • 8.6.1 ... Accessing the Documents ... 393
  • 8.6.2 ... Posting a Document ... 393
  • 8.6.3 ... Editing Document Properties ... 394
  • 8.6.4 ... Add a Web Page to Documents ... 395
  • 8.7 ... Security ... 396
  • 8.7.1 ... Users ... 397
  • 8.7.2 ... Team ... 397
  • 8.7.3 ... Task Profile ... 397
  • 8.7.4 ... Data Access Profile ... 399
  • 8.7.5 ... Security Model ... 399
  • 8.8 ... Summary ... 400
  • 9 ... Consolidation with SAP BPC ... 401
  • 9.1 ... Steps in Consolidation ... 402
  • 9.2 ... Business Rules ... 403
  • 9.2.1 ... Carry Forward ... 404
  • 9.2.2 ... Account Transformation ... 413
  • 9.2.3 ... Intercompany Matching/Booking ... 417
  • 9.2.4 ... Intercompany Eliminations (U.S. Elimination) ... 424
  • 9.2.5 ... Controls ... 431
  • 9.3 ... Consolidation of Investments ... 441
  • 9.3.1 ... Purchase Method ... 441
  • 9.3.2 ... Equity Method ... 442
  • 9.3.3 ... Proportional Method ... 443
  • 9.3.4 ... Consolidation of Investments ... 444
  • 9.4 ... Intercompany Elimination—Eliminations and Adjustments Business Rule ... 464
  • 9.5 ... Journals ... 467
  • 9.5.1 ... Create Journal Template ... 469
  • 9.5.2 ... Manage Journals ... 471
  • 9.5.3 ... Journal BAdI ... 473
  • 9.6 ... Summary ... 474
  • 10 ... Business Process Flow and Enhancements ... 475
  • 10.1 ... Business Process Flow ... 475
  • 10.1.1 ... Creating a Business Process Flow Template ... 476
  • 10.1.2 ... Creating a Business Process Flow Instance ... 481
  • 10.1.3 ... Executing Activities ... 482
  • 10.1.4 ... Process Monitor ... 484
  • 10.2 ... New Features for SAP NetWeaver ... 485
  • 10.2.1 ... SAP HANA ... 485
  • 10.2.2 ... Firefox as Web Browser ... 485
  • 10.2.3 ... Drill-Through for Web Reports ... 485
  • 10.2.4 ... Disaggregate Data from Parent Node Cells Using BAdI ... 485
  • 10.2.5 ... Reporting on Archived Audit Data ... 486
  • 10.2.6 ... Defer Layout in a Web Report ... 486
  • 10.2.7 ... Export Web Report to CSV file ... 486
  • 10.2.8 ... Zero Suppression Option in a Web Report ... 486
  • 10.3 ... Conclusion ... 486
  • ... The Authors ... 489
  • ... Index ... 491


Additional Resource(s)


Download: Additional Web Content

Product Reviews


  1. Posted by Anonymous on May 7th, 2013

    Excellent book for beginners and good reference book for BPC experts .This book has covered most of the features about SAP EPM10-BPC and BW7.3

  2. Best of all the books on BPC so far..

    Posted by rohan on Feb 7th, 2013

    The book has been in-depth, thorough, covering almost everything one requires in SAP BPC. This could be used as reference, guide while implementing. And coming to the content , the books so far Ive found, seem to be complicating the already brain-teasing stuff like planning and consolidation, and this one in contrast is much clear , the best part being the solid explanation of modelling aspects of SAP BI. Finally, a very well written book or may be a complete reference on BPC.

  3. One of the best usedful book on BPC

    Posted by Anonymous on Jan 19th, 2013

    I read this BPC book as soon as I get it and feel it is very useful for in term of the detail explaination of how to connfigure the BPC,especially on the consolidation field,I highly recommend this book.

  4. Extremely informative and well sritten

    Posted by Kristo on Jan 18th, 2013

    This book keeps up its tradition of excellence in its third edition. This edition covers BPC 10 / NW version. The book is very comprehensive and steps you through important transactions in planning and consolidation areas that will be very helpful for beginners. This book could be used as a reference as well as a training guide. An excellent book deserving a place in your SAP book shelf.

Write your own product review
If you have purchased this book you can share your experience with others!
review guidelines

Find Similar Products by Category

Recently Viewed