Oracle® OLAP DML Reference 10g Release 1 (10.1) Part Number B10339-02 |
|
|
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
You cannot limit the dimension you are looping over within an explicit FOR loop. (Default)
You can limit the dimension you are looping over within an explicit FOR loop.
Notes
See the TEMPSTAT command to set the status of the dimension you are looping over in a loop that is generated by a REPORT command.
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 ...