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 COPY data manager package that add keyfigure values on copy

Author(s)          : Lijo John, Bhosale Nandkishor, Amit Kumar Trivedi

Company         : Infosys Limited

Created on       : 09 August 2013

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.

Photograph.jpg

Nandkishor works as a Technology Analyst with Infosys Limited. He has 5 years of experience mainly in SAP NetWeaver BW and BPC support and implementation projects.

Table of Contents

 

Introduction

The standard ‘COPY Data Manager Package’ available in BPC provides two methods for copying 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. 

Intro 1.jpg

Many times while doing a planning project you realize the need of a simple package that can actually COPY 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 ‘COPY Data Manager Package’ that is available.

Step by step implementation guide

Creating the Process Chain

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

Standard chain

STD Chain.jpg

Copy chain

NEW CHAIN.jpg

Make the following two modifications in the new chain

  • Create a new start variant for the new chain.
  • Delete the variant ‘DELETE Application’.

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

Before Modification

Beforee modi.jpg

After Modification

after modi.jpg

Save and Activate the new chain.

Creating the Data Manager Package

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

DMPKG1.jpg

DMPKG2.jpg

Now open the package that just got created in MODIFY mode and click SAVE.

DMPKG3.jpg

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

DMPKG4.jpg

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

DMPKG5.jpgDMPKG6.jpg

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

PROMPT(COPYMOVEINPUT,%SELECTION%,%TOSELECTION%,”Select the members to COPY 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,CLEARDATA,%CLEARDATA%)

Once done, click OK and Save the package.

Executing the Data Manager Package

Login to BPC excel client and execute the package you just created.

The package will run and prompts for source and target records.

RUNPKG1.jpg

Once the prompts and data selections are done, you can run the package immediately or schedule it for a later point in time.

Monitor the package status for completion

RUNPKG2.jpg

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

Standard COPY Package

STD_COPY.jpg

New COPY package with MERGE

NEW_COPY.jpg

To report this post you need to login first.

1 Comment

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

  1. P M

    Very good article!

    I think it’s worth mentioning SAP Note 1694943  – How the Merge functionality works in the Copy package in Data Manager that explains how the standard options work

    (0) 

Leave a Reply