|Oracle® OLAP DML Reference
11g Release 2 (11.2)
Part Number E17122-05
The MODEL.DEPRPT program produces a report that lists the variables and dimension values on which each model equation depends. When a dependence is dimensional, the report gives the name of the dimension.
Example 10-64 Producing a Dependency Report
The MODEL.DEPRPT program produces a dependency report that lists the variables and dimension values that are the assignment target and data sources for each model equation. For each equation, the assignment target and each data source is listed on a separate line. When a target or data source is a dimension value, its line is marked by an asterisk enclosed in square brackets (
When a target or data source depends on a qualifier, the report specifies the dimension of the qualifier and indicates the type of dependence. The type of dependence can be any of the following:
LAG -- One-way dependence on previous dimension values
LEAD -- One-way dependence on later dimension values
BOTH -- Two-way dependence on both previous and later values
VARIABLE -- Dependence on either previous or later values, depending on the value of a variable when the model is run
QDR -- Qualified data reference
Assume that you want to produce a dependency report for the
income.budget model. The following statement and report illustrate this process.
MODEL.DEPRPT income.budget MODEL INCOME.BUDGET <LINE MONTH> 2 [*](LINE OPR.INCOME): [*](LINE GROSS.MARGIN) [*](LINE MARKETING) 3 [*](LINE GROSS.MARGIN): [*](LINE REVENUE) [*](LINE COGS) 4 [*](LINE REVENUE): [*](LINE REVENUE)(LAG <MONTH>) 5 [*](LINE COGS): [*](LINE COGS)(LAG <MONTH>) 6 [*](LINE MARKETING): [*](LINE OPR.INCOME)(LAG <MONTH>)
The data sources in statements 4, 5, and 6 have a LAG dependence on the