AW command |
The syntax of the AW command varies depending on the task that you want to perform.
Notes
Triggering Program Execution When an AW Statement Executes
When a program named TRIGGER_AW exists in the analytic workspace, the execution of any AW ATTACH, AW CREATE, AW DELETE, or AW DETACH statement automatically executes that program. See "Trigger Programs" and TRIGGER_AW, for more information.
When an AW ATTACH statement executes Oracle OLAP checks for other programs as well. See "Programs Executed When Attaching Analytic Workspaces" for more information.
Options Related to Analytic Workspace Management
Table: Options Related to Working with Analytic Workspaces lists the options that you might want to reset before you either create or attach an analytic workspace.
EXPRESS Workspace
When your database is installed with the OLAP option, the EXPRESS workspace is always attached in read-only mode in your session. It never automatically becomes the current workspace, even when it is the first or only workspace in your workspace list, because it is for internal use by Oracle OLAP. You can make the EXPRESS workspace the current workspace by explicitly attaching it, but this is not recommended. You cannot detach the EXPRESS workspace.