How-To Master Data Planning in SAC with a BPC Live Connection

Introduction

Since BW/4HANA 1.0 SP 08 Master Data Planning is available, which I shortly showed in a use case in the blog “How-to Master Data Planning in SAP BW/4HANA”. Based on this use case, I will shortly show how the master planning can be done in SAC with a BPC Live Connection to a BPC 11.1 Embedded.

Scenario

In this use case we will reuse the objects from the first How-To, namely the InfoObject ZCOSTCTR, the Aggregation Level ZALC05 and the Query ZALC05_PLA_01. In addition to these, there are four steps that need to be done for doing the master data planning in SAC:

1. Change Settings in BW

2. Create Model in BPC

3. Create Model in SAC

4. Create Story in SAC

1. Change Settings in BW [Note 2824099]

Planning in SAC with a BPC Live Connection always follows the same steps:

1. Add the InfoProvider in a BPC Model

2. Create a new SAC Model and select a query based on the BPC Model as data source

3. Creation of Story or Application in SAC based on SAC Model

It is the same for master data planning, which means the InfoObject has to be added to a BPC Model first. However, this is only possible by using the SAP Note 2824099.

After downloading the SAP Note there is one more step that needs to be done before InfoObjects can be added to the BPC Model. In SPRO go to “SAP Reference IMG” on the left upper corner,navigate to Embedded only and open “Set Global Parameters” where I add “ENABLE_MASTER” with the value X.

2. Create Model in BPC [ZMD_PLANNING]

In BPC, a new Model based on the InfoObject ZCOSTCTR can now be created by opening the menu and going to “Administration” and selecting “Models”.

3. Create Model in SAC [ZMD_ZCOSTCTR]

In SAC a new model needs to be created. This is done by using the BPC Live Connection which enables the use of the newly created BPC model and ZCOSTCTR as an InfoProvider.

4. Create Story in SAC [ZST_MD_ZCOSTCTR]

Based on the new SAC Model, a new story can be created for the master data planning. For this use case I decided to create a Story, but it is also possible to do Master Data Planning in an Analytic Application.

Now choose “Add a Canvas Page” on the right side, where you can select a table. For the table I click on “Existing Model” and add ZMD_ZCOSTCTR here. To make the input ready cells more visible, change the color of them to yellow. The size of the table can be easily changed via drag and drop.

Finally, the story can be saved as ZST_MD_ZCOSTCTR – Story MD Planning Cost Centers.

Currently, it is not possible to enter new master data for ZCOSTCTR as SAC is not supporting a new line functionality yet.

Summary

This How-To showed how the master data planning in SAC can be realized with some simple steps. By enabling the master data planning in BPC and therewith also in SAC, SAP provides the possibility to do the whole planning in SAC without the need to switch between different tools.

I hope this use case helps you to implement such a solution by yourself and clarifies a few questions.