tag:blogger.com,1999:blog-6575283218005807475.post6374155894252467223..comments2023-12-14T05:50:47.097-08:00Comments on More to life...: Managing substitution variables using EPM Automate and RESTJohn Goodwinhttp://www.blogger.com/profile/03663642245534297566noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-6575283218005807475.post-44646561957555221672018-01-10T06:21:26.632-08:002018-01-10T06:21:26.632-08:00No, currently it only works with EPM CloudNo, currently it only works with EPM CloudJohn Goodwinhttps://www.blogger.com/profile/03663642245534297566noreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-36329154011049862592017-12-27T07:57:59.201-08:002017-12-27T07:57:59.201-08:00Hello, these Planning REST APIs have been great. ...Hello, these Planning REST APIs have been great. Does the substitutionvariables call work with on-prem (11.1.2.4) or am I just beating my head against a desk over here?Jayhttps://www.blogger.com/profile/15107559999562353638noreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-47798887554521956092017-05-12T06:12:55.513-07:002017-05-12T06:12:55.513-07:00Hi Gerrit, I have updated the screenshot to a late...Hi Gerrit, I have updated the screenshot to a later version which should match your expectations.John Goodwinhttps://www.blogger.com/profile/03663642245534297566noreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-39642491295548678992017-05-02T13:35:17.728-07:002017-05-02T13:35:17.728-07:00Hi John,
Thanks a lot for this very clear example...Hi John,<br /><br />Thanks a lot for this very clear example, it's very helpful. I'm fairly new to scripting but I've created a similar script but then in Groovy. I was wondering if you tested this script for numPerShift other then 1 (which works fine)? If numPerShift would be e.g. 2, then every iteration of the for loop the currDate will be raised by 2 months (and so will be the sPeriod) which - when assuming the current date is e.g. 10-jan-2017 - will result in:<br /><br />RollPer1 Mar<br />RollYr1 FY17<br />RollPer2 May<br />RollYr2 FY17<br />RollPer3 Jul<br />RollYr3 FY17<br />and so on...<br /><br />I was expecting the result to be achieved should be:<br /><br />RollPer1 Mar<br />RollYr1 FY17<br />RollPer2 Apr<br />RollYr2 FY17<br />RollPer3 Jun<br />RollYr3 FY17<br /><br />So, the first iteration is fine, but every subsequent iteration until the end should only add 1 month to the currDate in stead of 2 correct? Or am I missing something?<br /><br />Kind regards,<br />Gerrit HaanGerrit Haanhttps://www.blogger.com/profile/05952614731062540328noreply@blogger.comtag:blogger.com,1999:blog-6575283218005807475.post-43023731418140521702016-11-27T18:16:55.163-08:002016-11-27T18:16:55.163-08:00Very nice John.Very nice John.Anonymoushttps://www.blogger.com/profile/16481573201826770915noreply@blogger.com