| Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-03 |
|
|
View PDF |
The OKFORLIMIT option controls whether you can limit the dimension you are looping over within an explicit FOR loop.
Tip:
To set the status of the dimension you are looping over in a loop that is generated by a REPORT statement, use a TEMPSTAT statement.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 21-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
...