Skip to Content
0
Former Member
Jan 26, 2011 at 09:30 AM

TMVL Function BPC 7.5

69 Views

Hello experts,

We need to replicate the behaviour of the copy opening package through script logic.

The varibles we introduce in the package are

C_CATEGORY=ACTUAL

GROUPS=LC

TIME=2010.SEP (i.e)

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 C_ACCT.GROUP

*IS "BSA"

*REC(FACTOR=1,FLOW="F_OPE",TIME=%TIME_SET%)

*ENDWHEN

*COMMIT

When validating this code returns the error "Invalid TMVL return value"

Any help?

Thank you in advance.

Regards