Skip to Content
0
Sep 28, 2011 at 02:07 PM

Time Dimension 2 PARENTH2 and PRIOR,NEXT

16 Views

Hi all,

We have standart TIME hierarchy from AppShell (MONTH, QUARTER, YEAR). But in some cases users want insert data in detalization by week. We decide add additional ID's with detalizations to weeks and add they in second hierarchy. Everything is ok in system.

But than we try write scrip logic with PRIOR or NEXT which use data from previous year it doesn't work. But than we use PRIOR or NEXT with current year months everything ok.

Example of logic.

*XDIM_MEMBERSET TIME = PRIOR, %TIME_SET%, %YEAR%.DEC

*CALC_EACH_PERIOD

*WHEN P_ACCT
*IS A01
*REC(EXPRESSION=%VALUE% - GET(P_ACCT="A02",TIME=PRIOR), P_ACCT = A03) 
*ENDWHEN
*ENDWHEN

Then we save data on January it doesn't work. BUt on December prev year A02 and January A01 we have data.

Maybe you have some advises according second TIME dimension hierarchy. I think problem on it.

Best regards,

iaroslav