SPOOL-NAME

The SPOOL-NAME terminal in the MaxL language represents the name of an Essbase database trigger's output file, located in the trig folder within the database directory.

The name of a trigger's output file, as specified in the THEN or ELSE section of the create trigger statement.

Syntax

name1.name2.name3

Type

name (see MaxL Syntax Notes)

Example

In the following create trigger statement, the bold section is the spool name.

create or replace trigger Sample.Basic.Trigger_Jan_20
where "(Jan,Sales,[100],East,Actual)"
when Jan > 20 and is(Year.currentmember,Jan) then
spool Trigger_Jan_20
end;