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.
Note: You can disable all triggers by setting the TRIGMAXMEMSIZE configuration file setting to zero (0).
alter trigger Sample.Basic.WatchCosts disable;
alter trigger on database sample.basic disable;
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 |