|Oracle9i OLAP Developer's Guide to the OLAP DML
Release 2 (9.2)
Part Number A95298-01
Defining and Working with Analytic Workspaces, 6 of 9
You can create programs that are automatically executed when you attach an analytic workspace. When you attach an analytic workspace by using the
ATTACH command with the
AUTOGO keyword, the workspace is searched for a program named
AUTOGO. If it exists, then the program is executed before commands are accepted. If you do not specify the
AUTOGO keyword, or if you specify the
NOAUTOGO keyword, the program is not automatically executed.
If you have a program named
AUTOGO in more than one currently attached analytic workspace (and thus multiple programs with the same name), then you must use their qualified object names when you edit them to ensure that you are accessing the correct one.
You do not have to name a program
AUTOGO to have it automatically execute when you specify the
AUTOGO keyword. Instead, you can use the
AUTOGO keyword with the name of the program that you want executed. Even if a program named
AUTOGO exists in the analytic workspace, Oracle OLAP executes the program you specify with the
Suppose you have two analytic workspaces of sales data, one for expenses and one for revenue. You have a third analytic workspace called
analysis that contains programs that analyze the data. In the
analysis workspace, you can have an
AUTOGO program that includes the following two lines of code for attaching the other two workspaces.
When you attach the
analysis workspace with the following command, its
AUTOGO program runs automatically and attaches the other two workspaces.
If you named the program
ATTACHDATA instead of
AUTOGO, you would attach the
analysis workspace with the following command.
Note that permission programs are executed before any
AUTOGO program is executed.