Skip to Content
0

How to copy comments in SAP BPC MS 10.0?

Nov 30, 2017 at 07:20 AM

102

avatar image

Hi I am new to SAP BPC MS version. We got requirement to copy comments in the same model for the other version. Please provide some information how to achieve this requirement.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Cecilia Petersson Nov 30, 2017 at 08:27 AM
0

Hi,

As far as I'm aware there is no function for that (which I find rather strange). My best suggestion, by no means elegant, and also depending on the number of comments and whether they're posted in a few or many reports, is to mimic the reports they're been posted to, with one column to retrieve the original comment and one to post it to the new Category.

I've created a Copy Range that copies the Retrieve comment and Save comment formulas into the report. I've also put in a couple of EPMSelectMember formulas to allow the user to enter source and target for the comment. Then it's just a Refresh and a Save, and the comments are copied.

Hope it helps!

/Cecilia

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Thanks cecilia,

Can you help me how we can copy the comments by EPMSelectMember fomulas.

I am able to create a variables for the Version dimension with the "copymoveinput (%selection%, % toselection%)option in datamanager package. But I am not able to pass this variable values in the "script logic or in lgf file ". We have Version_set for selection and toselection command is not available. Can you assist me here how can we pass the variable for toselection in LGF file

Thanks in advance.

Regards,

Venkat

0

Hi Venkat,

My solution is entirely in the EPM interface. I wouldn't know how to retrieve a comment in a logic script (if at all possible). However, I attach an example script with a user entered target category, which may help you.

/Cecilia

targetcategory.jpg

targetcategory.jpg (108.1 kB)
0
Marc Kuipers
Dec 01, 2017 at 01:31 PM
0

Hello

Use the "CopyComments.dtsx" package

Marc

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Marc,

No standard data manager package available for copy comments in the SAP BPC microsoft version.

Regards,

Venkata Sateesh

0