Working with Previously-Defined Analytic Workspaces

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.

Viewing Analytic Workspace Definitions

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
AW function	Returns information about currently attached workspaces.
EXISTS	Returns a value that indicates whether an object is defined in any attached workspace.
LISTBY	Lists all objects in a workspace that are dimensioned by or related to one or more specified dimensions or composites.
LISTNAMES	Lists the names of the objects in a workspace.
OBJ	Returns information about a workspace object.
OBJLIST	Lists the objects that in one or more workspaces that you specify.
AWDESCRIBE	Sends information about the current analytic workspace to the current outfile.
DESCRIBE	Lists the base definition of one or more workspace objects.
FULLDSC	Lists the definition of one or more workspace objects, including the properties and triggers of the object(s).