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

[Former Member]

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

[Former Member]

Hi Frederic,

This validation error is coming because at the time of validation, the variable %BS_ACCTS%, doesnt have any value; since this will come from the DM package. Just ignore the validation error, and run it through DM package. Let me know how it goes.