Dimension and Composite Operation Statements

Table: Dimension and Composite Operation Statements lists the OLAP DML statements that you use to define the contents of dimensions and composites and to manipulate dimension status.

Statement	Description
ALLSTAT	Sets the status of all dimensions in the current analytic workspace to all their values.
BASEDIM	Returns the name of the dimension from which the current value of a concat dimension comes.
BASEVAL	Returns the values of the base dimensions of a concat dimension. If a base dimension is a concat dimension, then the values of its base dimensions are returned, also.
HIERCHECK	Checks the parent relation of a hierarchical dimension to make sure it has no loops (that is, that no value is specified as its own ancestor or descendant in the parent relation).
INSTAT	Checks whether a dimension or dimension surrogate value is in the current status list or whether a dimension value is in a valueset.
ISVALUE	Tests whether a dimension or a composite has a specified value.
KEY	Returns the value of the specified base dimension for a value of a conjoint dimension or a composite.
LIMIT command	Sets the current status list of a dimension and its dimension surrogates, or assigns values to a valueset.
LIMIT function	Returns the dimension or dimension surrogate values that are currently in status.
LIMIT BASEDIMS	Sets the current status list of one or more base dimension of a composite, conjoint dimension, concat dimension, or a partition template; or assigns a value to one or more valuesets for a base dimensions
MAINTAIN	Adds non-concat dimension values (including temporary calculated members) and composite values; deletes non-concat dimension values and composite values; moves non-concat and concat dimension values; and rename and merges non-concat dimension values.
QUAL	Specifies a qualified data reference (QDR).
SORT	Arranges the order of values in the current status list of a dimension or a dimension surrogate, or in a valueset.
STATALL	Returns YES when default status is currently in effect for a given dimension (that is, when STATLIST would return ALL); or NO when default status is not currently in effect for a given dimension
STATFIRST	Returns the first value in the current status list of a dimension or a dimension surrogate, or in a valueset.
STATLAST	Returns the last value in the current status list of a dimension or a dimension surrogate, or in a valueset.
STATLEN	Returns the number of values in the current status list of a dimension or a dimension surrogate, or in a valueset.
STATLIST	Returns a list of all values in the current status list of a dimension or dimension surrogate, or in a valueset.
STATMAX	Returns the latest value in the current status list of a dimension or a dimension surrogate, or in a valueset.
STATMIN	Returns the earliest value in the current status list of a dimension or a dimension surrogate, or in a valueset.
STATRANK	Returns the position of a dimension or dimension surrogate value in the current status list or in a valueset.
STATUS	Sends to the current outfile the status of one or more dimensions, dimension surrogates, or valuesets, or the status of all dimensions in an analytic workspace.
STATVAL	Returns the dimension value that corresponds to a specified position in the current status list of a dimension or a dimension surrogate, or in a valueset.
TALLY	The number of values of a dimension that correspond to each value of one or more related dimensions.
VALUES	Returns the default status list or the current status list of a dimension or dimension surrogate, or it returns the values in a valueset.