Skip to Content
0
Sep 28, 2015 at 01:27 AM

REC Ternary - Unknown dimension name in Key word

26 Views

Hi,

Can you please help me out?

I am getting the following error. It happens randomly. 75% of times it does not work where as 25% of the time it works on exactly the same set of data. When ever I face this issue, I rewrite the same code and it appears to work for a little while.

I am running this code through default.lgf


Unknown Dimension Name in Keyword: "31) > 0 ) ? 1:2::

*SELECT(%NM_DAYS%,"[NM_DAYS]",TIME,"[ID]"=%TIME_SET%)

*SELECT(%NNM_DAYS%,"[NNM_DAYS]",TIME,"[ID]"=%TIME_SET%)

*XDIM_MEMBERSET TIME AS %TM1% = TMVL(1,%TIME_SET%)

*XDIM_MEMBERSET TIME AS %TM2% = TMVL(2,%TIME_SET%)

*XDIM_ADDMEMBERSET TIME = %TIME_SET%

*WHEN TIME

*IS %TIME_SET%

*WHEN ACCOUNT_COGS

*IS DOS

*REC(EXPRESSION=((%VALUE% - %NM_DAYS%) > 0 ) ? 1:2, ACCOUNT_COGS = WOS_VOL)

*ENDWHEN

*ENDWHEN

Sincerely

Nicky