Viewing Analytic Workspace Definitions


Table: Statements for Viewing Definitions lists the OLAP DML statements that you can use to view definitions stored in an analytic workspace

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