Editing OLAP DML Programs, Models, Formulas, and Aggmaps

One of the strengths of the OLAP DML is that you can use it to define OLAP DML program, model, formula, and aggmap objects. These objects, often referred to collectively as Ócalculation objects,Ó specify how Oracle OLAP should perform different calculations.

You can open the specifications of OLAP DML calculation objects in OLAP Worksheet Edit windows so that you can modify their content and save the changes. However, the specification of an object can appear in only one Edit window at a time.

To edit the contents of an OLAP DML calculation object, take the following steps:

1. (Allocation specifications only) When you plan on using an aggmap object for allocating data and you are opening an Edit window for the allocation specification for the first time, type the following commands in the input pane of the Command Input window.

              CONSIDER aggmap-name
              ALLOCMAP 'end'
   
   

2. In the Query (bottom) pane of the Command Input window, type an OLAP DML EDIT statement using the following syntax.

              EDIT {PROGRAM|MODEL|AGGMAP|FORMULA} object-name
   
   

   The content of the object appears in an Edit window, with color coding of OLAP DML commands and other code enabled if Color Coding is selected in the Option menu.

3. Add, modify, or delete the content in the Edit window. Once the object is modified, Changed appears in the status bar of the Edit window.

4. Choose File > Save to save your changes.

5. (Optional) Choose File > Print to print the specification. A print settings box appears. Specify settings and properties for the print job. The name of the object appears at the top and the page number appears at the bottom of the printed page. Text is printed in the standard font.

6. Choose File > Exit to close the Edit window. (Note that if have not already saved the changes you made to the object in the Edit window, OLAP Worksheet reminds you to save the changes.)