Skip to Content
0
Former Member
Nov 12, 2012 at 02:15 PM

Script logic syntax Error Enforced *Destination can't be empty

26 Views

Hi posted in the wrong forum ( BPC for NW instead of MS )

Hi I'm new in BPC world and I try to understand this error message when I validate script

Validation status of executable file: Failed

- Enforced *DESTINATION cannot be empty

It's look like under the CLEAR_DESTINATION

This is the code ( if I put the 2 first destination in comments I have no error message ) What I Need to add or change to remove the message

o //Roll Journal entries for balance sheet

*INCLUDE SYSTEM_CONSTANTS.LGL

//amounts need to be accumulated over time

*CALC_EACH_PERIOD

//get all of the balance sheet accounts

*SELECT(%BS_ACCTS%,"[ID]","ACCDIM","[GROUP]='BS'")

//get the first year for the version from the YEAR property

*SELECT(%MIN_VERSION_YEAR%,"[YEAR]","VERSIONDIM","[ID]='%VERSION_SET%'")

//get the last year for the version from the YEAR + INPUT_YEARS - 1

*SELECT(%MAX_VERSION_YEAR%,"CAST([YEAR] as int) + CAST([INPUT_YEARS] as int) - 1","VERSIONDIM","[ID]='%VERSION_SET%'")

//get the start month from the version

*SELECT(%VERSION_STARTMTH%,"[MONTHNUM]","VERSIONDIM","[ID]='%VERSION_SET%'")

//get the list of time periods between the first year and last year of the version

*SELECT(%VERSION_TIME%,"[ID]","TIMEDIM","(([YEAR]='%MIN_VERSION_YEAR%' AND [MONTHNUM]>='%VERSION_STARTMTH%') OR ([YEAR]>'%MIN_VERSION_YEAR%' AND [YEAR]<='%MAX_VERSION_YEAR%')) AND [CALC]='N' AND [PERIOD]<>'AINP'")

//get all data sources under JNL_TOTAL

*MEMBERSET(%JNL_TOTAL_DTS%,"Descendants([DATASRC].[JNL_TOTAL],999,LEAVES)")

//define the source data region

*XDIM_MEMBERSET ACCDIM = %BS_ACCTS%

*XDIM_MEMBERSET CODIM = <ALL>

*XDIM_MEMBERSET CCDIM = NOCOSTCENTER

*XDIM_MEMBERSET DSDIM = %JNL_TOTAL_DTS%

*XDIM_MEMBERSET DTDIM = <ALL>

*XDIM_MEMBERSET FLOWDIM = <ALL>

*XDIM_MEMBERSET FADIM = <ALL>

*XDIM_MEMBERSET ICURRDIM = <ALL>

*XDIM_MEMBERSET ICDIM = <ALL>

*XDIM_MEMBERSET RCURRDIM = <ALL>

*XDIM_MEMBERSET TIMEDIM = PRIOR,%VERSION_TIME%

*XDIM_MEMBERSET VERSIONDIM = %VERSION_SET%

*CLEAR_DESTINATION

//define the destination data region

*DESTINATION ACCDIM = %BS_ACCTS%

*DESTINATION TIMEDIM = %VERSION_TIME%

*DESTINATION DSDIM = JNL_OPEN

*DESTINATION FLOWDIM = F_OPE

*WHEN TIMEDIM

//each month and the month before the budget/forecast starts

*IS PRIOR,%VERSION_TIME%

*WHEN DATASRC

*IS #JNL_TOTAL

//roll forward F_TOT members to F_OPE and for all months except December

*WHEN TIME.MONTHNUM

*IS <> 12

*WHEN FLOWDIM

*IS #F_TOT

*REC(TIMEDIM=TIMEDIM.NEXT,DSDIM="JNL_OPEN",FLOWDIM="F_OPE")

*ENDWHEN

*ENDWHEN

//roll forward F_CLO for all months

*WHEN FLOWDIM

*IS F_CLO

*REC(TIMEDIM=TIMEDIM.NEXT,DSDIM="JNL_OPEN",)

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT