1 Overview of SAP Enterprise Performance Management

31

1.1 Enterprise Performance Management

31

1.2 Planning, Budgeting, and Forecasting

36

1.2.1 Planning Horizon

38

1.2.2 Planning Types

39

1.2.3 Planning Areas

41

1.2.4 Common Scenarios for Planning in Business

43

1.2.5 Considerations in Planning

45

1.3 Consolidation

47

1.3.1 Elimination of Intercompany Transactions

48

1.3.2 Consolidation of Investments

49

1.4 Summary

50

2 Overview of SAP BPC

51

2.1 SAP BPC: Features

52

2.1.1 Software Designed to Support Change

53

2.1.2 SAP BPC Product Characteristics

54

2.1.3 SAP BPC for NetWeaver

58

2.2 Unified Planning and Consolidation

60

2.2.1 Planning in SAP BPC

60

2.2.2 Consolidation in SAP BPC

60

2.3 SAP BPC for NetWeaver Architecture

63

2.3.1 BPC Clients

64

2.3.2 Connectivity

65

2.3.3 SAP NetWeaver Application Server

66

2.3.4 Database Server

66

2.4 Introducing SAP BW

68

2.4.1 Objects Used in SAP BW

68

2.4.2 Extracting, Transforming, and Loading Data in SAP BW

71

2.4.3 Process Chains

73

2.4.4 Business Content

74

2.4.5 Key Features in SAP BW

74

2.5 Terminology and Objects in SAP BPC

78

2.6 Summary

83

3 Designing a Model with SAP BPC for NetWeaver

85

3.1 Rich Bloom Case Study

85

3.1.1 Business

86

3.1.2 Offices

86

3.1.3 Products

86

3.1.4 Currency

87

3.1.5 Case Study

87

3.1.6 Decision to Use SAP BPC for NetWeaver

88

3.2 Building the Data Model in SAP BW

89

3.2.1 Creating and Activating InfoObjects

92

3.2.2 Creating an InfoArea

102

3.2.3 Creating a Sales InfoCube

102

3.3 Building Models in SAP BPC

108

3.3.1 Accessing the SAP BPC System

110

3.3.2 Environment

114

3.3.3 Dimensions

120

3.3.4 Model

130

3.4 Summary

138

4 Loading, Scheduling, and Managing Data in SAP BPC for NetWeaver

139

4.1 Loading Data into an InfoCube in SAP BW

140

4.1.1 Creating a DataSource

140

4.1.2 Creating Transformations

143

4.1.3 Creating the Data Transfer Process

145

4.1.4 Creating InfoPackages

147

4.1.5 Loading Data from the PSA to the Data Target

150

4.2 Loading Data into SAP BPC

152

4.2.1 Transformation and Conversion

152

4.2.2 Data Manager Packages

160

4.2.3 Process Chains

167

4.2.4 Loading Master Data from a Flat File into a Dimension

168

4.2.5 Loading Master Data from an InfoObject into an SAP BPC Dimension

178

4.2.6 Loading Hierarchy Data from an InfoObject into an SAP BPC Dimension

186

4.2.7 Loading Data from an InfoCube into an SAP BPC Model

191

4.3 Copying Data Inside an SAP BPC Model

197

4.4 Summary

199

5 Reporting, Planning, and Analysis in SAP BPC

201

5.1 Reporting and Analysis in SAP BPC

202

5.1.1 SAP EPM Add-In Interface for Excel: Connecting to a Model

204

5.1.2 Creating Reports

213

5.1.3 Developing Reports Using Dynamic Templates

232

5.1.4 Developing Reports Using EPM Functions

233

5.1.5 Developing Reports Using the EPMRetrieveData Function

237

5.1.6 Developing a Static EPM Report–Rolling Forecast Report

237

5.1.7 Developing Customized Reports

242

5.1.8 Quick Links

246

5.1.9 Migrating 7.5 Version EvDRE Reports

247

5.1.10 Developing Reports Using the New API for EPM

248

5.1.11 Developing Reports Using the SAP BPC Web Client

249

5.2 Planning in SAP BPC Using Input Forms

253

5.2.1 Standard Templates for Input Forms

254

5.2.2 Developing an Input Form

254

5.2.3 Using the EPMSaveData Function to Save Data

257

5.3 Other Features

258

5.3.1 Drill-Through Feature

258

5.3.2 Integration with SAP BusinessObjects Dashboards

258

5.4 Summary

259

6 Developing Business Logic in SAP BPC

261

6.1 Dimension Logic

262

6.1.1 Dimension Formulas

262

6.1.2 Solve Order

263

6.2 Logic Script

267

6.2.1 Logic Script Construct

268

6.2.2 Executing Logic Script

276

6.2.3 Creating Logic Script to Revalue Plan Data

276

6.2.4 Creating Logic Script to Push Data from the YTD to PERIODIC Models

286

6.2.5 Logic Script Files Provided by SAP

287

6.3 Business Rules Overview

288

6.3.1 Currency Translation

288

6.3.2 Carry Forward

288

6.3.3 Account Transformation

288

6.3.4 Intercompany Matching/Booking

289

6.3.5 Intercompany Elimination

289

6.3.6 Eliminations and Automatic Adjustments

289

6.4 Currency Translation

290

6.5 Allocations

301

6.6 Using BAdIs to Code Logic

305

6.7 Validation

308

6.8 Controls

313

6.9 Summary

313

7 Process Management and Collaboration

315

7.1 Work Status

316

7.2 Comments

323

7.2.1 Adding Comments

323

7.2.2 Viewing Comments

326

7.2.3 Reporting on Comments

329

7.2.4 EPM Functions for Comments

331

7.3 Distribution and Collection

332

7.3.1 Creating a Distribution Template

334

7.3.2 Offline Distribution Wizard

339

7.3.3 Collection

343

7.4 Book Publishing

344

7.4.1 Creating a Book Publishing Template

346

7.4.2 Book Publication

349

7.5 Integrating SAP BPC Data into Word and PowerPoint

355

7.6 Summary

356

8 Essential Tools for Building Models

357

8.1 Transporting SAP BPC Objects

358

8.2 Concurrency Locking

364

8.2.1 Approaches to Locking

364

8.2.2 Locking Features in SAP BPC for NetWeaver

365

8.2.3 Locking Process in SAP BPC for NetWeaver

365

8.3 Administration Parameters

366

8.4 Statistics

372

8.5 Audit

375

8.6 Documents

378

8.6.1 Accessing the Documents

378

8.6.2 Posting a Document

378

8.7 Security

379

8.7.1 Users

379

8.7.2 Team

379

8.7.3 Task Profile

380

8.7.4 Data Access Profile

381

8.7.5 Security Model

381

8.8 Summary

382

9 Consolidation with SAP BPC

383

9.1 Steps in Consolidation

384

9.2 Business Rules

384

9.2.1 Carry Forward

386

9.2.2 Account Transformation

394

9.2.3 Intercompany Matching/Booking

398

9.2.4 Intercompany Eliminations (U.S. Elimination)

405

9.2.5 Controls

412

9.3 Consolidation of Investments

421

9.3.1 Purchase Method

421

9.3.2 Equity Method

422

9.3.3 Proportional Method

423

9.3.4 Consolidation of Investments

424

9.4 Intercompany Elimination—Eliminations and Adjustments Business Rule

443

9.5 Journals

447

9.5.1 Create Journal Template

448

9.5.2 Manage Journals

450

9.5.3 Journal BAdI

452

9.6 Summary

453

10 Business Process Flow Interface

455

10.1 Business Process Flow

455

10.1.1 Creating a Business Process Flow Template

456

10.1.2 Creating a Business Process Flow Instance

460

10.1.3 Executing Activities

461

10.1.4 Process Monitor

463

10.2 Summary

463

11 Embedded Environment

465

11.1 Embedded Environment in SAP BPC

465

11.2 Case Study for Financial Planning

466

11.2.1 Rich Bloom Case Study

466

11.2.2 Requirements of the Case Study

468

11.3 Building a Data Model in SAP BW

470

11.3.1 SAP BW Integrated Planning Prerequisites

471

11.3.2 Designing a Data Model in SAP BW

471

11.4 Summary

478

12 Designing an Application in SAP BW-IP

479

12.1 Designing a Planning Application

479

12.1.1 InfoProvider

480

12.1.2 Aggregation Level

481

12.1.3 Filter

485

12.1.4 Planning Functions

488

12.1.5 Planning Sequence

519

12.1.6 Characteristic Relationships

523

12.1.7 Data Slices

526

12.1.8 Settings

527

12.2 Creating Input-Enabled Query for Planning

527

12.2.1 Planning and Reporting Tools

528

12.2.2 Input-Enabled Query Process

531

12.3 Summary

538

13 Creating an Embedded Environment

539

13.1 Creating an Embedded Planning Application

540

13.1.1 Creating an Embedded Environment

540

13.1.2 Creating a Model

541

13.1.3 Creating a Web Input Form

543

13.1.4 Creating a Web Input Form Using the BPC EPM Add-in Interface

546

13.2 Managing an Embedded Environment

551

13.2.1 Enabling Audit

551

13.2.2 Work Status

553

13.2.3 Locking

555

13.2.4 Security

560

13.2.5 Transporting Embedded Environment Objects

567

13.3 Integrating Planning Functions with SAP HANA

569

13.4 Conclusion

574