cancel
Showing results for 
Search instead for 
Did you mean: 

Error in default logic with Time variable

Former Member
0 Kudos

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!

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

former_member186338
Active Contributor
0 Kudos

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

former_member186338
Active Contributor
0 Kudos

Hi Emma,

Sorry, but please provide the full script and explain the required calculation logic in line with:

Vadim

former_member186338
Active Contributor
0 Kudos

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