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.