Oracle® OLAP DML Reference 11g Release 1 (11.1) Part Number B28126-01 |
|
|
View PDF |
The MODEL.XEQRPT program produces a report about the execution of the model. The report specifies the block where the solution failed and shows the values of the model options that were used in solving simultaneous blocks.
Syntax
MODEL.XEQRPT
Notes
Running MODEL.XEQRPT
Before you can run the MODEL.XEQRPT program, you must
Set the MODERROR option to STOP or CONTINUE.
Execute the model.
When the model halts because of an error, run the MODEL.XEQRPT
program.
Effect of MODERROR on MODEL.XEQRPT
The results returned by MODEL.XEQRPT vary depending on the setting of the MODERROR option:
When MODERROR is set to STOP
and execution of the model halts because of an error, you can run the MODEL.XEQRPT program to produce a report about the execution of the model. The report specifies the block where the solution failed and shows the values of the model options that were used in solving simultaneous blocks.
When MODERROR is set to CONTINUE
and one of the blocks in the model is a simultaneous block that either diverges or fails to converge, Oracle OLAP executes any remaining blocks in the model.
Moreover, Oracle OLAP executes the model for the remaining values in the status of any additional dimensions of the solution variable that are not dimensions of the model. In this case, when you run the MODEL.XEQRPT program when Oracle OLAP finishes executing the model, you will see a report on the solution for the final values of the additional dimensions.
When the simultaneous blocks in the model converged when the model was executed for the final values of the additional dimensions, then MODEL.XEQRPT
will report that the blocks were solved, even though an earlier execution of the model for another dimension value might have failed. When you wish to see the MODEL.XEQRPT
for the dimension values where the failure occurred, you can set MODERROR to STOP
and rerun the model.
Examples
Example 10-66 Producing an Execution Report for the income.est Model
After running the income.est model, you can use the MODEL.XEQRPT program to produce a report on the execution of the model.
The following statement runs the MODEL.XEQRPT program, which produces an execution report for the model.
MODEL.XEQRPT income.est
The execution report contains the following output.
MODEL INCOME.EST <LINE MONTH> Solution status: SOLVED Model options in use: MODSIMULTYPE: AITKENS MODMAXITERS: 50 MODTOLERANCE: 3 MODOVERFLOW: 3 MODGAMMA: 1 BLOCK 1 (STEP-FORWARD <MONTH>) Solution status: SOLVED BLOCK 2 (SIMULTANEOUS) Solution status: SOLVED Iterations: 15
The report shows the values of the model options that were used in solving the simultaneous blocks and indicates whether each block was solved.