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
Anonymous 
from IP address 199.242.6.29

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

ie

if CURYR = 2012
CURMTH = 'MAY'
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   
Responses

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

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.