Business Planning &

Consolidation Overview
Wipro Center Of
Excellence


Agenda
EPM 7.0
Existing Solutions
EPM 7.5 EPM 8.0
1
2
3
4
5
Introduction to SAP BPC
Benefits of SAP BPC
Architecture of BPC-BI-R/3
System Landscape
Features of BPC

Slide 3
Business Planning
Business Planning
Business
Planning
BI Platform
ANY ERP / ACCOUNTING SYSTEMS
Business
Profitability
Management

Strategy Management

Business
Planning
Business
Consolidation
Financial Performance Management suite

How are most companies
organized today?
Data source CPM Application
Suites/Modules
User
Interface
unstructured data
structured data
Reporting
Consolidation
Planning
?

Slide 5
Unified System
BPC Beyond Business Planning
Integrated planning and consolidation
Financial reporting and analysis
Ad hoc
Automated variance analysis
Driver analysis (industry, growth, capacity, etc.)
Forecasting and consensus building
Rolling forecasts
Continuous planning
Collaboration
Business planning
Sales/revenue planning
Production Planning
Capital expenditure planning
Headcount/staffing
Expense planning
Financial Statement planning
Consolidation
Intercompany matching/reconciliation
Intercompany eliminations
Management roll-ups
Legal consolidation

BPC 7.0 Netweaver Version
Benefits/Features

- BPC is Integrated with BI in terms of Transaction data, Master Data & Meta data.
- Budget/Forecast available can be retracted back to R/3 using BI Interface Uses Excel and
Microsoft technologies which is already familiar to most of the Users

Other Benefits
Standard, User defined and Adhoc Reporting capabilities in place
Role definition of Analysis authorization is implemented
Reports available in Standard Excel using BEx and Web using BEx WAD
No more manual data Cleansing activities
Putting Infrastructure in Place for future implementation and rollouts
Data structures modelled in a way to cater to current and future reporting and Analysis
requirements
More time is spent on Analysis and Decision making rather gathering information from
multiple sources
Improvement in Performance for Reporting and Analysis
Ability to drill down from KPI to Transaction level for any data set
Tight integration with SAP R/3 and SAP BPC with a unified NW platform



SAP
2008 /
Page 7
BPC Product Roadmap
2010
Q3 2008
SAP Business Objects
Post Acquisition
H1 2009
EPM 7.0 Existing Solutions EPM 7.5 EPM 8.0
Next-Gen
EPM Suite

SEM-BCS
BusinessObjects
Financial Consolidation
SEM-BCS
SEM-BCS
BusinessObjects
Financial Consolidation
N
e
t
W
e
a
v
e
r

B
I

a
n
d

B
u
s
i
n
e
s
s
O
b
j
e
c
t
s

B
I

I
n
t
e
g
r
a
t
i
o
n


SAP Business Planning and Consolidation - Netweaver BI integration by Q3 2008 and Business Objects BI
integration by Q1 2009
BusinessObjects Financial Consolidation integration to Netweaver BI for Q1 2009
SEM-BCS: Legal enhancements thru 2013, planned enhancement packs thru 2008
SAP Business Planning and Consolidation and BusinessObjects Financial Consolidation will be supported
in EPM 8.0
Customers will be able to get EPM 8.0 consolidation functionality under maintenance
BusinessObjects
Financial Consolidation
SEM-BCS
N
e
t
W
e
a
v
e
r

B
I



SAP Business Planning
and Consolidation
SAP Business Planning
and Consolidation
SAP Business Planning
and Consolidation

SAP
2008 /
Page 8
Consistency for the
annual budget process
SAP 2008 / Page 8

SAP
2008 /
Page 9
SAP Business Planning
and Consolidation for Excel

SAP 2008 / Page 9

How are most companies
organized today?
Data source CPM Application
Suites/Modules
User
Interface
unstructured data
structured data
Reporting
Consolidation
Planning
?

SAP
2008 /
Page 11
Dynamic report
templates aid productivity

SAP 2008 / Page 11

SAP
2008 /
Page 12
Drilldown drill
from summary to detail
Charts
expanded
Formulas
preserved
SAP 2008 / Page 12
Drill task

SAP
2008 /
Page 13
Drill down to billing details
SAP 2008 / Page 13

SAP
2008 /
Page 14
Comprehensive functions help
reduce the planning cycle
Actionable functions
Facilitates actions such as drill through
to other reports or views
Expansion functions
Allows dynamic expansion of data
Text functions
Returns text strings for display
Value functions
To send values to or receive values from databases
Modeling functions
Spread spreads a value evenly or based on weights
Trend takes a value and grows the same by a factor
Weight allocates amounts by weighted factors
Data management functions
Copy copies data from source to
destination
Clear clears data in the cube
Move moves data from source to
destination
Custom can create custom function,
e.g., top-down allocation

SAP 2008 / Page 14

SAP
2008 /
Page 15
Report version comparison
SAP 2008 / Page 15

SAP
2008 /
Page 16
Variance analysis from
PowerPoint
SAP 2008 / Page 16

SAP
2008 /
Page 17
Automated audit trail
SAP 2008 / Page 17

SAP
2008 /
Page 18
Conversion files
SAP 2008 / Page 18
Define the mapping from external to internal member names
Provide the ability to perform arithmetic and rounding on data
Can contain one or more worksheets for different types of data transformations


Budgeting and Forecasting Budgeting
Process management, What-If analysis, Budget
versioning, Real Time Allocation and
calculation, Business Process Flow (Approval
process loop, Budget Versioning, etc)

High Usability - Leveraging Excel capabilities
without Excel Hell typical situation. Full
connectivity with MS Word and MS Powerpoint.
Context sensitive menu and action pane





Unified Platform Ability to incorporate all
planning and budgeting process into one single
tool through a unified Business Process Flow
process and platform.

Predictive Analytics Automatic variance
analysis & predictive simulation on KPI.
Encouraging Preventive actions vs. Reactive
actions.



Budgeting, Forecasting,
Strategic Planning

Financial Consolidations
For Legal Statutory and Management Reporting

International Accounting Standards Compliance
Ability to manage multiple GAAP (IFRS, US, JP,
UK,..), SOX compliant with full audit trail
capabilities.

Unified Consolidation View
Ability to provide Legal Statutory and
Management Consolidation within a
single platform

Process Control - Business
Process Flow, Approval and step by
step validation

Pre Packaged templates ready
IFRS, US GAAP and Japan GAAP

BPC integration with BI
SAP R/3

BPC
7.0
Consolidation
Dashboard

Financial
Planning
Dashboard


Reporting
Dashboards
Operational
System
(PS, FI, CO, SD,
MM, WMS, COPA)


Transaction/Master data shared/Sync
between BI 7.0 & BPC 7.0
BI
7.0
Data Extraction
from R/3 into BI
System
Schedules
Assumptions,
Calculations, IS,
BS, CF & Payment
scheme

Data Extraction
from Non-SAP into
BI System
Excel
Word PowerPoint Web


PNL Statement
Balance sheet
Cashflow
CAPEX
Expenditure



PNL Statement
Balance sheet
Cashflow
IC Matching
Journals
Financial Planning
Reports
Consolidation Reports
Schedules
Data Retraction
into R/3 system
Actual Data Flow
Planning in BPC using Actual Data in BI extracted
from R/3

DATA FLOW COMPARISON
(Netweaver Vs SQL)
Operational
System
(PS, FI, CO, SD,
MM, WMS, COPA)


Schedules
Assumptions,
Calculations, IS,
BS, CF & Payment
scheme

SAP R/3

Transaction/Master data shared/Sync
between BI 7.0 & BPC 7.0
BI
7.0
Data Extraction
from R/3 into BI
System
Data Extraction
from Non-SAP into
BI System
Schedules
Data Retraction
into R/3 system
Actual Data Flow
Microsoft Version
SQL Server 2005
Analysis Services
SAP NetWeaver BI
Integrated
Planning
InfoProvider BI Accelerator
OLAP
Engine
.
n
e
t

SAP BPC 7.0
Engine

SIMPLER DATA FLOW/TIGHTER INTEGRATION
NETWEAVER VERSION (R/3 - BI 7.0 BPC)

R E T R A C T I O N
0FI_GL_4
Actual
Excel
Word PowerPoint Web
0CO_OM
2LIS_03_BF
0FI_AR
0PROJECT
0MATERIAL
0WBS
BI 7.0
BPC 7.0
S Y N C H R O N I Z A T I O N
E X T R A C T O R S
Automatic
Cube Creation
Automatic
Master Data
creation
User Interface/Reports
AppSet Application
InfoArea Infocube
Dimension
Info Object

BPC Data Manager
Integration with BI
SAP BPC 7.0 SAP BI 7.0
Uploaded file
saved in BI
Triggers process
chain in BI
Loading an external file
Running data package

BPC AppSet Integration with BI
SAP BPC 7.0
SAP BI 7.0
AppSet -> InfoArea , Application -> InfoCube
Dimension -> InfoObject

Simpler Cube Creation
SAP BPC 7.0
SAP BI 7.0
AppSet -> InfoArea , Application -> InfoCube
Dimension -> InfoObject

BPC Dimension
Integration with BI
SAP BPC 7.0
SAP BI 7.0
Dimension added in BPC
saved in BI as Infoprovider

BPC Report Integration with BI
SAP BPC 7.0
SAP BI 7.0
Generation of Reports using EVDRE() function
List Cube Data filter condition
Data coming from BI InfoCube

Proposed system landscape
BW Prod
R/3 Prod
BPC Prod
BW QA
R/3 QA
BPC QA
BW Dev R/3 Dev
BPC Dev
Development
Server
QA Server
Production
Server
Transport
Transport
Transport
Transport
Transport Transport
The Project adopt 3 systems landscape approach, all development work will be done in
development systems, then transport to QA systems for quality assurance testing, and finally
transport to the Production systems