|Oracle® OLAP DML Reference
10g Release 1 (10.1)
Part Number B10339-02
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 the DEFINE command to create it in an analytic workspace.
There are two types of aggmaps, one for aggregating data and another for allocating data. You can obtain the type of an aggmap by using the AGGMAPINFO function with the MAPTYPE keyword.
When an aggmap is first created, its type is
NA. Once you use either the AGGMAP or the ALLOCMAP command to reference the new aggmap, Oracle OLAP specifies its type. When you use the EDIT command on an aggmap whose type has not yet been specified, OLAP Worksheet assumes that it is to be used for aggregating data.
When you plan to use an aggmap for allocating data, 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'
The ALLOCMAP command causes Oracle OLAP to record the fact that this aggmap is for allocating data.
Example 11-17 Editing a Program
The following statement, executed in the OLAP Worksheet, places the
myprog program in an OLAP Worksheet EDIT window.