... Acknowledgments ... 17§§... Introduction ... 21§§1 ... Planning and Consolidation at a Glance ... 37§§1.1 ... Planning Basics ... 38§§1.2 ... Consolidation Basics ... 41§§1.3 ... Summary ... 44§§PART I ... Standard SAP PBC ... 45§§2 ... The Fundamentals of Standard SAP BPC ... 47§§2.1 ... System Architecture ... 47§§2.2 ... Accessing the System ... 52§§2.3 ... SAP Business Planning and Consolidation System ... 60§§2.4 ... SAP BPC Starter Kit Information ... 77§§2.5 ... Summary ... 81§§3 ... Standard SAP BPC Architecture ... 83§§3.1 ... Terminology and Objects in SAP BPC ... 83§§3.2 ... Basic Data Modeling for SAP BPC ... 87§§3.3 ... Dimensions and Properties ... 100§§3.4 ... Creating a Dimension ... 105§§3.5 ... Developing Components of the Dimensions ... 126§§3.6 ... Models ... 138§§3.7 ... SAP BW Objects ... 147§§3.8 ... Summary ... 156§§4 ... Reporting in Standard SAP BPC ... 159§§4.1 ... Report Considerations ... 160§§4.2 ... Introducing the EPM Add-In ... 170§§4.3 ... Using the EPM Ribbon ... 187§§4.4 ... Using the EPM Add-In ... 245§§4.5 ... Excel Add-In Advanced Features ... 265§§4.6 ... PowerPoint and Word Documents in the EPM Add-In ... 270§§4.7 ... Summary ... 273§§5 ... Data Loading in Standard SAP BPC ... 275§§5.1 ... Basic Data Loading with SAP BPC ... 275§§5.2 ... Loading Data in SAP BW ... 293§§5.3 ... Loading Data from SAP BW to SAP BPC ... 307§§5.4 ... Loading Data from a Flat File to SAP BPC ... 340§§5.5 ... Using the Data Manager ... 355§§5.6 ... Uploading Currency Exchange Rates for SAP BPC ... 366§§5.7 ... Advanced Data Loading for SAP BW for SAP BPC ... 376§§5.8 ... Summary ... 392§§6 ... Forecasting, Planning, and Budgeting in Standard SAP BPC ... 395§§6.1 ... Basic Planning, Forecasting, and Budgeting ... 395§§6.2 ... Script Logic in SAP BPC ... 403§§6.3 ... Generic Planning Process ... 442§§6.4 ... Summary ... 455§§7 ... Consolidation in Standard SAP BPC ... 457§§7.1 ... Basic Consolidation ... 457§§7.2 ... Ownership Data and Elimination Methods ... 464§§7.3 ... Setting Up Journal Entries ... 473§§7.4 ... Setting Up and Executing Consolidation Tasks ... 477§§7.5 ... Setting Up Balancing Script Logic for Consolidation ... 532§§7.6 ... Setting Up and Executing Equity Pick Up ... 536§§7.7 ... The Consolidation Monitor ... 543§§7.8 ... Summary ... 548§§8 ... Managing the Standard SAP BPC Process ... 549§§8.1 ... Security ... 549§§8.2 ... Work Status ... 564§§8.3 ... Controls ... 571§§8.4 ... System Reporting ... 580§§8.5 ... Transports ... 596§§8.6 ... Summary ... 605§§PART II ... Embedded SAP BPC ... 607§§9 ... The Fundamentals of Embedded SAP BPC ... 609§§9.1 ... The Evolution of SAP BPC ... 609§§9.2 ... A Primer on SAP HANA ... 618§§9.3 ... Comparing Standard and Embedded Features ... 624§§9.4 ... Strategy for Conversion ... 631§§9.5 ... Deployment Options ... 636§§9.6 ... Summary ... 638§§10 ... Embedded SAP BPC Architecture ... 639§§10.1 ... Setting Up the Embedded Planning Model ... 639§§10.2 ... Using MultiProviders ... 670§§10.3 ... Using Composite Providers ... 677§§10.4 ... Using DataStore Objects ... 678§§10.5 ... Using Local Providers ... 684§§10.6 ... Summary ... 690§§11 ... Reporting with Embedded SAP BPC ... 693§§11.1 ... System Architecture Review ... 694§§11.2 ... Web Client Reporting ... 695§§11.3 ... EPM Add-In in the Embedded Model ... 702§§11.4 ... Comparing the EPM Add-In for Standard and Embedded ... 711§§11.5 ... EPM Add-In for SAP HANA Data ... 712§§11.6 ... SAP BusinessObjects Analysis, Edition for Microsoft Office ... 716§§11.7 ... Summary ... 720§§12 ... Forecasting, Planning, and Budgeting in Embedded SAP BPC ... 721§§12.1 ... Standard IP Planning Functions ... 722§§12.2 ... Executing Planning Functions from Excel ... 726§§12.3 ... Disaggregation and Inverse Formulas ... 730§§12.4 ... Planning Filters a