Hi,
I am trying to accumalate several accounts using *when statement, and *IIF statement on entity. It is throwing error.
My code looks like
*XDIM_MEMBERSET ACCOUNT= BAS(W439100)
*XDIM_MEMBERSET RPTCURRENCY = LC,USD
*XDIM_MEMBERSET ENTITY = %ENTITY_SET%
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET DATASRC=INPUT
*XDIM_MEMBERSET MEASURES=PERIODIC
*XDIM_MEMBERSET TIME = 2013.TOTAL
*WHEN ACCOUNT
*IS BAS(W439100)
*IIF([ENTITY].[GL_TYPE]=GL_2_INT,*REC(EXPRESSION=%VALUE%,ACCOUNT="439110"), *REC(EXPRESSION=%VALUE%,ACCOUNT="439100"))
*ENDWHEN
it is giving an error during validation
UJK_VALIDATION_EXCEPTION:Unknown or unimplemented keyword "*IIF([ENTITY].[GL_TYPE]=GL_2_INT,*REC(EXPRESSION=%"
Isn't it possible to use IIF condition on entity if we use account in when condition?
your inputs are highly appreciated.
thanks,
ravi.