Skip to Content
0
Former Member
Feb 16, 2011 at 07:25 PM

Previous 12 months of data Script logic

61 Views

Hello All,

I will have a package where the user will specify a month and I would like to calculate the last 12 month average. For instance, if I specify OCT.2010, it should pick Nov 2009 thru Oct 2010. How do I do this in Script logic? I am trying to use PRIOR and it does not seem to work.

*XDIM_MEMBERSET TIME=%TIME_SET%,PRIOR,PRIOR(2),PRIOR(3) etc..

Does PRIOR not work in BPC NW? I thought it did. What I am doing wrong?

Thanks.