*FOR ORDER_TIME Issue

[Former Member]

Hi experts,

We are facing a problem to validate a script that contains the following statement:

*FOR ORDER_TIME %MYTIME% = %TIME_SET%

The error that appears is:

Model: Consolidation

Logic file: CF_Alt2.LGF

Validation status of executable file: Failed

- Invalid period: %TIME_SET%

Validation status of syntax: Success

We want to create a loop in the code by passing the time periods ordered in the correct sequence (that is, from earliest to latest).

Does anyone have an idea what is wrong?

Thanks and regards,

Jorge

[Former Member · Accepted solution]

Hi all,

thank you very much for your help. At the end I couldn't solve the issue and decided to use the

*CALC_EACH_PERIOD statement instead to make a loop for the periods and now the logic is working.

Best regards,

Jorge

[former_member186498 · Accepted solution]

Hi Jorge,

good that you found a solution, please close the thread assigning your answer as correct answer.

Regards

     Roberto

[former_member186498]

Hi Jorge,

could you please share the whole script to better understand what do you want to obtain.

Thanks and regards

     Roberto

[former_member244885]

Your question prompted me to look around a bit.  My apologies if you've already seen this, but it looks like there may be some useful information here:

Enterprise Performance Management (EPM) How-to Guides - Business Process Expert - SCN Wiki

This one for 7.5 has an example, "Calcaccount.lgf" that looks similar:

Whitepaper: Script Logic Primer - Planning and Consolidation Version for Netweaver

I'm reading through the doc now...

Maybe you need to remove the '%'s from the MYTIME variable?

FOR ORDER_TIME MYTIME = %TIME_SET%