Script for the customised Export_TD_to_File Data Manager package

PROMPT(SELECTINPUT,%SELECTION%,,,"CATEGORY",,1)

'PROMPT(OUTFILE,%OUTPUTFILE%,"Please enter an output file",Data files (*.txt)|*.txt|All files(*.*)|*.*)

'PROMPT(RADIOBUTTON,%ADDITIONINFO%,"Add other information(Environment,Model,User,Time)?",1,{"Yes","No"},{"1","0"})

PROMPT(MESSAGE,This is a customised version of the standard package: Selection items have fixed values)

PROMPT(MESSAGE,Only the Category dimension requires input, all other dims will be exported in entirety)

PROMPT(MESSAGE,Transformation File = \TD_BACKUP.xls")

PROMPT(TEXT,%OUTPUTFILE%,Enter a name for the output file (will be filled in automatically from prompt file),,)

 

INFO(%SELECTION_KEYDATE%,)

INFO(%DIMVALUE%,E=24)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%TEMPNO2%,%INCREASENO%)

INFO(%TFILE%,\ROOT\WEBFOLDERS\%APPSET%\%APP%\DATAMANAGER\TRANSFORMATIONFILES\TD_Backup.xls)

INFO(%OUTPATH%,\ROOT\WEBFOLDERS\%APPSET%\%APP%\DATAMANAGER\DATAFILES\BACKUPS\)

 

TASK(/CPMB/APPL_TD_SOURCE,SELECTION,%SELECTION%)

TASK(/CPMB/APPL_TD_SOURCE,DIMENSIONVALUE,%DIMVALUE%)

TASK(/CPMB/APPL_TD_SOURCE,MEASURES,SIGNEDDATA)

TASK(/CPMB/APPL_TD_SOURCE,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/APPL_TD_SOURCE,KEYDATE,%SELECTION_KEYDATE%)

TASK(/CPMB/EXPORT_TD_CONVERT,INPUTNO,%TEMPNO1%)

TASK(/CPMB/EXPORT_TD_CONVERT,TRANSFORMATIONFILEPATH,%TFILE%))

TASK(/CPMB/EXPORT_TD_CONVERT,SUSER,%USER%)

TASK(/CPMB/EXPORT_TD_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/EXPORT_TD_CONVERT,SAPP,%APP%)

TASK(/CPMB/EXPORT_TD_CONVERT,OUTPUTNO,%TEMPNO2%)

TASK(/CPMB/EXPORT_TD_CONVERT,KEYDATE,%SELECTION_KEYDATE%)

TASK(/CPMB/TD_FILE_TARGET,INPUTNO,%TEMPNO2%)

TASK(/CPMB/TD_FILE_TARGET,FULLFILENAME,%OUTPATH%%OUTPUTFILE%)

TASK(/CPMB/TD_FILE_TARGET,ADDITIONALINFO,0)

Location

Reading, UK