Invalid TMVL return value in Logic Script

[Former Member]

Hi Experts,

I stumbled upon this error when executing logic script:

UJK_VALIDATION_EXCEPTION:Invalid TMVL return value

Here is the logic script I created just for testing purpose:

*WHEN TIME

*IS TMVL(13, 2016.12)

///DO Something

*ENDWHEN

However, when I tweak the parameter to:

*WHEN TIME

*IS TMVL(12, 2016.12)

///DO Something

*ENDWHEN

I got no error. I immediately think it was issue from my master data. But then when I check, there seems to be nothing weird with TIME master data.

Please help, particularly if someone can explain how tmvl works. I'm using BPC 10 NW

Thanks,

Hendry

[former_member186338 · Accepted solution]

Hi Hendry,

Do you have the member 2018.01? Does TIMEID is properly filled for TIME master data? Please provide a screenshot of the TIME dimension members with TIMEID.

B.R. Vadim

[Former Member · Accepted solution]

Hi Vadim,

Yes it has 2018.01 member within, as well as the TIMEID. However, it was brought to my attention that the time ID for all 2018 period was just manually added. Attached is the TIME dimension screenshot.

Is there something else I need to do after altering dimension member before it could become available?

Thanks,

Hendry

[former_member186338 · Accepted solution]

Hi Hendry,

The screenshot looks correct.

Can you make some simple tests in UJKT and post results?

*XDIM_MEMBERSET TIME=TMVL(11, 2016.12)

*XDIM_MEMBERSET TIME=TMVL(12, 2016.12)

*XDIM_MEMBERSET TIME=TMVL(13, 2016.12)

Run Execute Simulate and post LGX

And what is TIMEID for 2016.12?

Vadim

[Former Member · Accepted solution]

Hi Vadim,

I reopened UJKT transaction, run your script, and it works perfectly. Then I rerun my script on the new session and it runs correctly!

It seems I need to restart my UJKT transaction after adding dimension property (TIMEID) which I did a few hours ago.

Thanks a lot for your help

Best Regards,

Hendry

[former_member186338 · Accepted solution]

Yest, TIMEID is critical for correct results of TMVL