Workspace Object Definition Statements

Table: Workspace Object Data Definition Statements lists the OLAP DML statements that you use to create basic definitions of analytic workspace objects and to change and view analytic workspace object definitions. Table: OLAP DML Statements for Extending Object Definitions lists the OLAP DML statements that you use to extend the basic definitions created using a DEFINE statement.

Workspace Object Data Definition Statements

Statement	Description
CHGDFN	Changes certain aspects of the definitions of certain objects.
CONSIDER	Identifies a definition as the current definition. This enables you to add a description, property, calculation specification, or trigger (event) to an object.
COPYDFN	Defines a new object in the analytical workspace and uses the same definition as a specified object in the current workspace or in an attached workspace.
DEFINE	Adds a new object to the analytic workspace.
DELETE	Deletes one or more objects from a workspace.
MOVE	Moves an object name to a new position in the NAME dimension of a workspace.
PERMITRESET	Causes the values of permission conditions to be reevaluated. Permission conditions consist of one or more Boolean expressions that designate the criteria used by PERMIT commands associated with an object.
RENAME	Changes the name of an object in an analytical workspace and updates associated objects.
VALSPERPAGE	Calculates the maximum number of values for a variable of a given width that will fit on one page. Pages are units of storage in the workspace.

OLAP DML Statements for Extending Object Definitions

Statement	Attribute Added	Object Extended
AGGMAP	aggregation specification	aggmap object
ALLOCMAP	allocation specification	aggmap object
EQ	calculation specification	formula
LD	long description	any object
MODEL	calculation specification	model
PERMIT	permissions	any object
PROGRAM	calculation specification	program
PROPERTY	property	any object
RELATION command	default relation	any dimensioned object
TRIGGER command	triggers (also called events)	any object
VNF	a template that controls the input and display format for values of the dimension	dimension with a type of DAY, WEEK, MONTH, QUARTER, or YEAR