Oracle9i OLAP Developer's Guide to the OLAP DML Release 2 (9.2) Part Number A9529801 

Working with Models, 6 of 8
When you run a model, you should keep these points in mind:
income.calc
model (shown earlier in this chapter) with actual
as the solution variable, you must have current data in the revenue
, cogs
, marketing
, selling
, r.d
, and taxes
line items of actual
.LAG
function), then the solution variable must contain data for these previous periods. If it does not, or if the first value of the time dimension is in the status, then the results of the calculation will be NA
.Several OLAP DML functions make it easy for you to use data from past or future time periods. For example, the LAG
function returns data from a specified previous time period, and the LEAD
function returns data from a specified future period. The Oracle9i OLAP DML Reference help lists some builtin functions that are useful in analyzing financial data.
When you run a model that uses past or future data in its calculations, you must make sure that your solution variable contains the necessary past or future data. For example, a model might contain an assignment statement (that is, the =
command) that bases an estimate of the revenue
line item for the current month on the revenue
line item for the previous month.
DIMENSION line month . . . revenue = LAG(revenue, 1, month) * 1.05
If the month
dimension is limited to apr96
to jun96
when you run the model, then you must be sure that the solution variable contains revenue
data for mar96
.
If your model contains a LEAD
function, then your solution variable must contain the necessary future data. For example, if you want to calculate data for the months of April through June of 1996, and if the model retrieves data from one month in the future, then the solution variable must contain data for July 1996 when you run the model.
An iterative method is used to solve the equations in a simultaneous block. In each iteration, a value is calculated for each equation, and compares the new value to the value from the previous iteration. If the comparison falls within a specified tolerance, then the equation is considered to have converged to a solution. If the comparison exceeds a specified limit, then the equation is considered to have diverged.
If all the equations in the block converge, then the block is considered solved. If any equation diverges or fails to converge within a specified number of iterations, then the solution of the block (and the model) fails and an error occurs.
You can use OLAP DML options to exercise control over the solution of simultaneous equations. For example, you can specify the solution method to use, the factors to use in testing for convergence and divergence, the maximum number of iterations to perform, and the action to take when the =
command diverges or fails to converge.

Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. 
