Skip to Content
0
Nov 21, 2012 at 12:47 PM

TMVL, UJKT and last time dimension member

64 Views

Hi all,

I'm testing a logic containing TMVL function in the UJKT debugger.

The logic (excerpt) looks as follows:

*WHEN TIME.PERIOD

*IS Q1

*REC(EXPRESSION=-(TMVL(-1,%TIME_SET%),[CATEGORY].[CAT15]),C_ACCT=CAC80009,C_DATASRC=DSC1008)

I use TIME=2012.Q1 Data Region window.

After pressing 'VALIDATE' button I receive compiled code (lgx) which looks as follows:

*WHEN TIME.PERIOD

*IS Q1

*REC(EXPRESSION=-( 2099.Q4 ,[CATEGORY].[CAT15]),C_ACCT=CAC70028,C_DATASRC=DSC1008)

where 2099.Q4 is the last member in the TIME dimension.

Is this an expected behaviour and everything will work as supposed when I run this logic via DM package?

Or, there's some kind of mistake in my code?

Thank you,

Valery