CONDITION
The CONDITION terminal in the MaxL language represents a conditional expression serving as the test for whether an Essbase database trigger is activated.
The condition is a numeric-value-expression developed in MDX. Enclose strings containing spaces or other special characters in square brackets ([]).
Type
string (see MaxL Syntax Notes)
Example
The following MaxL statement creates a trigger that logs information based on a condition. The CUBE-AREA region to track (after the where clause) and the CONDITION to test for (after the when clause) are expressed using MDX.
create or replace on update trigger Sample.Basic.NYCola where (Jan, Sales, Actual, [100-10], [New York]) when [New York] > 20 then spool EastColas_Fail end;
Referenced By