You use the Database Triggers window to view, create, edit, enable, disable, and delete triggers.
The window identifies theEssbase Server instance and the database for which the listed triggers are defined.
Note: | To view triggers defined for a different database, in Enterprise View, below the name of the preferred database, click the Triggers node. |
The columns of the window provide information about each trigger that is listed:
Name—For example, Sample.Basic.EastColas
Definition—MaxL commands and MDX syntax
Enabled—TRUE or FALSE
The window provides the following buttons:
New—To create a trigger
Edit—To open the Edit Trigger Dialog box, which you use to edit the selected trigger
Note: | You can also open the Edit Trigger dialog box by double-clicking a trigger. |
Enable—To enable the selected disabled trigger
Suspend All—To disable all triggers for the duration of the database session. When the application is closed, triggers revert to the value (enabled or disabled) that they had before Suspend All was clicked.
Delete—To delete the selected trigger
Refresh—To update trigger information
“Monitoring Data Changes Using Triggers” in the Oracle Essbase Database Administrator's Guide
create trigger (MaxL) in the Oracle Essbase Technical Reference
display trigger (MaxL) in the Oracle Essbase Technical Reference
drop trigger (MaxL) in the Oracle Essbase Technical Reference