Skip to Content
0
Former Member
Aug 31, 2011 at 05:36 PM

SAP BPC NW 7.5 SP6, Script Logic ADD statement

115 Views

Dear Experts,

We are implementing this script logic following the recommendations and definitions of the statements but it´s not working as is expected to be, so we are asking for some help

*XDIM_MEMBERSET COSTCENTER=%COSTCENTER_SET% // Here we are getting the member that is selected from the Current View

*SELECT(%AREAFUN%,"[FUNC_AREA]",COSTCENTER,"[ID]='%COSTCENTER_SET%'") // Here we are getting the property u201CFUNC_AREAu201D of the COSTCENTER member selected before and stored into the variable %AREAFUN% with the following sentence

*XDIM_MEMBERSET COSTCENTER=%AREAFUN%

*SELECT(%BECAS%,ID,PC_GLFA,"FUNC_AREA='%AREAFUN%' AND GL_ACCOUNT='7302010000' AND GL_ACCOUNT='7301020000'") //with this select we are filtering the accounts that have the same FUNC_AREA value that the one selected in COSTCENTER and that meet the GL_ACCOUNT property filters as well

*XDIM_MEMBERSET PC_GLFA = %BECAS%

*WHEN PC_GLFA // this is the account dimension

*IS P102 // this is an account member

// the following statement is not working, it should sum up all the values that come in the variable %BECAS%.

*ADD %SUMA%=['%BECAS%']

*REC(EXPRESSION=%SUM%,PC_GLFA="P104")

*ENDADD

*ENDWHEN

*COMMIT

Any of you have a recommendation to solve our problem??

Best Reagads.

Aldrin Liendo