Table of Contents

Open all
Close all
Acknowledgments
19
Introduction
23
Target Audience
25
Chapter Breakdown
25
Chapter 1: Planning and Consolidation at a Glance
25
Part I: Standard SAP BPC
26
Part II: Embedded SAP BPC
33
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.3.1 Standard SAP BPC
46
1.3.2 Embedded SAP BPC
48
1.3.3 SAP BW/4HANA and Real-Time Consolidation
49
1.4 Summary
51
PART I Standard SAP BPC
53
2 The Fundamentals of Standard SAP BPC
55
2.1 System Architecture
55
2.1.1 Microsoft Version
56
2.1.2 SAP NetWeaver Version
58
2.2 Accessing the System
60
2.3 SAP BPC System
67
2.3.1 Library Objects
69
2.3.2 Component Toolbar
69
2.3.3 Support Toolbar
73
2.3.4 Enterprise Performance Management Add-In
75
2.4 SAP BPC Starter Kit Information
84
2.4.1 IFRS Starter Kit
86
2.4.2 Other Starter Kits
87
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.2.1 Key Data Modeling Questions
93
3.2.2 EnvironmentShell
97
3.2.3 Configuration/Copy of the EnvironmentShell
101
3.3 Dimensions and Properties
104
3.3.1 Definition of Dimensions
104
3.3.2 Dimension Types
106
3.4 Creating a Dimension
108
3.4.1 Time Dimension
112
3.4.2 Category Dimension
113
3.4.3 Account Dimension
115
3.4.4 Entity Dimension
119
3.4.5 Intercompany Dimension
120
3.4.6 Subtable/Flow Dimension
121
3.4.7 DataSource/AuditTrail Dimension
122
3.4.8 Scope Dimension
123
3.4.9 Rptcurrency Dimension
125
3.4.10 Additional Dimensions and Properties
126
3.5 Developing Components of the Dimensions
128
3.5.1 Dimension Security
128
3.5.2 Hierarchies in Dimensions
129
3.5.3 Custom Measure Formulas
130
3.5.4 Dimension Member Formulas
133
3.5.5 Owner Properties
138
3.5.6 Reviewer Properties
139
3.6 Models
139
3.6.1 Model Types
140
3.6.2 Developing Models
142
3.7 SAP BW Objects
149
3.7.1 SAP BW Objects Support for SAP BPC for SAP NetWeaver
149
3.7.2 SAP BW/SAP BPC InfoObjects
153
3.7.3 SAP BW/SAP BPC InfoCubes
154
3.8 Summary
156
4 Reporting in Standard SAP BPC
159
4.1 Reporting Basics
160
4.1.1 Report Considerations
161
4.1.2 Creating a Web-Based Report
163
4.1.3 Standard EPM Reports and Templates
166
4.2 Introducing the EPM Add-In
170
4.2.1 Navigating in the EPM Add-In
176
4.2.2 Using the Context and Current Report Panes
179
4.2.3 Building a Basic Report
180
4.3 Using the EPM Ribbon Tab
187
4.3.1 Reports
188
4.3.2 Data Analysis
194
4.3.3 Undo
196
4.3.4 Data Input
196
4.3.5 Collaboration
205
4.3.6 Tools
217
4.4 Using the EPM Add-In
238
4.4.1 Report Editor and Report Selection
238
4.4.2 Local Members
246
4.4.3 Formatting of Reports
250
4.4.4 Multiple Reports in a Workbook
255
4.5 Excel Add-In Advanced Features
257
4.5.1 Asymmetric Reports
258
4.5.2 EPM and FPMXL Functions
259
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.1.1 Data Manager
268
5.1.2 SAP BW
276
5.1.3 Flat Files
279
5.2 Loading Data in SAP BW
283
5.2.1 Master Data, Text, and Hierarchies
284
5.2.2 Transactional Data
293
5.3 Loading Data from SAP BW to SAP BPC
296
5.3.1 Master Data and Text
297
5.3.2 Hierarchies
307
5.3.3 Transactional Data
317
5.4 Loading Data from a Flat File to SAP BPC
327
5.4.1 Master Data and Hierarchy
328
5.4.2 Text
332
5.4.3 Transactional Data
334
5.5 Using the Data Manager
340
5.5.1 Data Manager Configuration
341
5.5.2 Process Chains
347
5.6 Uploading Currency Exchange Rates for SAP BPC
350
5.6.1 Data Flow of Currency Exchange Rates to the Rate Model
352
5.6.2 Configuring SAP BW and SAP BPC for Exchange Rate Uploads
354
5.7 Advanced Data Loading for SAP BW for SAP BPC
359
5.7.1 Analysis of the DELTA INIT Process
361
5.7.2 Setup of the SAP BW Process Chain to Execute the SAP BPC Data Manager Package
365
5.8 Summary
373
6 Forecasting, Planning, and Budgeting in Standard SAP BPC
375
6.1 Basic Forecasting, Planning, and Budgeting
375
6.1.1 Driver-Based Approach
381
6.1.2 Top-Down and Bottom-Up Approaches
381
6.2 Script Logic in SAP BPC
383
6.2.1 Worksheet Logic
384
6.2.2 Dimension Member Logic
385
6.2.3 Standard Script Logic Prompts for SAP BPC
385
6.2.4 Using Script Logic in the Planning Process
398
6.2.5 Allocation Script Logic
411
6.2.6 Script Logic in the Automation of Data Loading
412
6.2.7 BAdIs and the ABAP Program
415
6.3 Generic Planning Process
419
6.3.1 Initial Planned Data
419
6.3.2 Copy Process
419
6.3.3 Executing Calculations
421
6.3.4 Top-Down Planning
422
6.3.5 Bottom-Up Planning
430
6.3.6 Data-Transfer Process
430
6.4 Summary
431
7 Consolidation in Standard SAP BPC
433
7.1 Basic Consolidation
433
7.1.1 What Consolidation Is All About
433
7.1.2 Performing Consolidation with SAP BPC
435
7.1.3 Introducing Business Rules
437
7.2 Ownership Data and Elimination Methods
440
7.2.1 The Ownership Process
440
7.2.2 Setting Up Ownership Data
441
7.2.3 The Purchase Method Concept
447
7.2.4 The Proportional and Equity Method Concepts
448
7.3 Setting Up Journal Entries
449
7.3.1 Creating Journal Templates
449
7.3.2 Controlling Journal Activity
450
7.3.3 Creating Journal Entries
451
7.4 Setting Up and Executing Consolidation Tasks
453
7.4.1 Balance Carryforward
453
7.4.2 Reclassification
459
7.4.3 Currency Translation for Consolidation
462
7.4.4 Purchase Method Elimination
471
7.4.5 Proportional Method Elimination
482
7.4.6 Equity Method Elimination
485
7.4.7 Ownership Elimination
488
7.4.8 Intercompany Matching
495
7.4.9 Intercompany Elimination
499
7.4.10 US Eliminations
502
7.5 Setting Up Balancing Script Logic for Consolidation
506
7.5.1 Balancing Logic Components
506
7.5.2 Balancing Logic Results
508
7.6 Setting Up and Executing Equity Pickup
509
7.6.1 Prerequisites for Using Equity Pickup for Banking
510
7.6.2 Equity Pickup Business Rule
511
7.6.3 Equity Pickup Monitor
515
7.7 Consolidation Monitor
516
7.8 Summary
522
8 Managing the Standard SAP BPC Process
523
8.1 Security
523
8.1.1 Users
526
8.1.2 Teams
529
8.1.3 Task Profiles
531
8.1.4 Data Access Profiles
533
8.1.5 Security in the EPM Add-In
536
8.2 Work Status
537
8.2.1 Configuration of Work Status
538
8.2.2 Reporting and Managing Work Status
542
8.3 Controls
545
8.3.1 Configuration
545
8.3.2 Control Monitor
552
8.4 System Reporting
555
8.4.1 Auditing
556
8.4.2 System Reporting
559
8.4.3 Audit Tables Reports
566
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.4.1 From IP with PAK Turned On
607
9.4.2 From SAP SEM-BPS
608
9.4.3 From SAP BPC 7.x
609
9.4.4 From SAP BPC 10.0 without SAP HANA
609
9.4.5 Hybrid/Mixed Scenarios
610
9.4.6 New Customer with Business Ownership Focus
610
9.4.7 New Customer with EDW Integration Focus
611
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.1.1 Using Real-Time InfoCubes
616
10.1.2 Using Aggregation Levels
619
10.1.3 Using a Copy Planning Function
624
10.1.4 Using Planning-Enabled Queries
626
10.1.5 Using Embedded SAP BPC Environments
631
10.1.6 Using SAP BPC Models
634
10.1.7 Using the EPM Add-in Workbooks for Basic Planning Scenarios
636
10.1.8 Browsing and Compressing Data in SAP BW
641
10.1.9 Browsing Data and Statistics in SAP HANA
643
10.2 Using MultiProviders
646
10.2.1 Creating the MultiProvider
647
10.2.2 Creating Aggregation Levels for MultiProviders
648
10.2.3 Creating Queries in the MultiProvider Scenario
649
10.2.4 Creating Embedded Models in the MultiProvider Scenario
651
10.2.5 EPM Add-In for the MultiProvider Scenario
652
10.3 Using CompositeProviders
653
10.4 Using DataStore Objects
654
10.4.1 Creating a Planning-Enabled DSO
655
10.4.2 Creating an Aggregation Level for a DSO
657
10.4.3 EPM Add-In for DSO Scenario
657
10.4.4 DSO Price Planning
658
10.4.5 DSO Comments
659
10.5 Using Local Providers
660
10.5.1 Creating a Local Provider and Model
661
10.5.2 Aggregation Level for a Local Provider
664
10.5.3 Query and Workbook for a Local Provider
665
10.5.4 View Data in SAP HANA for a Local Provider
666
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.3.1 EPM Features
680
11.3.2 Using the EPM Add-In
682
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.1.1 Copy Function
706
12.1.2 Revaluation Function
708
12.1.3 Delete Function
709
12.1.4 Repost Function
709
12.2 Executing Planning Functions from Excel
710
12.2.1 Data Processing Tab
710
12.2.2 Pushbuttons
712
12.3 Disaggregation and Inverse Formulas
714
12.3.1 Disaggregation
715
12.3.2 Inverse Formulas
717
12.4 Planning Filters and Planning Sequences
720
12.4.1 Planning Filters
720
12.4.2 Planning Sequences
722
12.5 FOX Formulas
725
12.5.1 Creating a Driver-Based Formula
726
12.5.2 Creating a Formula to Calculate Revenue Based on the Prior Year
729
12.5.3 Creating a Formula with a Loop
731
12.6 Characteristic Relationships
733
12.6.1 Combination Checking
733
12.6.2 Characteristic Derivation
736
12.7 Advanced Planning Functions
738
12.7.1 Currency Translation
739
12.7.2 Unit of Measure Conversion
744
12.7.3 Top-Down Distribution
747
12.7.4 Distribution with Keys
751
12.7.5 Deletion of Invalid Combinations
753
12.7.6 Reposting on Basis of Characteristic Relationships
754
12.7.7 Generating Combinations
756
12.7.8 Custom Planning Functions
757
12.8 Summary
761
13 Data Loading for Embedded Consolidation
763
13.1 Basics for Consolidation in Embedded SAP BPC
764
13.1.1 Scenarios for Data Loading in Embedded Consolidation
765
13.1.2 Mixed Architecture Approach in Embedded SAP BPC
769
13.1.3 Use of the Special Period 000
773
13.1.4 SAP BEx Variables for Reporting
776
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.1.1 Overview of Embedded Consolidation System
788
14.1.2 Architecture and Setup of the Model
792
14.2 Introduction to Business Rules
806
14.3 Ownership Data and Elimination Methods
808
14.3.1 The Ownership Process
809
14.3.2 Setting Up Ownership Data
810
14.3.3 The Purchase Method Concept
816
14.3.4 The Proportional and Equity Method Concepts
817
14.4 Setting Up and Executing Consolidation Tasks
818
14.4.1 Balance Carryforward
818
14.4.2 Reclassification
822
14.4.3 Currency Translation for Consolidation
826
14.4.4 Purchase Method Elimination
834
14.4.5 Proportional Method Elimination
844
14.4.6 Equity Method Elimination
847
14.4.7 Ownership Elimination
850
14.4.8 Intercompany Matching
856
14.4.9 Intercompany Elimination
860
14.4.10 Task Sequences for Consolidation Monitor
863
14.5 Summary
865
15 Managing the Embedded SAP BPC Process
867
15.1 Security
867
15.1.1 Users
869
15.1.2 Teams
871
15.1.3 Data Access Profiles
871
15.1.4 Matrix Security
879
15.1.5 Authorization Objects
880
15.2 Work Status
882
15.2.1 Configuration
882
15.2.2 Using Work Status
887
15.2.3 Reporting
889
15.3 Data Audit
891
15.3.1 Configuration
891
15.3.2 Using Embedded Data Audit
895
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
A.1 Data Loading Via SAP HANA Tables
913
A.2 The RTC Model
922
A.3 RTC VirtualProvider
928
A.4 Maintaining RTC-Specific Objects in SAP BPC
931
A.5 FX Translation via SAP S/4HANA
941
A.6 Summary
947
2 The Authors
949
Index
951