| Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
|
|
View PDF |
The OKFORLIMIT option controls whether you can limit the dimension you are looping over within an explicit FOR loop.
Data type
BOOLEAN
Syntax
OKFORLIMIT = {NO|YES}
Arguments
(Default) You cannot limit the dimension you are looping over within an explicit FOR loop.
You can limit the dimension you are looping over within an explicit FOR loop.
Examples
Example 19-14 Allowing Limits Within a Loop
The following program excerpt sets OKFORLIMIT to YES, thereby allowing the user to limit market within a FOR loop.
...
OKFORLIMIT = YES
FOR market
DO
LIMIT market TO CHILDREN USING market.market
REPORT market
DOEND
...