![]() Previous |
![]() Next |
The LIMIT command sets the current status list of a dimension and its dimension surrogates, or assigns values to a valueset.
A LIMIT command with the POSLIST keyword sets the status of a dimension based on the position of the values within that dimension.
Syntax
LIMIT {dimension | valueset} [concat-component] limit-type -
POSLIST poslist-exp [IFNONE label]
Parameters
The name of the dimension or dimension surrogate for which you are setting status.
The name of the valueset for which you are assigning values; or a LIMIT function.
The name of the component of the concat dimension whose values are used to determine the limit. (See the main entry for LIMIT command for complete description of this argument.)
A standard keyword (documented in the main entry for LIMIT command) that specifies how Oracle OLAP should modify the current status list.
Sets the status of a dimension based on the position of a value within a dimension. poslist-textexp is a text expression, each line of which is a numeric value that evaluates to a numeric position of the dimension being limited.
Specifies that program execution should branch to label when the requested status has null status or is based on a related dimension that turns out to have null status (that is, to have no values). (See the main entry for LIMIT command for complete description of this phrase.)