Implementing SAP Business Planning and Consolidation
Implement Standard and embedded SAP BPC. Facilitate fast and accurate reporting with expert tips. Set up consilidation: ownership, intercompany eliminations, Journal entries, and more
(Sprache: Englisch)
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....
Leider schon ausverkauft
versandkostenfrei
Buch (Gebunden)
92.50 €
- Lastschrift, Kreditkarte, Paypal, Rechnung
- Kostenlose Rücksendung
- Ratenzahlung möglich
Produktdetails
Produktinformationen zu „Implementing SAP Business Planning and Consolidation “
Klappentext zu „Implementing SAP Business Planning and Consolidation “
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
Inhaltsverzeichnis zu „Implementing SAP Business Planning and Consolidation “
... 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
... mehr
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 ... 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 ... Data Loading for Embedded Consolidation ... 763
13.1 ... Basics for Consolidation in Embedded SAP BPC ... 764
13.2 ... Data Loading Process for Embedded Consolidation ... 779
13.3 ... Summary ... 784
14 ... Consolidation in Embedded SAP BPC ... 787
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 ... Managing the Embedded SAP BPC Process ... 867
15.1 ... Security ... 867
15.2 ... Work Status ... 882
15.3 ... Data Audit ... 891
15.4 ... Transports ... 899
15.5 ... Summary ... 903
16 ... Migrating to SAP BPC 10.1 ... 905
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
... Appendices ... 913
A ... Real-Time Consolidation ... 913
B ... The Authors ... 949
... Index ... 951
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 ... 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 ... Data Loading for Embedded Consolidation ... 763
13.1 ... Basics for Consolidation in Embedded SAP BPC ... 764
13.2 ... Data Loading Process for Embedded Consolidation ... 779
13.3 ... Summary ... 784
14 ... Consolidation in Embedded SAP BPC ... 787
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 ... Managing the Embedded SAP BPC Process ... 867
15.1 ... Security ... 867
15.2 ... Work Status ... 882
15.3 ... Data Audit ... 891
15.4 ... Transports ... 899
15.5 ... Summary ... 903
16 ... Migrating to SAP BPC 10.1 ... 905
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
... Appendices ... 913
A ... Real-Time Consolidation ... 913
B ... The Authors ... 949
... Index ... 951
... weniger
Autoren-Porträt von Peter Jones, Charles Soper
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
... mehr
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. Soper, CharlesCharles (Tim) Soper is a senior SAP Educational Consultant and has been with SAP for over 19 years. His areas of expertise are FI, CO, SAP BusinessObjects BI, SAP Strategic Enterprise Management (SAP SEM), and SAP Business Planning and Consolidation (SAP BPC). He has been involved with the development of numerous courses, including CO, SAP BusinessObjects BI, SAP SEM, and SAP BPC and is a course owner for several of them. As an instructor, he has taught courses at all levels from novice to advanced workshops. He has been involved in a number of review and customer assignments in the SAP BusinessObjects BI and SAP BPC areas, for which he is a subject matter expert and is often requested to offer advice and expertise. Tim has written articles in the areas of SAP BusinessObjects BI and SAP BPC for the BI Expert and has been a contributing author on other books in the SAP BusinessObjects BI area.He has a BA and MBA from the University of Rochester in Finance and is SAP-certified in the areas of FI, CO, SAP BI, and BPC. Previous to SAP he worked for Eastman Kodak Company in various finance and accounting positions.
... weniger
Bibliographische Angaben
- Autoren: Peter Jones , Charles Soper
- 2018, 3rd upd. ed., 965 Seiten, Maße: 18,4 x 23,6 cm, Gebunden, Englisch
- Verlag: SAP Press
- ISBN-10: 1493216821
- ISBN-13: 9781493216826
- Erscheinungsdatum: 23.08.2018
Sprache:
Englisch
Kommentar zu "Implementing SAP Business Planning and Consolidation"
Schreiben Sie einen Kommentar zu "Implementing SAP Business Planning and Consolidation".
Kommentar verfassen