Inhaltsverzeichnis

Alle Kapitel aufklappen
Alle Kapitel zuklappen
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.1.1 Microsoft Version
48
2.1.2 SAP NetWeaver Version
50
2.2 Accessing the System
52
2.3 SAP Business Planning and Consolidation System
60
2.3.1 Library Objects
61
2.3.2 Component Toolbar
62
2.3.3 Support Toolbar
66
2.3.4 SAP Enterprise Performance Management (EPM) Add-In
69
2.4 SAP BPC Starter Kit Information
77
2.4.1 IFRS Starter Kit
79
2.4.2 Other Starter Kits
80
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.2.1 Key Data Modeling Questions
88
3.2.2 EnvironmentShell
94
3.2.3 Configuration/Copy of the EnvironmentShell
97
3.3 Dimensions and Properties
100
3.3.1 Definition of Dimensions
101
3.3.2 Dimension Types
103
3.4 Creating a Dimension
105
3.4.1 Time Dimension
110
3.4.2 Category Dimension
111
3.4.3 Account Dimension
113
3.4.4 Entity Dimension
116
3.4.5 Intercompany Dimension
118
3.4.6 Subtable/Flow Dimension
119
3.4.7 DataSource/AuditTrail Dimension
120
3.4.8 Scope Dimension
121
3.4.9 Rptcurrency Dimension
123
3.4.10 Inputcurrency Dimension
124
3.4.11 Additional Dimensions and Properties
124
3.5 Developing Components of the Dimensions
126
3.5.1 Dimension Security
126
3.5.2 Hierarchies in Dimensions
127
3.5.3 Custom Measure Formulas
128
3.5.4 Dimension Member Formulas
131
3.5.5 Owner Properties
136
3.5.6 Reviewer Properties
137
3.6 Models
138
3.6.1 Developing Models
141
3.6.2 Creating Models
141
3.7 SAP BW Objects
147
3.7.1 Architecture of SAP BW Objects
148
3.7.2 SAP BW Objects Support for SAP BPC for SAP NetWeaver
148
3.7.3 SAP BW/SAP BPC InfoObjects
152
3.7.4 SAP BW/SAP BPC InfoCubes
153
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.2.1 Navigating in the EPM Add-In
176
4.2.2 Using the Context and Current Report Panes
178
4.2.3 Build a Basic Report
180
4.3 Using the EPM Ribbon
187
4.3.1 Reports
188
4.3.2 Data Analysis
194
4.3.3 Undo
197
4.3.4 Data Input
198
4.3.5 Collaboration
207
4.3.6 Tools
220
4.4 Using the EPM Add-In
245
4.4.1 Report Editor and Report Selection
246
4.4.2 Local Members
254
4.4.3 Formatting of Reports
258
4.4.4 Multi-Reports in a Workbook
262
4.5 Excel Add-In Advanced Features
265
4.5.1 Asymmetric Reports
265
4.5.2 EPM and FPMXL Functions
267
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.1.1 Data Manager
276
5.1.2 SAP BW
285
5.1.3 Flat Files
289
5.2 Loading Data in SAP BW
293
5.2.1 Master Data, Text, and Hierarchies
294
5.2.2 Transactional Data
304
5.3 Loading Data from SAP BW to SAP BPC
307
5.3.1 Master Data and Text
308
5.3.2 Hierarchies
319
5.3.3 Transactional Data
329
5.4 Loading Data from a Flat File to SAP BPC
340
5.4.1 Master Data and Hierarchy
341
5.4.2 Text
346
5.4.3 Transactional Data
348
5.5 Using the Data Manager
355
5.5.1 Data Manager Configuration
356
5.5.2 Process Chains
362
5.6 Uploading Currency Exchange Rates for SAP BPC
366
5.6.1 Data Flow of Currency Exchange Rates to the Rate Model
368
5.6.2 Configuring SAP BW and SAP BPC for Exchange Rate Uploads
369
5.7 Advanced Data Loading for SAP BW for SAP BPC
376
5.7.1 Analysis of the DELTA INIT Process
379
5.7.2 Setup of the SAP BW Process Chain to Execute the SAP BPC Data Manager Package
384
5.8 Summary
392
6 Forecasting, Planning, and Budgeting in Standard SAP BPC
395
6.1 Basic Planning, Forecasting, and Budgeting
395
6.1.1 Driver-Based Approach
402
6.1.2 Top-Down and Bottom-Up Approaches
402
6.2 Script Logic in SAP BPC
403
6.2.1 Worksheet Logic
405
6.2.2 Dimension Member Logic
406
6.2.3 Standard Script Logic Prompts for SAP BPC
406
6.2.4 Use of Script Logic in the Planning Process
420
6.2.5 Allocation Script Logic
434
6.2.6 Script Logic in the Automation of Data Loading
435
6.2.7 BAdIs and the ABAP Program
438
6.3 Generic Planning Process
442
6.3.1 Initial Planned Data
442
6.3.2 Copy Process
443
6.3.3 Executing Calculations
444
6.3.4 Top-Down Planning
445
6.3.5 Bottom-Up Planning
454
6.3.6 Data Transfer Process
454
6.4 Summary
455
7 Consolidation in Standard SAP BPC
457
7.1 Basic Consolidation
457
7.1.1 What Consolidation Is All About
457
7.1.2 Performing Consolidations with SAP BPC
459
7.1.3 Introducing Business Rules
461
7.2 Ownership Data and Elimination Methods
464
7.2.1 The Ownership Process
464
7.2.2 Setting Up Ownership Data
466
7.2.3 The Purchase Method Concept
471
7.2.4 The Proportional and Equity Method Concepts
472
7.3 Setting Up Journal Entries
473
7.3.1 The Business Scenario for Using Journal Entries
473
7.3.2 Creating Journal Templates
473
7.3.3 Controlling Journal Activity
475
7.3.4 Creating Journal Entries
476
7.4 Setting Up and Executing Consolidation Tasks
477
7.4.1 Balance Carry Forward
478
7.4.2 Reclassification
483
7.4.3 Currency Translation for Consolidation
487
7.4.4 Purchase Method Elimination
496
7.4.5 Proportional Method Elimination
507
7.4.6 Equity Method Elimination
511
7.4.7 Ownership Elimination
513
7.4.8 Intercompany Matching
520
7.4.9 Intercompany Elimination
525
7.4.10 US Eliminations
528
7.5 Setting Up Balancing Script Logic for Consolidation
532
7.6 Setting Up and Executing Equity Pick Up
536
7.6.1 Prerequisites for Using Equity Pick Up for Banking
536
7.6.2 Equity Pick Up Business Rule
537
7.6.3 Equity Pick Up Monitor
541
7.7 The Consolidation Monitor
543
7.7.1 Prerequisites to Use the Consolidation Monitor
543
7.7.2 Using the Consolidation Monitor
543
7.8 Summary
548
8 Managing the Standard SAP BPC Process
549
8.1 Security
549
8.1.1 Users
552
8.1.2 Teams
555
8.1.3 Task Profiles
557
8.1.4 Data Access Profiles
559
8.1.5 Security in the EPM Add-In
563
8.2 Work Status
564
8.2.1 Configuration of Work Status
564
8.2.2 Reporting and Managing Work Status
568
8.3 Controls
571
8.3.1 Configuration
571
8.3.2 Control Monitor
578
8.4 System Reporting
580
8.4.1 System Reporting
584
8.4.2 Audit Tables Reports
591
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.4.1 From IP with PAK Turned On
631
9.4.2 From SAP Business Planning and Simulation
632
9.4.3 From SAP BPC 7.x
633
9.4.4 From SAP BPC 10.0 without SAP HANA
634
9.4.5 Hybrid/Mixed Scenarios
635
9.4.6 New Customer with Business Ownership Focus
635
9.4.7 New Customer with EDW Integration Focus
636
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.1.1 Using Real-Time InfoCubes
640
10.1.2 Using Aggregation Levels
643
10.1.3 Using a Copy Planning Function
647
10.1.4 Using Planning-Enabled Queries
649
10.1.5 Using Embedded SAP BPC Environments
654
10.1.6 Using SAP BPC Models
657
10.1.7 Using the EPM Add-in Workbooks for Basic Planning Scenarios
659
10.1.8 Browsing and Compressing Data in SAP BW
664
10.1.9 Browsing Data and Statistics in SAP HANA
666
10.2 Using MultiProviders
670
10.2.1 Creating the MultiProvider
671
10.2.2 Creating Aggregation Levels for MultiProviders
672
10.2.3 Creating Queries in the MultiProvider Scenario
673
10.2.4 Creating Embedded Models in the MultiProvider Scenario
675
10.2.5 EPM Add-In for the MultiProvider Scenario
676
10.3 Using Composite Providers
677
10.4 Using DataStore Objects
678
10.4.1 Creating a Planning-Enabled DSO
679
10.4.2 Creating an Aggregation Level for a DSO
680
10.4.3 EPM Add-In for DSO Scenario
681
10.4.4 DSO Delta Buffer
682
10.4.5 DSO Price Planning
682
10.4.6 DSO Comments
683
10.5 Using Local Providers
684
10.5.1 Creating a Local Provider and Model
685
10.5.2 An Aggregation Level for a Local Provider
688
10.5.3 Query and Workbook for a Local Provider
688
10.5.4 View Data in SAP HANA for a Local Provider
689
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.3.1 EPM Features
704
11.3.2 Using EPM
706
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.1.1 The Copy Function
722
12.1.2 The Revaluation Function
724
12.1.3 The Delete Function
725
12.1.4 The Repost Function
725
12.2 Executing Planning Functions from Excel
726
12.2.1 Data Processing Tab
726
12.2.2 Pushbuttons
728
12.3 Disaggregation and Inverse Formulas
730
12.3.1 Disaggregation
731
12.3.2 Inverse Formulas
733
12.4 Planning Filters and Planning Sequences
736
12.4.1 Planning Filters
736
12.4.2 Planning Sequences
738
12.5 FOX Formulas
741
12.5.1 Create a Driver-Based Formula
742
12.5.2 Create a FOX Formula with a Condition
746
12.5.3 Create a Formula to Calculate Revenue Based on the Prior Year
747
12.5.4 Create a Formula with a Loop
749
12.6 Characteristic Relationships
751
12.6.1 Combination Checking
751
12.6.2 Characteristic Derivation
754
12.7 Advanced Planning Functions
756
12.7.1 Currency Translation
756
12.7.2 Unit of Measure Conversion
761
12.7.3 Top-Down Distribution
765
12.7.4 Distribution with Keys
769
12.7.5 Deletion of Invalid Combinations
770
12.7.6 Repost on Basis of Characteristic Relationships
772
12.7.7 Generate Combinations
773
12.7.8 Custom Planning Functions
775
12.8 Summary
779
13 Managing the Embedded SAP BPC Process
781
13.1 Security
781
13.1.1 Users
782
13.1.2 Teams
784
13.1.3 Data Access Profiles
784
13.1.4 Matrix Security
791
13.1.5 Authorization Objects
792
13.2 Work Status
794
13.2.1 Configuration
795
13.2.2 Using Work Status
800
13.2.3 Reporting
801
13.3 Data Audit
804
13.3.1 Configuration
804
13.3.2 Using Embedded Data Audit
807
13.4 Transports
811
13.5 Summary
813
14 Migrating to SAP BPC 10.1
815
14.1 SAP BPC 7.5 to Standard SAP BPC 10.1
817
14.2 SAP BPC 10.0 to Standard SAP BPC 10.1
822
14.3 Integration Planning to Embedded SAP BPC 10.1
824
14.4 SAP BPC 10.0 to Embedded SAP BPC
825
14.5 SAP BPC 10.0 to Mixed Standard/Embedded SAP BPC 10.1
826
14.6 Summary
826
The Authors
827
Index
829