Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

TMVL

Hello Experts,

I have this script which i am running .I am getting an error:

RUN_LOGIC:Member "'2013.09'" not exist

The logic is :

*XDIM_MEMBERSET TIME = TMVL(-12,'%TIME_SET%'),TMVL(-12,'%YEAR%.12'),%TIME_SET%

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET RPTCURRENCY = LC

*XDIM_MEMBERSET ACCOUNT = BAS(REVENUE)

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET AUDITTRAIL = BAS(AuditTotal)

*WHEN TIME

*IS TMVL(-12,'%YEAR%.12'),%TIME_SET%

*WHEN ACCOUNT

*IS BAS(REVENUE)

*REC(EXPRESSION = %VALUE%-[TIME].[TMVL(-12,'%TIME_SET%')],ACCOUNT = S_Rev, TIME = TMVL(1,'%TIME_SET%'))

*ENDWHEN

*ENDWHEN

Your help will be appreaciated.I think its the syntax on TMVL

Regards

Lawrence

Former Member
replied

The correct script will be:

//%TIME_SET% = 2015.02

*SELECT(%Y%,[YEAR],TIME,ID=%TIME_SET%)

*XDIM_MEMBERSET TIME=TMVL(-12,%TIME_SET%),TMVL(-12,%Y%.12),%TIME_SET%

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET RPTCURRENCY = LC

*XDIM_MEMBERSET ACCOUNT = BAS(REVENUE)

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET AUDITTRAIL = BAS(AuditTotal)

*WHEN TIME

*IS TMVL(-12,%TIME_SET%) //2014.02

*REC(EXPRESSION = -%VALUE%,ACCOUNT=S_Rev,TIME=%TIME_SET%) //negative!

*ELSE //2015.02,2014.12

*REC(EXPRESSION = %VALUE%,ACCOUNT=S_Rev,TIME=%TIME_SET%)

*ENDWHEN

Vadim

P.S. Never use %YEAR% variable - it's based on the server time and contain current year!

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question