| Oracle® OLAP DML Reference 10g Release 2 (10.2) B14346-03 |
|
|
PDF · Mobi · ePub |
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.BOOLEAN
OKFORLIMIT = {NO|YES}
(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.
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
...