Oracle9i OLAP Services Developer's Guide to the OLAP DML Release 1 (9.0.1) Part Number A86720-01 |
|
Working with Models, 3 of 8
The INCLUDE command allows you to include one model within another model. A model can contain only one INCLUDE command. The INCLUDE command must come before any equations in the model, and it can specify the name of just one model to include. The model that contains the INCLUDE command is referred to as the parent model. The included model is referred to as the base model.
You can nest models by placing an INCLUDE command in a base model. For example, model M1 can include model M2, and model M2 can include model M3. The nested models form a hierarchy. In this example, M1 is at the top of the hierarchy, and M3 is at the root.
If a model contains an INCLUDE command, then it cannot contain any DIMENSION commands. A parent model inherits its dimensions, if any, from the DIMENSION commands in the root model of the included hierarchy. In the example just given, models M1 and M2 both inherit their dimensions from the DIMENSION commands in model M3.
The INCLUDE command allows you to create modular models. If certain equations are common to several models, then you can place these equations in a separate model and include that model in other models as needed.
The INCLUDE command also facilitates what-if analyses. An experimental model can draw equations from a base model and selectively replace them with new equations. To support what-if analysis, you can use equations in a model to mask previous equations. The previous equations can come from the same model or from included models. A masked equation is not executed.
After you compile a model, either by running it or by using the COMPILE command, you can run an OLAP DML program called MODEL.COMPRPT to produce a report on the structure of the compiled model. If you run MODEL.COMPRPT after compiling a model that contains a masked equation, then you will find that the masked equation is not shown in the report.
For more information, see the following table.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|