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

Alter Trigger

The MaxL alter trigger statement helps you enable or disable a trigger to track state changes over a selected Essbase cube area.

Syntax


Description of alttrig.gif follows
Description of the illustration alttrig.gif

Use alter trigger to edit triggers in the following ways:

Keywords

enable

Essbase monitors the trigger during data load, calculation, or lock and send, and performs the trigger action when the condition is met on the specified cube area.

disable

Essbase does not monitor the trigger.

on database <DBS-NAME> disable

Disables all triggers in the database. A restart of the application or the database following the disable restores the triggers to the same state as before the disable was issued (all the triggers disabled using alter trigger on database DBS-NAME disable are re-enabled).

Example

alter trigger Sample.Basic.WatchCosts disable;
alter trigger on database sample.basic disable;