Gurus
I am new to Hyperion Planning and have a question :
I am trying to write the followgin script and it throws and error as listed.
SCRIPT:
/*STARTCOMPONENT:SCRIPT*/
SET COPYMISSINGBLOCK OFF;
FIX ("AC_91100","AC_91380","AC_92105","AC_93100","AC_94105","AC_95100","AC_96100","BegBalance",
"Current Service Level","FU_0","FN_00000","LO_000000","FD_100","FD_200",&ProposedYear,"Baseline",@Relative("Project", 0),@Relative("Total Entity", 0))
"AC_91100" (
IF ( "Start Date"->"Projected"==#MISSING AND "End Date"->"Projected"==#MISSING )
DATACOPY "Start Date"->"Budget"to "Start Date"->"Projected";
DATACOPY "End Date"->"Budget"to "End Date"->"Projected";
ELSEIF ( "Start Date"->"Projected"==#MISSING AND "End Date"->"Projected"!=#MISSING )
DATACOPY "Start Date"->"Budget"to "Start Date"->"Projected";
ElSEIF ( "Start Date"->"Projected"!=#MISSING AND "End Date"->"Projected"==#MISSING )
DATACOPY "End Date"->"Budget"to "End Date"->"Projected";
)
ENDFIX;
/*ENDCOMPONENT*/
Error Message when I validate the script:
An error occurred while parsing the script.
Please check the script between the line:9 column: 71 and line:9 column: 78.
Found token '#MISSING'- expected tokens: <EOF>,<DIGIT>,<LETTER>,"/*STARTCOMPONENT:SCRIPT*/","/*ENDCOMPONENT*/","/*STARTCOMPONENT:FORMULA*/","/*STARTRULE*/","/*ENDRULE*/","/*STARTTEMPLATE*/","/*ENDTEMPLATE*/","\"File\"","\"Binfile\"","\"DSN\"","DataExportLevel","LEVEL0","\"LEVEL0\"","INPUT","\"INPUT\"","DataExportDynamicCalc","DataExportNonExistingBlocks","ON","\"ON\"","OFF","\"OFF\"","HIGH","LOW","DEFAULT","ONLY","AFTER","SUMMARY","DETAIL","ERROR","WARNS","INFO","NONE","DEBUG","WARNING","DataExportDecimal","DataExportPrecision","DataExportColFormat","DataExportColHeader","DataExportDimHeader","DataExportRelationalFile","DataExportOverwriteFile","DataExportDryRun","@_false","@_true","NUMBER","MEMBER","BOOLEAN","STRING",<COMMENT_CPP_STYLE>,<SPACE>,"/*","*/","\n",<token of kind 56>,"\"","\"","\n",<token of kind 60>,"[[","]]","\n",<token of kind 64>,<SUBST_VARIABLE>,<hfm_VARIABLE>,<MACRO>,<REAL_NUMBER>,<INTEGER_NUMBER>,"AGG","ALL","\"ALL\"","AND","ARRAY",<CALC>,"CCONV","CLEARBLOCK","CLEARDATA","DATACOPY","DATAEXPORT","DATAEXPORTCOND","DATAIMPORTBIN","DIM","DYNAMIC","ELSE","ELSEIF","ENDFIX","ENDEXCLUDE","ENDIF","ENDLOOP","EXCEPT","FOR","ENDFOR","FIX","EXCLUDE","IF","LOOP","MBR","NONINPUT","EMPTY","NOT","OR","REFERENCE_TO_PARAMETER","RUNJAVA","SET","TO","TOLOCALRATE","UPPER","VAR","DATAEXPORTOPTIONS","AGGMISSG","CACHE","CALCPARALLEL","CALCTASKDIMS","CCTRACKCALC","COPYMISSINGBLOCK","CLEARUPDATESTATUS","CREATENONMISSINGBLK","CREATEBLOCKONEQ","DATAIMPORTIGNORETIMESTAMP","EMPTYMEMBERSETS","FRMLBOTTOMUP","FRMLRTDYNAMIC","LOCKBLOCK","MSG","NOTICE","REVERSE","REMOTECALC","UPDATECALC","UPTOLOCAL","::","#MISSING","=","->",<EQOP>,<MULOP>,<MDXMbr>,<SHORTQUAL>,<ID>,<INTEGER>,<FLOAT>,<RELOP>,"@Loopback",<FUNCTION>,"(",";",",","[","]","{","}","-",")","ReplaceAll",".","+",":=",":"
*****************************
Let me know what mistake am I doing here. Any help is greatly appreciated. Thanks in advance.
Thanks
SR