Creating Calculation Objects

The general process of creating a calculation specification object is the following two step process:

1. Define the calculation object using the appropriate DEFINE statement.

2. Add the calculation specification to the object definition. You can add the calculation specification to the definition of a calculation object in the following ways:

   • At the command line level of the OLAP Worksheet, in an input file, or as an argument to a PL/SQL function. In this case, ensure that the object is the current object (issue a CONSIDER statement, if necessary), and, then, issue the appropriate statement that includes the specification as a multiline text argument. To code the specification as a multiline text, you can use a JOINLINES function where each of the text arguments of JOINLINES is a statement that specifies the desired processing, and where the final statement is END.

   • In an Edit Window of the OLAP Worksheet. In this case, at the command line level of the OLAP Worksheet, issue an EDIT statement with the appropriate keyword. This opens an Edit Window for the specified object. You can then type each statement as an individual line in the Edit Window. Saving the specification and closing the Edit Window when you are finished.

Table 3-1 outlines the OLAP DML statements that you use to create each type of calculation specification.