Common activities of isadmin commands include:
Archive—Archives data from the current period before moving to the next period. Archived data is used for waterfall and other reports. An example is shown in the sample model in install-root/samples/sample. See the JACL script, archives.jacl for details. Integrated Operational Planning uses a snapshot query to output the data and store it in an archive table.
Clear values—Clears user-input values and returns to the original calculated or loaded value. See the weekly script in the sample model in install-root/samples/sample for details.
Snapshot—Exports a slice of the cube using an MDX query. See the archive script in the sample model in install-root/samples/sample for details.
Waterfall reports—Compares a set of data as time moves forward. For example, a waterfall report could compare the forecast for the current quarter and for future quarters. See the weekly script in the sample model in install-root/samples/sample for details.
ETL—Extract-transform-load. Sometimes the data feed is not formatted to go directly into the system. In Integrated Operational Planning, the entry point is the data source. Before pointing the data source to an XLS file, a CSV file, or a table, Integrated Operational Planning uses JACL scripts to do SQL manipulation. See the JACL script, archives.jacl for patterns of SQL activities.
Send e-mail—See the weekly and daily scripts in install-root/samples/sample for examples of sending e-mail notifications. These scripts are entry-level scripts invoked from the client. Sometimes, Integrated Operational Planning must send e-mails from the server (for example, in the middle of the execution of script template or JACL scripts). See JACL Scripts.
Single thread script execution—Prevents concurrent execution of scripts. For example, if you accidentally invoke a daily script twice, you do not want the restructured code to run in two separate threads; instead, you can set exclusive execution of scripts and exclusive access to the shared resources in JACL scripts. See the weekly and daily scripts in the sample model in install-root/samples/sample for details.