Skip Headers
Oracle® OLAP DML Reference
10g Release 2 (10.2)

Part Number B14346-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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:

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).