Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-02 |
|
|
View PDF |
Before you can work with a previously-defined analytic workspace, you must first attach in by issuing an AW ATTACH statement. You can attach an analytic workspace in any of the following attachment modes:
Read-only. Users can make private changes to the data in the workspace to perform what-if analysis but cannot commit any of these changes.
Read/write access mode. Only one user can have an analytic workspace open in read/write at a time. The user has to commit either all or none of the changes made to the workspace.
Read/write exclusive access mode. The read/write exclusive attach mode is not compatible with any other access modes. A user cannot attach an analytic workspace in read/write exclusive mode when another user has it attached in any mode. Only one user can have an analytic workspace open in read/write exclusive at a time. The user has to commit either all or none of the changes made to the workspace.
Multiwriter access mode. A workspace that is attached in multiwriter mode can be access simultaneously by several sessions. In multiwriter mode, users can simultaneously modify the same analytic workspace in a controlled manner by specifying specify the attachment mode (read-only or read/write) for individual variables, relations, valuesets, and dimensions.
See:
Table A-23, "Statements for Managing Objects When Attached in Multiwriter Mode" for a list of the OLAP DML statements that you use to manipulate objects in an analytic workspace that is attached in multiwriter mode.For more information on the various attachment modes, see the syntax and notes for the AW ATTACH statement.
Table 1-4, "Statements for Viewing Definitions" lists the OLAP DML statements that you can use to view definitions stored in an analytic workspace
Table 1-4 Statements for Viewing Definitions
Statement | Description |
---|---|
|
Returns information about currently attached workspaces. |
Returns a value that indicates whether an object is defined in any attached workspace. |
|
|
Lists all objects in a workspace that are dimensioned by or related to one or more specified dimensions or composites. |
Lists the names of the objects in a workspace. |
|
Returns information about a workspace object. |
|
|
Lists the objects that in one or more workspaces that you specify. |
|
Sends information about the current analytic workspace to the current outfile. |
|
Lists the base definition of one or more workspace objects. |
|
Lists the definition of one or more workspace objects, including the properties and triggers of the object(s). |