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 ...