|Oracle® OLAP DML Reference
11g Release 2 (11.2)
Part Number E17122-05
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.
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
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 block 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, a report on the solution for the final values of the additional dimensions is produced.
When the simultaneous blocks in the model converged when the model was executed for the final values of the additional dimensions, then
MODEL.XEQRPT reports that the blocks were solved, even though an earlier execution of the model for another dimension value might have failed. When you want to see the
MODEL.XEQRPT for the dimension values where the failure occurred, you can set MODERROR to
STOP and rerun the model.
Example 10-65 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.
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.