Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
|
|
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). |