Skip to Content

Dear SAP Users,

I have tried to prepare a document to introduce and illustrate the SAP Business Planning and Consolidation (BPC) aspects and also with respect to BW.

I hope this document would help the beginner’s and the BW consultants who are looking to explore the BPC on BW career mode.

Do give your Inputs and suggestions to improve and collaborate more on this space.

SAP Business Planning and Consolidation ( BPC )

SAP Business Objects Planning and Consolidation (formerly Outlook Soft) is a corporate performance management tool that can cater for all types of planning and Consolidation , forecasting and Budgeting from simple small processes to complex multi-layer processes, while also providing consolidation and easy to use reporting.

SAP BPC offers a robust, multiuser platform, which is fully integrated with Microsoft Excel.

The multi-dimensional nature allows users to “slice and dice” the data according their needs.

As SAP BPC utilizes OLAP technology, this means that data is available as soon as it has been entered – no need to aggregate data.

Enables an organization to keep track of its progress through a budget/forecasting process.

Planning and Consolidation is part of Enterprise Performance Management

Planning and Consolidation is part of Enterprise Performance Management.png

SAP BPC Versions and Requirements

SAP BPC 7.5, version for Netweaver, requires SAP BW 7.0

SAP BPC 10.0, version for Netweaver, requires SAP BW 7.3

SAP BPC 10.1, version for Netweaver, requires SAP BW 7.4 SP05

SAP BPC Architecture

SAP BPC Architecture.png

The Excel Interface of the EPM add-in can be used to access data from multiple

  1. Sources.

The data retrieval options are the same, regardless of the source. However,

when used for the planning and consolidation application, additional features are

available including data input and Data Manager, for example.

Data Manager is used to import data and run planning functions such as copy,

delete, and move.

Since it is easy to use, IT does not always need to be involved in the configuration of SAP Business Objects Planning and Consolidation.

easy to use.png

BPC Objects with BW objects Comparison

SAP BPC

SAP BW

Environment

InfoArea

Model

Infocube

Dimensions

Infoobjects

Member

Characteristic Value

Property

Attribute

Hierarchy

Hierarchy

SignedData

Key Figure

Measures

Calculated Key Figures

High Level BPC – BW Solution

High Level BPC – BW Solution.png

It is Necessary to understand the Key Figure and Account Based Model. On a high level the comparison


Key Figure to Account Based Modelling

Key Figure to Account Based Modelling.png

Key Figure Cube to BPC Cube

Key Figure Cube to BPC Cube.png

Modelling Infocubes

Modelling Infocubes.png

Data Load High Level

Flat File Scenario

Flat File Scenario.png

Master Data Import

Master Data Import.png

BW to BPC Scenario

BW to BPC Scenario.png

My main focus would be to align on the BPC on BW integration and Technical Architecture and details.

Therefore my next step would be illustrate and explain on the BPC on BW integration followed by step by step explanation on each topic like Modelling, Loading and so on.

Good Luck and hope this helps.

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Priyanka Maheshwaram

    Hello Syed, thank you for sharing the information.very nice blog and concepts are explained in detailed. one of the recommanded blog for learners. keep on posting articles. If any one looking for SAP BPC Training online, i would like to suggest to visit here, as the trainers are very knowledgeable and helpful.

    (0) 

Leave a Reply