Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-03 |
|
|
PDF · Mobi · ePub |
The EDIT command displays an OLAP Worksheet Edit window. The command is available only when you are using OLAP Worksheet to access Oracle OLAP.
For information about using an OLAP Worksheet Edit window, see the OLAP Worksheet Help.
EDIT {PROGRAM|MODEL|AGGMAP|FORMULA} object-name
Indicates whether the object to be edited is a program, a model, an aggmap, or a formula.
A text expression that specifies the name of an existing program, model, aggmap, or formula. Before editing one of these objects, use a DEFINE statement to create it in an analytic workspace.
Editing a Newly Defined Aggmap to Code an Allocation Specification
When an aggmap is first defined it does not have any contents and its type is NA
. When you use the EDIT command for an aggmap whose type has not yet been specified, OLAP Worksheet automatically makes the aggmap an aggregation specification by inserting an AGGMAP statement into the contents of the aggmap.
Consequently, when you plan to use an aggmap as an allocation specification, use the following statements to identify it as an allocation specification before the first time you open an OLAP Worksheet Edit window for it.
CONSIDER aggmap-name
ALLOCMAP 'END'