Feedback & Feature Requests
I was just wondering what your favourite function/tool was in past or present Cube?
Could be technical or interface based. For example:
- I can imagine anyone who zips up models frequently to send to colleagues would use the 'Delete Output Files...' option a lot (under 'File Boxes' on the Home tab).
- Or you might be a perfectionist and now can't live without the 'Show Grid' or 'Snap to Grid' function for application manager?
- Those who read in several matrices at once perhaps can't live without FILLMW?
- Maybe it's the ability to scroll left/right whilst holding the Shift button down and using the mouse scroll?
Let us know.
My favorite trick is to setup Notepad++ to run scripts:
Go to %APPDATA%\Notepad++\shortcuts.xml and add:
<Command name="Run in Cube Voyager" Ctrl="yes" Alt="no" Shift="yes" Key="120">"C:\Program Files\Citilabs\CubeVoyager\VOYAGER.EXE" "$(FULL_CURRENT_PATH)"</Command>
In the group. Then, if you have a script up, press shift+F9 and it will bring up Voyager - you'll still need to click start.
This is really good when you have a model with a lot of post-processing or reporting and want to do something like export a set of files - I use it for exporting loaded networks to DBF files that I subsequently look at in R.
I usually go for a batch mode through DOS. This will allow you to create your program sequence and automate the preparation process (e.g. copy input files from other locations). I find it particular useful when you are postprocessing the data or run an individual module of a model.
My file structure always consists of .\IN, .\PRG and .\OUT, where
.\IN: inputs for the PRG (e.g. input data and/or reference tables)
.\PRG: *.s goes here
.\OUT: store all the output
The batch file is saved in the root directory and call *.s from the .\PRG
The batch file will be named after the script file: e.g. runSCRIPT.bat for SCRIPT.s. The content of the batch file will be something like below:
REM DEFINE *.S AND OUTPUT FOLDER
VOYAGER.EXE .\PRG\%RUNPRG%.S -PTPPL -S.\ /START
REN TPPL*.PRN %RUNPRG%.OUT
REM RENAME THE OUTPUT FILE USING THE INPUT SCRIPT FILE NAME AND SAVE A COPY TO THE OUTPUT FOLDER FOR FUTURE REFERENCE
COPY %RUNPRG%.OUT %OUTPATH%\%RUNPRG%.OUT
Since the batch is a DOS operation, you can also do other DOS operations that are tailor made to your requirement e.g. create a interactive menu, delete temporary files or rename files as needed.