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

Working with Models, 4 of 8
The following table lists the most common OLAP DML commands that you will use when you define and run models.
When you write the equations in a model, you should keep these points in mind:
When you write DIMENSION
and INCLUDE
commands, you should keep these points in mind:
DIMENSION
commands or INCLUDE
command must come before the first equation in a model.DIMENSION
commands, you must list the names of all the dimensions on which model equations are based. In the following example, gross.margin
, revenue
, and cogs
are values of the line
dimension, so line
is specified in a DIMENSION
command.
DIMENSION line gross.margin = revenue  cogs
DIMENSION
commands must also list any dimension that is an argument to a function that refers to a dimension value. In the following example, month
must be specified in a DIMENSION
command.
DIMENSION line, month revenue = LAG(revenue, 1, month) * 1.05
INCLUDE
command, then it cannot contain any DIMENSION
commands. The included model (or the root model in a hierarchy) must contain the DIMENSION
commands needed by the parent model(s).DIMENSION
commands. The nontarget dimension listed first in the DIMENSION
commands is treated as the slowestvarying dimension.DIMENSION
commands and the dimensions of the solution variable:
DIMENSION
commands and as the last dimension in the definition of the solution variable.DIMENSION
commands, list the nontarget dimensions in the reverse order of their appearance in the definition of the solution variable. This means that the nontarget dimensions will have the same order in the model and in the solution variable in terms of fastestvarying and slowestvarying dimension.DIMENSION
commands.DIMENSION
commands are used to determine whether each name reference in an assignment statement (that is, the =
command) is a variable or a dimension value. "Compiling a Model" explains how the name references are resolved.

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