This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

Dynamic Data Copy of Scenario using Sub Variables

June 15 2012 at 5:02 PM
No score for this post
from IP address

Im trying to setup a dynamic method of doing a datacopy where the calc script executes a data copy from one particular year/month/scenario to a various amout of year/month/scenarios depending on the month being processed


if CURYR = 2012
NEXTYR = 2013

DATACOPY "&CURYR"->&CURMTH->"Scenario 1" TO "&CURYR"->"Jun"->"Scenario 2";
DATACOPY "&CURYR"->&CURMTH->"Scenario 1" TO "&CURYR"->"Jun"->"Scenario 2";
DATACOPY "&CURYR"->&CURMTH->"Scenario 1" TO "&CURYR"->"Dec"->"Scenario 2";
DATACOPY "&CURYR"->&CURMTH->"Scenario 1" TO "&NEXTYR"->"Dec"->"Scenario 2";

What is the best way of achiving this?

Scoring disabled. You must be logged in to score posts.Respond to this message   

  1. Should work.... - Stuart Game on Jun 28, 2012, 6:49 PM

RSS feed for this forum - Please email hypess (at), if you have any questions/feedback/issues.