Skip to Content

Applies to:

SAP BPC 7.5 / SAP BW 7.3x 

Summary:

This document is a step by step guide to implement a MOVE data manager package that add keyfigure values on move

Author(s)          : Lijo John

Company         : Infosys Limited

Created on       : 02 April 2014

Author Bio:

EAME_u327502_LThumb.jpg

Lijo John works as Senior SAP Consultant with Infosys Limited. He has 7 years of experience in IT Consulting Industry and during this time he has worked majorly on SAP NetWeaver BW, Business Objects and BPC. He has worked on multiple implementation projects.

Table of Contents

 

Introduction

The standard ‘MOVE Data Manager Package’ available in BPC provides two methods for moving source to destination as shown below. However in both the methods values of the target record(s) gets always overwritten by the values from the source record. 

Move image 1.png

Many times while doing a planning project you realize the need of a simple package that can actually MOVE data from source to target record in an addition mode i.e. the value from the source record gets added to the value of the target record instead of overwriting.

In the article we will look into a simple way to achieve this by tweaking the standard ‘MOVE Data Manager Package’ that is available.

Step by step implementation guide

Creating the Process Chain

Copy the standard process chain for MOVE Package into a new chain

Move image 2.png
Make the following two modifications in the new chain

  • Create a new start variant for the new chain.
  • Delete the variant ‘CLEAR SOURCE CUBE’.

The chain before and after modification would look as shown below.

Before Modification

Move image 3.png

After Modification

Save and Activate the new chain.

Move image 4.png

Creating the Data Manager Package

Login to your BPC excel client and create a copy of the standard ‘move transactional data’ package as shown below.

DMPKG1.jpg

Move image 5.png

Open the package again in MODIFY mode and make changes as shown below

  • Process chain would be the new chain that you created
  • The task type can be a User Package or an Admin package based on your requirements.
  • You can choose your own package name, group and description

Move image 6.png

Once the package is created and saved, open the package again with modify option as shown below and navigate to the advanced section

Move image 7.pngDMPKG6.jpg

Copy paste the below PROMPT and TASK definitions into the editable area in the advanced section.

PROMPT(MESSAGE,”Move source record to target record adding the source value to  the existing value in target record”)

PROMPT(COPYMOVEINPUT,%SELECTION%,%TOSELECTION%,”Select the members to MOVE and where to”,”%DIMS%”)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

TASK(/CPMB/CM_CONVERT,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/CM_CONVERT,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/CM_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/CM_CONVERT,SAPP,%APP%)

TASK(/CPMB/CM_CONVERT,SELECTION,%SELECTION%)

TASK(/CPMB/CM_CONVERT,TOSELECTION,%TOSELECTION%)

TASK(/CPMB/CM_CONVERT,CLEARDATA,0)

TASK(/CPMB/APPEND_LOAD,INPUTNO,%TEMPNO1%)

TASK(/CPMB/APPEND_LOAD,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/APPEND_LOAD,RUNLOGIC,%RUNLOGIC%)

TASK(/CPMB/APPEND_LOAD,CHECKLCK,0)

TASK(/CPMB/APPEND_LOAD,CLEARDATA,0)

TASK(/CPMB/CLEAR_CUBE,CHECKLCK,0)

TASK(/CPMB/CLEAR_CUBE,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/CLEAR_CUBE,SELECTION,%SELECTION%)

Once done, click OK and Save the package.

An example how the new package works and how it differs from a standard MOVE Package

Standard MOVE Package

Move image 8.png

New MOVE package with MERGE

Move image 9.png

To report this post you need to login first.

2 Comments

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

  1. Ian Mannion

    Thanks for taking the time to add this…

    It works perfectly in BPC 10 also and saves our business having to manually compile the data and using the ‘Append’ package from flat file.

    (0) 

Leave a Reply