Need to execute consolidation pack on the basis of Time selection

[Former Member]

Hi Experts,

We need to execute consolidation package full year for budget consolidation. However we can't execute the standard consolidation package full year. User are using data manager link  to select period by period then execute. Is there any way can execute Consolidation package on the basis of time selection?

Regards,

Chandra

[Former Member · Accepted solution]

Hi Chandra,

what is the script that the is being called from data manager? Are users able to select multiple months at once or does it only work one month at a time?

BR,

Arnold

[Former Member · Accepted solution]

Hi Arnold,

We are executing Consolidation Process chain via data manager. Fsor legal consolidation needs to execute one month  for Budget need to execute all the month in a year.

Regards,

Chandra

[Former Member · Accepted solution]

Hi Chandra,

if I assume that you are calling a standard script for the consolidation then you could, by adding a *FOR/*NEXT loop, allow users to select one or several periods at a time. Without this loop the standard script only works for one period.

Having said that, you talk about a process chain so I am not sure if there is something else apart from the standard consolidation being executed. And if it is, I would be unsure if a loop would still work.

To be able to give you a better answer I would need to know what the exact script is, i.e. the content of the log file (or files).

BR,

Arnold

[Former Member]

Hi Arnold,

Thanks for your reply..

Yes..  we are using the standard script.

*RUN_PROGRAM CONSOLIDATION

CATEGORY = %CATEGORY_SET%

GROUP = %SCOPE_SET%

TID_RA = %TIME_SET%

*ENDRUN_PROGRAM

Request to help me what code need to write  to execute the consolidation number of periods.

Regards,

Chandra

[Former Member]

Hi Chandra,

try

*FOR %TIME%=%TIME_SET%

*RUN_PROGRAM CONSOLIDATION

CATEGORY=%CATEGORY_SET%

GROUP=%SCOPE_SET%

TID_RA=%TIME%

*ENDRUN_PROGRAM

*NEXT

With that script your users should be able to select from one to all (twelve?) periods in a year. They still cannot select just the year member from the time period but at least they only have start the consolidation once.

BR,
Arnold

[Former Member]

Hi Arnold,

Thanks. Let me check...

Regards,

Chandra