Is your SAP BPC implementation looming large, or in need of a few tweaks? This book is your comprehensive guide to setting up standard and embedded SAP BPC. For each system, get step-by-step instructions for loading data into and reporting with SAP BPC. Learn about planning, budgeting, and forecasting, and dive into consolidation, from setting up journal entries to using the Consolidation Monitor. See how to migrate to SAP BPC 10.1 to stay on the cutting edge of SAP BPC!Highlights Include: -Standard and embedded SAP BPC-Reporting-Data loading-Forecasting, planning, and budgeting-Consolidation-SAP HANA-SAP BW/4HANA-Data Manager-Migration-Security

Peter Jones is a senior SAP BusinessObjects BI/SAP BPC application consultant with MI6 Solutions LLC specializing in the areas of CO (Controlling), Enterprise Controlling (EC), Business Intelligence/Business Objects (BI/BOBJ), SAP Strategic Enterprise Management (SAP SEM), SAP HANA, and SAP Business Planning and Consolidation (SAP BPC). He has over twenty years of consulting and educational experience in a variety of strategic and leadership roles, focused on global architecture and strategies for SAP BusinessObjects BI, SAP ERP, and SAP BPC. Peter's diverse professional background includes consulting and academic experience in the areas of finance, controlling, data warehousing, enterprise management, and corporate governance. He has been involved with numerous implementations for SAP in the areas of CO, SAP SEM, SAP BusinessObjects BI (7.0 through 7.5), SAP BPC (standard and embedded versions, 7.5 through 10.1), EPM, SAP HANA, and SAP ERP from the blueprint phase through to the go-live process. His responsibilities include all aspects from strategic SAP BusinessObjects BI/SAP BPC analysis to the core configuration in all areas. Peter has experience with many industry-specific cross application areas such as automotive, utilities, entertainment, consumer, banking, and public sector. Previous to his role at MI6 Solutions, he was a principal/platinum business application consultant with SAP Professional Services, specializing in all of the areas noted above. As a subject matter expert, Peter was involved in the review, configuration, and analysis for many projects with global and local requirements. He has completed work on the development of the course curriculum for CO, SAP SEM, SAP Business Warehouse (SAP BW), SAP BusinessObjects BI, SAP BPC, SAP APO and the Auditing Application for Sarbanes-Oxley Compliance. Peter has also developed and presented numerous topics for the University Alliance such as Data Mining, Enterprise Performance Management, Business Intelligence, and the Sarbanes-Oxley Act. A presenter at ASUG, SAPPHIRE, and BI conferences, Peter has spoken on the topics of CO, SOX, SAP SEM, and SAP BW. He is also an editor/writer for FICO Expert and BI Expert and has written several books on SAP BusinessObjects BI data modeling and reporting and FI/CO configuration for SAP. He has a BA and MBA from Drexel University in Finance and is SAP-certified in the areas of FI, CO, BI/BOBJ, SEM, and BPC. Prior to SAP he owned his own business for 15 years and worked in the area of accounting and finance.

... Target Audience ... 25 ... Chapter Breakdown ... 25 ... Summary ... 37 1.1 ... Planning Basics ... 40 1.2 ... Consolidation Basics ... 43 1.3 ... Selecting Your SAP BPC Product ... 45 1.4 ... Summary ... 51 2.1 ... System Architecture ... 55 2.2 ... Accessing the System ... 60 2.3 ... SAP BPC System ... 67 2.4 ... SAP BPC Starter Kit Information ... 84 2.5 ... Summary ... 88 3.1 ... Terminology and Objects in SAP BPC ... 89 3.2 ... Basic Data Modeling for SAP BPC ... 92 3.3 ... Dimensions and Properties ... 104 3.4 ... Creating a Dimension ... 108 3.5 ... Developing Components of the Dimensions ... 128 3.6 ... Models ... 139 3.7 ... SAP BW Objects ... 149 3.8 ... Summary ... 156 4.1 ... Reporting Basics ... 160 4.2 ... Introducing the EPM Add-In ... 170 4.3 ... Using the EPM Ribbon Tab ... 187 4.4 ... Using the EPM Add-In ... 238 4.5 ... Excel Add-In Advanced Features ... 257 4.6 ... PowerPoint and Word Documents in the EPM Add-In ... 263 4.7 ... Summary ... 265 5.1 ... Basic Data Loading with SAP BPC ... 267 5.2 ... Loading Data in SAP BW ... 283 5.3 ... Loading Data from SAP BW to SAP BPC ... 296 5.4 ... Loading Data from a Flat File to SAP BPC ... 327 5.5 ... Using the Data Manager ... 340 5.6 ... Uploading Currency Exchange Rates for SAP BPC ... 350 5.7 ... Advanced Data Loading for SAP BW for SAP BPC ... 359 5.8 ... Summary ... 373 6.1 ... Basic Forecasting, Planning, and Budgeting ... 375 6.2 ... Script Logic in SAP BPC ... 383 6.3 ... Generic Planning Process ... 419 6.4 ... Summary ... 431 7.1 ... Basic Consolidation ... 433 7.2 ... Ownership Data and Elimination Methods ... 440 7.3 ... Setting Up Journal Entries ... 449 7.4 ... Setting Up and Executing Consolidation Tasks ... 453 7.5 ... Setting Up Balancing Script Logic for Consolidation ... 506 7.6 ... Setting Up and Executing Equity Pickup ... 509 7.7 ... Consolidation Monitor ... 516 7.8 ... Summary ... 522 8.1 ... Security ... 523 8.2 ... Work Status ... 537 8.3 ... Controls ... 545 8.4 ... System Reporting ... 555 8.5 ... Transports ... 571 8.6 ... Summary ... 580 9.1 ... The Evolution of SAP BPC ... 585 9.2 ... A Primer on SAP HANA ... 594 9.3 ... Comparing Standard and Embedded Features ... 599 9.4 ... Strategy for Conversion ... 606 9.5 ... Deployment Options ... 612 9.6 ... Summary ... 613 10.1 ... Setting Up the Embedded Planning Model ... 616 10.2 ... Using MultiProviders ... 646 10.3 ... Using CompositeProviders ... 653 10.4 ... Using DataStore Objects ... 654 10.5 ... Using Local Providers ... 660 10.6 ... Summary ... 667 11.1 ... System Architecture Review ... 669 11.2 ... Web Client Reporting ... 671 11.3 ... EPM Add-In in the Embedded Model ... 678 11.4 ... Comparing the EPM Add-In for Standard and Embedded SAP BPC ... 687 11.5 ... EPM Add-In for SAP HANA Data ... 688 11.6 ... SAP Analysis for Microsoft Office ... 692 11.7 ... Using SAP Lumira with Embedded SAP BPC ... 696 11.8 ... Summary ... 703 12.1 ... Standard IP Planning Functions ... 706 12.2 ... Executing Planning Functions from Excel ... 710 12.3 ... Disaggregation and Inverse Formulas ... 714 12.4 ... Planning Filters and Planning Sequences ... 720 12.5 ... FOX Formulas ... 725 12.6 ... Characteristic Relationships ... 733 12.7 ... Advanced Planning Functions ... 738 12.8 ... Summary ... 761 13.1 ... Basics for Consolidation in Embedded SAP BPC ... 764 13.2 ... Data Loading Process for Embedded Consolidation ... 779 13.3 ... Summary ... 784 14.1 ... Embedded Consolidation Configuration ... 787 14.2 ... Introduction to Business Rules ... 806 14.3 ... Ownership Data and Elimination Methods ... 808 14.4 ... Setting Up and Executing Consolidation Tasks ... 818 14.5 ... Summary ... 865 15.1 ... Security ... 867 15.2 ... Work Status ... 882 15.3 ... Data Audit ... 891 15.4 ... Transports ... 899 15.5 ... Summary ... 903 16.1 ... SAP BPC 10.0 to Standard SAP BPC 10.1 ... 907 16.2 ... Integration Planning to Embedded SAP BPC 10.1 ... 909 16.3 ... SAP BPC 10.0 to Embedded SAP BPC ... 910 16.4 ... SAP BPC 10.0 to Mixed Standard/Embedded SAP BPC 10.1 ... 911 16.5 ... Summary ... 911 A ... Real-Time Consolidation ... 913 B ... The Authors ... 949