... Acknowledgments ... 19 ... Introduction ... 23 ... Target Audience ... 25 ... Chapter Breakdown ... 25 ... Summary ... 37 1 ... Planning and Consolidation at a Glance ... 39 1.1 ... Planning Basics ... 40 1.2 ... Consolidation Basics ... 43 1.3 ... Selecting Your SAP BPC Product ... 45 1.4 ... Summary ... 51 PART I ... Standard SAP BPC ... 53 2 ... The Fundamentals of Standard SAP BPC ... 55 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 ... Standard SAP BPC Architecture ... 89 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 ... Reporting in Standard SAP BPC ... 159 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 ... Data Loading in Standard SAP BPC ... 267 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 ... Forecasting, Planning, and Budgeting in Standard SAP BPC ... 375 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 ... Consolidation in Standard SAP BPC ... 433 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 ... Managing the Standard SAP BPC Process ... 523 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 PART II ... Embedded SAP BPC ... 583 9 ... The Fundamentals of Embedded SAP BPC ... 585 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 ... Embedded SAP BPC Architecture ... 615 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 ... Reporting with Embedded SAP BPC ... 669 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 ... Forecasting, Planning, and Budgeting in Embedded SAP BPC ... 705 12.1 ... Standard IP Planning Functions ... 706 12.2 .. ukryj opis