Syntax

• TRIGGER-NAME

• DBS-NAME

Use MaxL alter trigger to edit triggers in the following ways:

Keywords

alter trigger TRIGGER-NAME 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.

Example:

alter trigger Sample.Basic.WatchCosts enable;

alter trigger TRIGGER-NAME disable

Essbase does not monitor the trigger.

Example:

alter trigger Sample.Basic.WatchCosts disable;

alter 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 on database sample.basic disable;