Executing Programs Automatically

You can create programs that are automatically executed when you attach an analytic workspace. When you attach an analytic workspace by using the AW 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.

Program Names

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 AUTOGO keyword.

AUTOGO Program Example

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.

AW ATTACH expense AFTER analysis
AW ATTACH revenue AFTER analysis

When you attach the analysis workspace with the following command, its AUTOGO program runs automatically and attaches the other two workspaces.

AW ATTACH analysis AUTOGO

If you named the program ATTACHDATA instead of AUTOGO, you would attach the analysis workspace with the following command.

AW ATTACH analysis AUTOGO attachdata

Note that permission programs are executed before any AUTOGO program is executed.