Alter Trigger

Enable or disable a trigger created to track state changes over a selected cube area. For more information about the Analytic Services triggers feature, see the Database Administrator's Guide.

Syntax

Note: You can disable all triggers by setting the TRIGMAXMEMSIZE configuration file setting to zero (0).

Examples

alter trigger Sample.Basic.WatchCosts disable;

alter trigger on database sample.basic disable;

Descriptions

Use alter trigger to edit triggers in the following ways:

Key Phrase Explanation
enable Analytic Services monitors the trigger during data load, calculation or lock and send. Analytic Services performs the trigger action when the specified condition is met on the specificed cube area.
disable Analytic Services does not monitor the trigger.
on database <DBS-NAME> disable Analytic Services disables all triggers currently enabled 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).

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com