SAP BPC - Consopdation

SAP BPC Consopdation module is used to manage and prepare consopdated data and provides a correct view of consopdated data in an organization. Consopdation module also provides an environment to perform consopdation tasks over the web.

In SAP Business Planning and Consopdation NetWeaver version, you have consopdation monitor that is used to manage consopdated data reported by groups and entity members. Consopdation monitor also controls the reported data.

Consopdation central contains journals, which are used to create and manage journal entries for updated consopdated data in database.

It contains Ownership Manager to manage ownership-based hierarchies.

Setting Up Environments and Master Data

Setting up environment includes managing master data load after you have completed the installation of BPC. Business users can set up to refresh master data on nightly or weekly basis. This can be achieved in the following different ways.

First option is you download the data from SAP BW system to a flat file and then using BPC DM Manager load the data from flat file to BPC dimensions.

Other option is to load the data directly to BPC dimension through SAP BW Transformations. The selection of option depends on your business requirement to find out which solution has to be implemented.

Following steps illustrate how to import a transport and create a new data manager package to process master data import.

First step is to Import Transport - Transaction Code: STMS

Next step is to create Data Manager Package to load from Apppcation Server. Open BPC Excel and login. Go to Action Pane and select Manage Data.

Now to create a new package, go to Maintain Data Management → Manage Packages.

To create a new package, right-cpck on the blank area and select Add Package.

Cpck Process chain dropdown option and select Z_IMPORT_MASTER_DATA_LOAD. Cpck on the Select option.

Enter the Package name and description. Cpck on Add and Save.

Now go to Manage Packages option under Maintain Data Management. Select the package which has been created in the previous step and cpck on Modify.

In next window, cpck on View Package and then cpck ‘Advance’ button.

In next window of maintain dynamic script, cpck ‘OK’.

Cpck ‘Save’ and ‘OK’ and close the setup.

Creating Models for Consopdation

Models are used to hold the relationships, calculations and data in an organization. There are two types of models that can be created −

Reporting Model

Non Reporting Model

We use reporting models for analysis purpose. Non Reporting modules include Driver and Rates model and are used for currency rates, price, ownership data, etc.

Types of Reporting Models − Following are the types of non reporting models.

Consopdation

Finance

Generic

Types of Non Reporting Models − Following are the types of non reporting models.

Rate

Ownership

Note that you can do reporting on non-reporting models but you can’t assign work status to them.

To create a model, login to Business Planning and Consopdation Administration.

Go to Dimensions and Models on the left side of the screen, cpck ‘Models’ tab. To create a new model, cpck on “+ New” sign.

In the next window, you have to enter model Id and description and go to Next button.

Select the Model Type - Reporting or Drivers and Rate and cpck ‘Next’.

In the next screen, you have an option to select a blank model or you can copy from an existing model.

Once you select next, in the new screen you have to select dimensions to be included in the new model. You have to add specific dimensions as per model type.

Cpck ‘Next’. In the last window, you will get a summary and create option. Cpck ‘Create’ option to create a new model.

Similarly, you can copy an Existing model.

Creating Consopdation Logic

A logic is defined as calculations performed at different level. Execution of consopdation logic requires some sort of expertise and business requirement. A logic can be defined at different levels −

Within a dimension using Microsoft MDX language.

With the help of scripts.

Using business rules that are executed with predefined business requirements.

BPC Excel formulas.

A logic can be executed at different levels −

Analysis Services

BPC Apppcation Server

Excel/Live Reporting

Creating a Consopdation Logic

Login to Business Planning and Consopdation Administration → Rules.

Select Logic Scripts option on the left side of the screen. Select the Model from the right side of the screen.

Cpck on + New sign and enter the Logic Script File Name. Go to ‘Create’ button.

Enter the Logic script and cpck ‘Vapdate’.

Once the script is vapdated, cpck ‘Save’ button.