You can create triggers to monitor data changes in a database. You need Database Manager permissions or higher to create a trigger.
You cannot create a trigger during a calculation or a data load (including a lock and send).
Note: | You cannot define a trigger that requires data from Dynamic Calc members, hybrid analysis members, or members from another partition. |
To create a trigger:
From Enterprise View or a custom view, select a database.
Right-click and select Edit, then Triggers.
In the Database Triggers window, click New.
In the New Trigger dialog box, enter the appropriate information in each text box.
Click OK.
Essbase creates the trigger and displays it in the Database Triggers window. The trigger is activated when its conditions are met during the following activities:
Data load
Calculation
Lock and send from Spreadsheet Add-in (does not apply to aggregate storage databases or to after-update triggers in block storage or aggregate storage databases)
“Monitoring Data Changes Using Triggers” in the Oracle Essbase Database Administrator's Guide
create trigger (MaxL) in the Oracle Essbase Technical Reference