Extra Formula Functions

Navigation:  Formulas >

Extra Formula Functions

Previous pageReturn to chapter overviewNext page

This topic details some of the extra functions that are available from the drop-down box that appears when you right-click on a formula in the formula palette.

A brief description of each of these functions is listed below:

Standard Functions

 

Cut

Removes the operator/value from the formula

Copy

Copies the selected operator/value

Paste

Pastes the operator/value

Delete

Deletes the selected item

Undo

Undoes the previous action (it is possible to undo multiple actions by repeatedly clicking on the undo button)

Redo

Repeats actions that have been undone (you can redo multiple actions by repeatedly clicking on the redo button)

Other Functions

 

Add Argument Above / Below

Inserts a new Argument directly above or below an existing Argument on a unbounded operator. This enables a new Argument to be positioned correctly where order may be important.

Reposition Argument

Unbounded operation arguments can also be moved up and down in order (swapping positions with any operators above/below) using the shortcut keys Ctrl+Shift+Arrow Up/Down.

Add Columns

Specifies the data columns from a table that should be included with the key column for the particular formula

Edit Label

see Formula Label

Edit Comment

see Formula Comments

Presentation

Used in conjunction with the dateTime operator, this function allows you to change the date presentation e.g. Monday January 10 2003 or simply 10/01/2003

Extract as New Formula

Extracts all of the operators/values from the selected argument onwards and will save these as a new formula, which will appear in the customized Schema pane.

The old formula will now have an `ExecuteFormula' operation naming the new formula in the place of the old arguments.

Trace at Runtime

Creates a log of the runtime outputs each time the operation is executed.

Expand Subtree

Expands all child nodes of the node selected

Collapse to immediate Children

Collapse the formula for the selected operator to display only its first level children.

Properties

Opens the Formula Properties window

Logical English View

Switches from the formula palette view to the Logical English view of the formula

Tree View

Switched to the Tree view of the formula

Print

Print the formula in the selected view.

Table 4-3: Functions available by right-clicking on a formula in the formula palette.