Hi ALL!
I have bpc NW 10.0 SP12 .
I'm trying to create a script logic to copy a group of information only if a condition is true. In this case, a parent member must have value other than 1. I've tried several ways without success. I don't want to use a BADI.
So: I have some questions:
a) RUNALLOCATION with AMOUNT (not supported). Is there any trick to do the same?
b) One of my logics has part below. It happens that this logic always gets runtime error when running "Error Message: Error executing logic proposed ()
Error tmp.exec. invalid assignment left-hand side. ". One more question: I need to treat NULL? If yes, how?
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
*SYSLIB SYSTEM_CONSTANTS.LGF
*XDIM_MEMBERSET ACCTEXP = BAS(TOTALCONTA)
*XDIM_MEMBERSET AUDITTRAIL = DESP_INPUT
*XDIM_MEMBERSET ENTITY = %ENTITY_SET%
*XDIM_ADDMEMBERSET ENTITY = "CECO_IN"
*XDIM_MEMBERSET RPTCURRENCY = "LC"
*XDIM_MEMBERSET SCHEME = BAS(PROJCAIXA)
*XDIM_MEMBERSET TIME = "2012.INP"
*XDIM_MEMBERSET MEASURES = "PERIODIC"
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET FLOW = "SEMABERTURA"
*LOOKUP EXPENSE
*FOR %LOOP_CENTROCUSTO% = %ENTITY_SET%
*DIM CENTRO: ENTITY=%LOOP_CENTROCUSTO%
*NEXT
*DIM CENTRO: SCHEME = "PROJCAIXA"
*DIM CENTRO: FLOW = "SEMABERTURA"
*DIM CENTRO: AUDITTRAIL = "DESP_INPUT"
*DIM CENTRO: RPTCURRENCY = "LC"
*ENDLOOKUP
*WHEN ENTITY
*IS "CECO_IN" // HERE I HAVE THE DEFAULT DATA THAT I WANT TO COPY TO ANOTHER ENTITY IF THE ENTITY HAS THE AMOUNT AT PROJCAIXA MEMBER OTHER THAN 1.
*FOR %LOOP_CENTROCUSTO% = %ENTITY_SET%
*REC(EXPRESSION=(((LOOKUP(CENTRO))>1) * [ENTITY].[CECO_IN]) + ((LOOKUP(CENTRO)<1) * [ENTITY].[CECO_IN])+ ((LOOKUP(CENTRO)=1) * [AUDITTRAIL].[DESP_INPUT]),ENTITY=%LOOP_CENTROCUSTO%)
*NEXT
*ENDWHEN
// Commit
*COMMIT
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Can anyone help me please?