We need to replicate the behaviour of the copy opening package through script logic.
The varibles we introduce in the package are
In the COPYOPENING.LGF we need to read the record of the last period of the previous year of the variable: 2009.DEC
The record we find we should write them on the time we entered in the var Time of the package so we need to filter on the scope with a negative offset for the TIME dimension.
We need to do it dynamic to chose any period of the year and read the last period of the previous year.
We write next code without success.
*XDIM_MEMBERSET ENTITY = <ALL>
*XDIM_MEMBERSET C_CATEGORY = %C_CATEGORY_SET%
*XDIM_MEMBERSET GROUPS = %GROUP_SET%
*XDIM_MEMBERSET TIME = TMVL(-1,%YEAR%)
When validating this code returns the error "Invalid TMVL return value"
Thank you in advance.