Oracle9i OLAP Services Developer's Guide to the OLAP DML Release 1 (9.0.1) Part Number A86720-01 |
|
Defining and Working with Analytic Workspaces, 10 of 12
You can create programs that are automatically executed when you attach an analytic workspace. When you attach an analytic workspace by using the DATABASE command without the ATTACH keyword, the workspace dictionary is searched for a program named AUTOGO. If it exists, then the program is executed before commands are accepted. You can use the NOAUTOGO keyword to specify that the AUTOGO program should not be executed.
You do not have to name a program AUTOGO to have it automatically execute when you attach an analytic workspace. You can use the AUTOGO keyword with the DATABASE command to specify that a program will be automatically executed with some name other than AUTOGO when you attach an analytic workspace. Even if a program named AUTOGO exists in the analytic workspace, the program you specify is still used after the AUTOGO keyword instead.
Analytic workspace permission programs are executed before any AUTOGO program that is associated with the analytic workspace is executed. For more information on permission programs, see "Adding Security to an Analytic Workspace". For information on writing and debugging OLAP DML programs, see Chapter 8 and Chapter 9.
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.
The analysis
analytic workspace has the following AUTOGO program, which attaches the other two analytic workspaces.
database attach expense after analysis database attach revenue after analysis
Suppose that you write a program named ATTACH_DBS that attaches the analytic workspaces you want an application to use. You can run it when attaching the main analytic workspace, called analysis
, with the following command.
database autogo attach_dbs analysis
If you named the program AUTOGO, you could run the program automatically with the following command.
database analysis
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|