![]() Previous |
![]() Next |
Within an allocation specification, a DIMENSION statement sets the status to a single value of a dimension. Within an allocation specification this dimension is a dimension that the source, basis, and target objects do not have in common. When an allocation specification does not specify such single values with DIMENSION statements, Oracle OLAP uses the current status values of the dimensions when performing the allocation.
You use a DIMENSION statement to ensure that the status of a dimension is set to the value that you want it to have for the allocation. You must use a separate DIMENSION statement for each dimension that is not shared by the source, basis, and target objects.
Syntax
DIMENSION dimension 'dimval'
Parameters
the name of the dimension to limit.
The single value of the dimension to which you want the status of the dimension set for the duration of an allocation.
Examples
For an example of using a DIMENSION statement in an allocation specification, see Example: Specifying a Single Dimension Value in an Allocation Specification.