Transforms Area
The Transforms area displays the transforms associated with the current dataset (if derived).
An icon identifies each transform. You can add or modify transforms by adding one or more transform icons into the Transforms area and then linking them.
Note:
Because of restrictions in the transformation language, some elements must be the first transform in the series. In other words, the input must be external data sources, not other transforms.Conversely, some transforms require other transforms as input and cannot be the first transformation in the series. To define transforms within a dataset, you must create at least one dataset. The system builds the new dataset by adding transforms to the grid, linking the transforms, and defining transform properties or variables.
Join is the only transform that requires establishment of more than one source dataset. Therefore, it is possible to use all transforms within a single dataset. You can use more than one Dataset Source, Derive New Attributes, or Filter transform within one dataset.
The following defines transforms:
Table 5-2 Transforms
| Tranform | Description |
|---|---|
|
Figure 5-2 DataSet Source  |
DataSet Source: Specifies a dataset to use as input to the current dataset. |
|
Figure 5-3 Join DataSets  |
Join DataSets: Specifies linking between the selected sources (tables and views). |
|
Figure 5-4 Derive New Attributes  |
Derive New Attributes: Enables derivation of a new attribute from existing attributes. |
|
Figure 5-5 Filter Elements  |
Filter Elements: Enables creation of a filter, or restrictive clause,
where an operator and a specified value follow a specified
attribute.
For example, APPRAISED_VALUE 200000 |
As your cursor moves over a transform, a tooltip appears below. When you click a transform, an icon displays in the grid in the first available square (from left to right).
You can move transforms by dragging the icon to a desired grid box. Releasing the left mouse button displays the icon button in the designated box.
Oracle Financial Services Transforms Syntax
Table 5-3 TransformsSyntax Definitions
| Meaning | Syntax | KeyboardKeys/Proper Syntax |
|---|---|---|
| not operator | ! | SHIFT-1 |
| equals | = | = |
| not equal | != | SHIFT-1 = |
| greaterthan | > | SHIFT-period |
| greaterthan or equal to | ³ | SHIFT-period-= |
| lessthan | < | SHIFT-comma |
| lessthan or equal to | £ | SHIFT-comma-= |
| addition | + | SHIFT-= |
| subtraction | - | -- |
| multiplication | * | SHIFT-8 |
| division | / | Forwardslash |
| exponentiation | ^ | SHIFT-6 |
| nullcomparison | isNULL<attrib ute> | is-Caps lock-NULL |
| Whenevaluating expressions together | () | SHIFT-9 <expressions> SHIFT-0 |
| variablenames | $ | SHIFT-4<variable> |
| strings | ‘‘ | SHIFT-singlequote <string> SHIFT- singlequote |
When working in the Transforms area, you are working in graphical mode. When working in the SQL area, you are working in SQL mode (refer to SQL Area, for more information).
Transforms Usage Tips
Use the following guidelines when working in the Transforms area:
- To display a transform operator in the first available cell within the grid in
the Transforms area, click the transform icon.
- To link transforms, hold the Shift key and then click and hold the left mouse button on top of the first icon. Then drag the mouse to the second icon to form the link.
- When linking the transformation operators and the line between the two transforms displays red, you cannot link the transform operators.
- If the line is green, however, you can link the transform operators.
- When you release the Shift key and the left mouse button, a line connects the two icons.
- To save a new dataset, you must select attributes for the dataset.
- When you use the Derive New Attributes transform operator, the system automatically adds the attributes to your dataset when you successfully complete the edit dialog boxes associated with each function.
For other tips and guidelines, see Scenario Design Guidelines.