A.11 Workspace Object Operation Statements

Table A-18, "Workspace Object Operation Statements" lists the OLAP DML statements that you use for common workspace operations such as defining or deleting the object and defining the contents of the object

Table A-18 Workspace Object Operation Statements

Statement	Description
LOAD	Loads the definition of an OLAP DML program, formula, or model into memory.
CLEAR	Deletes the data that you specify for one or more variables.
GROUPINGID	Populates a previously-defined variable with the grouping ids for the values of a hierarchical dimension.
HIERHEIGHT command	Populates a previously-defined relation with the values of a specified hierarchical dimension by level.
HIERHEIGHT function	Returns the value of a node at a specified level for the first value in the current status list of a hierarchical dimension.
LOAD	Loads the definition of an OLAP DML program, formula, or model into memory.
PERMIT	Controls access to analytic workspace objects by granting or denying read-only and read/write access permission for workspace objects and for specific values of dimensions and dimensioned objects; and by granting or denying permission to maintain dimensions and to change permission for workspace objects.
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.
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.