Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-02 |
|
|
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 ...