... 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 ..