|Oracle® OLAP DML Reference
10g Release 2 (10.2)
|PDF · Mobi · ePub|
The LIMIT BASEDIMS command sets the current status list of one or more base dimensions of a composite, conjoint dimension, concat dimension, or a partition template based on the selected values of that object. You can also use the LIMIT BASEDIMS command to assign a value to one or more valuesets for the base dimensions.
Values that are in the current status list of a dimension are said to be "in status." The status of the base dimensions of a composite, conjoint dimension, concat dimension, or a partition template is determined by the current status of its base dimensions.
See also:For more information on working with dimension status, see "Making Selections and Working with Subsets of Data" and. "LIMIT command".
LIMIT BASEDIMS [dimlist] TO object [ [KEEP] limit-clause ]
A space-delimited list of objects that identifies the base dimensions for which you want Oracle OLAP to change status and the valuesets for which you want Oracle OLAP to add values. Within dimlist, you can specify the following values:
The default value of dimlist is the completely expanded list of the base dimensions of object.
The name of a composite, a conjoint dimension, a concat dimension, or a partition template object.
Specifies that Oracle OLAP performs the selection based on the current dimension status of the base dimensions of the object. KEEP preserves the current order of values among the values that remain in the status.
Specifies how Oracle OLAP should select values from object to modify the current status lists of the base dimensions. You can specify any of the non-positional limit clauses described for the LIMIT command. For the syntax of these clauses, see:
When this optional argument is not specified, Oracle OLAP sets the status of the base dimensions to the current status of the dimensions.