Skip Headers

Oracle® OLAP DML Reference
10g Release 1 (10.1)

Part Number B10339-02
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
Feedback

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

A.12 Dimension and Composite Operation Statements

Table A-19, "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.

Table A-19 Dimension and Composite Operation Statements

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