scan last 3 month time dimension

[Former Member]

Hi Expert

In my dimension time. i Have time to scan is

*XDim_Memberset TIME = %my-time%

%my-time% is 2010.JAN

now I want want my time dimension able to scan for last 3 month and %my-time% period

so i put

*XDim_Memberset TIME = %my-time%,PRIOR(3)

this one scan for 2010.Jan and 2009.OCT only

if i put

*XDim_Memberset TIME = %my-time%,PRIOR(3),PRIOR(2),PRIOR(1)

this one scan for 2010.Jan and 2009.DEC only

I just cannot get total 4 period time in scan..

Any suggestion..???

[Former Member · Accepted solution]

Hi,

What happens when you put

*XDim_Memberset TIME = PRIOR(3),PRIOR(2),PRIOR(1),%my-time%

[Former Member · Accepted solution]

Thanks for reply

if i put

*XDim_Memberset TIME = PRIOR(3),PRIOR(2),PRIOR(1),%my-time%

it also scan for 2010.JAN and 2009.DEC only..

Any other method??

[Former Member · Accepted solution]

Hi Chiam,

Why don't you try the following:

*XDim_Memberset TIME = PRIOR(3),%my-time%

*CALC_EACH_PERIOD

The keyword *CALC_EACH_PERIOD will grab all the time dimension ID from the earliest till the last as defined in your *XDIM_MemberSet, it will also scan them chronologically.

Cheers,

Lip Chean