on 01-14-2015 10:57 AM
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.