Display Trigger

View details about 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: The application containing the trigger must be started in order to use display trigger.

Syntax

Output Columns

application database name definition enabled
The name of the application that contains the database. The name of the database that contains the trigger. Essbase lists only databases that contain triggers. The name of the trigger. The MaxL trigger statement (for example, create or replace trigger) Whether Essbase is set to monitor the trigger. Values: TRUE or FALSE. To change the value, use alter trigger.

Examples

display trigger on database Sample.Basic;

This example displays the output columns:

application database name definition enabled
Sample Basic WatchCosts create or replace trigger TRUE

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com