Skip to Content
avatar image
Former Member

Need to execute consolidation pack on the basis of Time selection

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 05, 2015 at 01:45 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Jan 05, 2015 at 03:04 PM

    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

    Add comment
    10|10000 characters needed characters exceeded