EDIT

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.

Syntax

EDIT [PROGRAM|MODEL|AGGMAP|FORMULA] object-name

Arguments

PROGRAM

MODEL

AGGMAP

FORMULA

Indicates whether the object to be edited is a program, a model, an aggmap, or a formula.

object-name

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.

Notes

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.

Examples

EDIT myprog

EDIT MODEL myModel