Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 16, 2012 at 06:03 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.