Skip to Content
avatar image
Former Member

Error in default logic with Time variable

Hi,

We are migrating a budgeting application from SAP BPC 7.0 MS to SAP BPC 10.0NW and we are facing an issue with the default logic in the new application (10.0 NW), and I think we will face the same issue with similars logic

the scope is :

*SELECT(%EJER%,"[EJERCICIO]","P_TIME","ID='%P_TIME_SET%'")

XDIM_MEMBERSET P_FLOW=F99

*XDIM_MEMBERSET P_DATASRC=INPUT

*XDIM_MEMBERSET A_INTERCO=I_NONE

*XDIM_MEMBERSET P_TIME=%EJER%.JAN,%EJER%.FEB,%EJER%.MAR,%EJER%.APR,%EJER%.MAY,%EJER%.JUN,%EJER%.JUL,%EJER%.AUG,%EJER%.SEP,%EJER%.OCT,%EJER%.NOV,%EJER%.DEC

*XDIM_MEMBERSET A_CATEGORY=%A_CATEGORY_SET%

We need that the logic recalculate all the months when we change one or more data. When we execute or input a data in one month, the result is ok, but with severals months we have error of execution, the systeme does not recognize the year.

We have tried to change the logic and include FOR/NEXT but we are facing the same problems.

How can we pass various Time variable (month level) to have a dynamic execution?

Thanks a lot for your help

Regards!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 14, 2015 at 11:04 AM

    Hi Emma,

    Sorry, but please provide the full script and explain the required calculation logic in line with: How To: Ask questions about Script Logic issues

    Vadim

    Add comment
    10|10000 characters needed characters exceeded

    • P.S. With FOR/NEXT you can get the result, but it will be very slow:

      *SELECT(%EJER%,"[EJERCICIO]","P_TIME","ID='%P_TIME_SET%'")

      // will store all EJERCICIO properties of all TIME members in %EJER%

      *FOR %E%=%EJER%

      *XDIM_MEMBERSET P_TIME=%E%.JAN,%E%.FEB,%E%.MAR,%E%.APR,%E%.MAY,%E%.JUN,%E%.JUL,%E%.AUG,%E%.SEP,%E%.OCT,%E%.NOV,%E%.DEC

      // Same calculations will be repeated here number of times

      ...

      *NEXT

      Vadim

  • avatar image
    Former Member
    Jan 14, 2015 at 02:28 PM

    Hi,

    I have tried with for/NEXT but it does not work. If I introduce data in one month the execution is correct, if I introduce data in 2 differents month, I have an error that BPC does not recognize the year.

    For the moment, we are testing with a very simple script: to copy one account to another in each month or the year

    *SELECT(%EJER%,"[EJERCICIO]","P_TIME","ID='%P_TIME_SET%'")

    *XDIM_MEMBERSET P_FLOW=F99

    *XDIM_MEMBERSET P_DATASRC=INPUT

    *XDIM_MEMBERSET A_INTERCO=I_NONE

    *XDIM_MEMBERSET P_TIME=%EJER%.JAN,%EJER%.FEB,%EJER%.MAR,%EJER%.APR,%EJER%.MAY,%EJER%.JUN,%EJER%.JUL,%EJER%.AUG,%EJER%.SEP,%EJER%.OCT,%EJER%.NOV,%EJER%.DEC

    *XDIM_MEMBERSET A_CATEGORY=%A_CATEGORY_SET%

    *XDIM_MEMBERSET A_ACCOUNT=1290000

    *WHEN P_FLOW

    *IS "F99"

    *REC(FACTOR=1, A_ACCOUNT=C20000)

    *ENDWHEN

    *COMMIT

    Thanks

    Regard

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Emma,

      Please describe the calculation logic you want to achieve! Why do you want to recalculate full year if only single month data is changed.

      I am unable to help you without additional info...

      Vadim