Read OLAP Script File
Read OLAP Script File
The Read OLAP Script File menu is found within the Advanced FinanceHub menu group.
Read OLAP Script File enables a user, developer or DBA to execute a list of OLAP DML statements from a text file stored locally on the users PC.
Files should be stored with a .moo extension.
Use of Read OLAP Script File.
Selecting the Read OLAP Script File menu item opens the File Open dialog window.
Select a .moo file and press Open.
In this example our script1.moo file contains the following:
shw tod
aw list
aw attach express ro first
shw lmt(name to first 10)
All commands are sent to the FinanceHub Command Preprocessor and executed against Oracle OLAP.
On completion the following dialog box is presented.
Output from the Oracle OLAP engine is saved in a filename.moo.out file in the same directory as the source script.
shw tod
16:00:33
aw list
EXPRESS R/O UNCHANGED SYS.EXPRESS
aw attach express ro first
shw lmt(name to first 10)
_XLTID_XLTABLE_SHADOW_LNTYPEPRGTRACEBADLINE_DUMPSYNTAX_DUMPCODEINF_STOP_ON_ERR_OBJECTPROTECT
*Warning* - FinanceHub sends each line of a source filename.moo file to the FinanceHub preprocessor for execution in the Oracle OLAP environment.
Processing of the file does not stop even if there is an error in the source DML.
You should review the filename.moo.out file before issuing any update; commit statements.
Test your code throughly before placing update; commit statements in a source filename.moo file.