New/Edit Trigger Dialog Box

  To create or change a trigger:

1. In the New/Edit dialog box, the Database box displays the current database name, in the form essbase_server.database. To create a trigger for a different database, double-click the Triggers node under that database in Enterprise View. You enter a name in the Name field, and then select the Where tab.

2. In Where Condition, enter a Where condition using a valid, symmetric MDX slicer specification, as shown in the following example:

   (Jan, Sales, Actual, [100], East)

   The Where condition is displayed in the Definition box.

   Optionally, select one of the following check boxes:

   • After Update—When selected, creates a trigger that executes after the entire data update operation is complete. When cleared, creates a trigger that executes during a data update process by any cell update that meets conditions specified for the database area.

   • Log Values—When selected, if After Update is cleared, logs new and old values in the spool file specified in the When clause; otherwise this does nothing.

3. Click When Conditions, and in the When box, enter a valid MDX conditional expression to define the condition to be tested, as shown in the following example:

   Jan > 20

4. Specify an action to take when the trigger is activated by selecting one of the following check boxes:

   • Spool—Creates a spool file when the trigger is activated. Enter a name for the file in the Spool text box.

   • Mail—Sends an email when the trigger is activated. Enter the following information:

     • SMTP Server: The name of the SMTP server at your company.

     • To: The e-mail address to send the message when the trigger is activated.

     • From: The e-mail address from which the message is sent. This address defaults to the address of the person who is logged into Administration Services.

     • Subject: The subject line of the message.

     Note:

     To enable Essbase to send email alerts, you must have Java Virtual Machine (JVM) installed on your system and configured for Essbase. You configure Essbase in the essbase.cfg file. See Viewing Configuration File Settings (essbase.cfg) for information on how to verify configuration settings, including JVM.

5. Click Apply to apply the When condition.

6. Optional: Click New to create another When condition and repeat Steps 2 and 3.

7. Optional: To specify an Else condition:

   1. Click Else Clause.

   2. Specify an action to take when the trigger is activated by selecting one of the following check boxes:

      • Spool—Creates a spool file when the trigger is activated. Enter a name for the file in the Spool text box.

      • Mail—Sends an email when the trigger is activated. Enter the following information:

        • SMTP Server: The name of the SMTP server at your company.

        • To: The e-mail address to send the message when the trigger is activated.

        • From: The e-mail address from which the message is sent. This address defaults to the address of the person who is logged into Administration Services.

        • Subject: The subject line of the message.

        Note:

        To enable Essbase to send email alerts, you must have Java Virtual Machine (JVM) installed on your system and configured for Essbase. You configure Essbase in the essbase.cfg file. See Viewing Configuration File Settings (essbase.cfg) for information on how to verify configuration settings, including JVM.

8. Click OK to save the trigger.