1. Scripting Reference for Oracle Essbase
  2. MaxL
  3. MaxL Statements
  4. MaxL Statement Reference
  5. Display Trigger Spool

Display Trigger Spool

The MaxL display trigger spool statement helps you view log files generated by triggers that track changes to selected Essbase cube areas.

For more information about triggers, see Examples of Triggers.

Syntax


Description of disptrigspool.gif follows
Description of the illustration disptrigspool.gif

Keywords

You can display trigger output (spool) files in the following ways using MaxL display trigger_spool.

display trigger_spool [all]

Display all triggers defined on the Essbase Server.

Example:

display trigger_spool;
display trigger_spool on application APP-NAME

Display all trigger spools for the specified application.

Example:

display trigger_spool on application Sample;
display trigger_spool on database DBS-NAME

Display all trigger spools for the specified cube.

Example:

display trigger_spool on database Sample.Basic;
display trigger_spool SPOOL-NAME

Display a trigger spool by name.

Example:

display trigger_spool Sample.Basic.EastColas_alert;