Oracle® OLAP DML Reference 10g Release 1 (10.1) Part Number B1033902 


View PDF 
The MODMAXITERS option determines the maximum number of iterations Oracle OLAP will perform in attempting to solve a block of simultaneous equations in a model.
See: Table 171, "Model Options" for descriptions of all of the options that control the solution of simultaneous blocks. 
Data type
INTEGER
Syntax
MODMAXITERS = {n50}
Arguments
A positive integer value that indicates the maximum number of iterations Oracle OLAP should perform in attempting to solve a simultaneous block. The default is 50
.
Notes
When any equation in a simultaneous block diverges or fails to converge within the number of iterations specified by MODMAXITERS, the solution of the block fails and an error occurs. You can use the MODEL.XEQRPT program to produce a report on the results of the model's execution. The report indicates whether a simultaneous block diverged or failed to converge. When a block failed to converge, you can experiment with increasing the value of MODMAXITERS to see if convergence can be attained.
Increasing the value of MODMAXITERS is just one of the steps you can take in attempting to attain convergence for a simultaneous block. For example, you can also experiment with changing the criteria used in testing for convergence and divergence.
To see the results of each calculation as Oracle OLAP executes a model, set the MODTRACE option to YES
before you run the model. Oracle OLAP records each equation in the current outfile before executing it and then records the results of the calculation in the current outfile. By examining the trace, you can observe progress and problems as they develop during the solution process.
Examples