Skip to Content
0
Former Member
Jun 08, 2009 at 02:52 PM

add periods to the selected data region using XDIM_MEMBERSET

19 Views

Hi All,

I am trying to add 3 prior periods to the selected data region using XDIM_MEMBERSET. But, it accepts only 2 time periods.

If I submit the logic for 2009.APR, the logic should add 2009.APR, 2009.MAR,and 2009.FEB and put it

Fee_Inc1_Pr_3_Sum for 2009.APR

Here is the logic that I've written...

//Prior 3Months Sum FEE_INCOME 1

*XDIM_MEMBERSET ACCOUNT=FEE_INCOME1_Calc

*XDIM_MEMBERSET CATEGORY=ACTUAL

*XDIM_MEMBERSET TIME=PRIOR(2),%SET%

*WHEN ACCOUNT.ID

*IS "FEE_INCOME1_Calc"

*REC(ACCOUNT="Fee_Inc1_Pr_3_Sum", TIME=%SET%)

*ENDWHEN

*COMMIT

//

I tried the NEXT but it will not go 3 periods.

//*XDIM_MEMBERSET TIME=PRIOR,%SET%,NEXT(-2)

Thanks for your help in advance.

Swaroop