![]() Previous |
![]() Next |
The DEFINE command with the MODEL keyword adds a new model object to an analytic workspace. A model is a set of interrelated equations. The calculations in an equation can be based either on variables or on dimension values. You can assign the results of the calculations directly to a variable or you can specify a dimension value for which data is being calculated. For example, in a financial application, all the equations might be based on the values of a line item dimension, and data would be calculated for line items such as total expenses and net income.
Note: Defining a model merely creates a model object in the analytic workspace. You must also code a specification for the model, as described in MODEL. |
Syntax
DEFINE name MODEL [AW workspace] [SESSION]
Parameters
The name of the object you are defining. For general information about this argument, see the main entry for the DEFINE command.
The object type when you are defining a model.
The name of an attached workspace in which you want to define the object. For more information about this argument, see the main entry for the DEFINE command.
Specifies that the object exists only in the current session. When you close the current session, the object no longer exists.
Examples
Defining a Simple Model
This example shows a simple model named income.calc
that calculates the line items in an income statement. The model equations are based on the line
dimension in the demo
workspace. First, define the model and give it an LD.
DEFINE income.calc MODEL LD Model for calculating Income Statement items
Then use a MODEL statement to enter the specification for the model. For this example, you can enter model lines such as the ones in the following model description.
DEFINE income.calc MODEL LD Model for calculating Income Statement items MODEL dimension line net.income = opr.income - taxes opr.income = gross.margin - (marketing+selling+r.d) gross.margin = revenue - cogs END
To solve the model for the actual
variable, enter data in actual
for the input line items (Revenue
, Cogs
, Marketing
, Selling
, R.D
, and Taxes
). Then execute the following statement.
income.calc actual