Triggers provide efficient monitoring of data changes in a database. If data meets conditions specified in a trigger, Essbase can send an email alert to a user or system administrator or record relevant information in a log file. For example, you might want to send an email to the sales manager if, in the Western region, sales for a month fall below sales for the equivalent month in the previous year.
Note: | For aggregate storage databases, only after-update triggers are supported. |
To manage triggers, you must have Database Designer permissions or higher. Essbase monitors and potentially activates triggers during the following activities:
Data load
Calculation
Lock and send from Spreadsheet Add-in
Essbase does not activate triggers during a database restructure. You can see information about enabled and disabled triggers in the application log file for a running Essbase Server.
Note: | To enable Essbase to send e-mail alerts, you must have Java Virtual Machine (JVM) installed. |
“Monitoring Data Changes Using Triggers” in the Oracle Essbase Database Administrator's Guide