|Oracle9i OLAP Developer's Guide to the OLAP DML
Release 2 (9.2)
Part Number A95298-01
Selecting Data, 6 of 13
You can use the
LIMIT command to limit a dimension to the values of one or more related dimensions. The simplified syntax for using the
LIMIT command in this way is shown below:
reldim argument is the name of a relation or a dimension that is related to the dimension being limited. Using a relation name allows you to choose which relation is used when there is more than one.
reldim-val argument is a list of values of the related dimension, and not the dimension being limited. If this argument is present in a
LIMIT command, then status is obtained by selecting the values of the dimension being limited, which are related to related values. If reldim-val is omitted, then the current status of
reldim is used.
The following command limits
ATLANTA, which are in the
This command limits
FOOTWEAR, which are in the division that appears last in the list of
When you limit a dimension to a related dimension, the current status list is created in a two-step process:
LIMIT.SORTREL option controls whether or not a sort is done when you limit a dimension to a related dimension. You can suppress the sort that occurs when you limit a dimension to a related dimension by setting
no. This can significantly improve performance when the dimension you are limiting is large.