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 the formula in the selected view. |
Table 4-3: Functions available by right-clicking on a formula in the formula palette.