I have found that TMVL statements will not validate in BPC 10 when used with a variable such as %TIME_SET%. It produces a syntax error. If I hard code a value in place of the variable it will vallidate.
produces syntax error:
*XDIM_MEMBERSET TIMEDIM=TMVL(%TIMEVAR%,%TIME_SET%)
validates:
*XDIM_MEMBERSET TIMEDIM=TMVL(1,P01.2013)
I am experiancing a similar error with *SELECT.
produces Invalid "select" statement error:
*SELECT(%TIMEVAR%,[TIMEVAR],VERSION,"[ID]=%VERSION_SET%")
validates:
*SELECT(%NEWVER%,[NEWVER],VERSION,"[ID]=ACT")
What might be wrong?
Thanks,
--Brent