Bookshelf Home | Contents | Index | Search | PDF |
Siebel Marketing Guide > Creating Measures > Custom Measures >
Building Custom Measure Expressions
When creating custom measures, you can use measures listed in the Available Measures list, the operator buttons, the computer's keypad, and the available mathematical and logical function values to build the expression.
The Available Measures list shows:
- Bound measures
- Measures defined within the selected customer hierarchy
- Custom measures not associated with a particular customer hierarchy
Table 34 describes the functions that are available when creating logical custom measure expressions.
Table 35 describes the functions that are available when creating mathematical custom measure expressions.
To add expressions to custom measures
- From the application-level menu, choose View > Site Map > Marketing Administration > Measures.
- In the All Measures list, select a custom measure.
- Click the Custom view tab.
The custom measure's details appear in the form above the expression builder.
- In the Available Measures pane, select a measure and click Add to Expression.
NOTE: To show fields such as measure type and customer hierarchy, click the menu button and choose Columns Displayed.
- To use logical or mathematical functions in the expression:
- Select the category (Mathematical, Logical, or All).
The elements of each function category appear in the pane at right.
- Double-click the function in the elements list.
The function appears in the expression pane at the cursor location.
- Add numerical values to the expression using the computer's keypad.
The values appear at the cursor location in the expression.
When typing numbers greater than 999, do not use digit grouping symbols such as commas or periods. For example, do not type 45,386 (comma separating groups) or 45.386 (period separating groups). Instead, type 45386.
- To build compound expressions, click the operator buttons and add additional measures and expressions.
Make sure to position the cursor where you want to insert the operator before inserting an item.
To use parentheses, select the expression to be contained within the parentheses, and then click the open parenthesis button and the close parenthesis button. Use parentheses whenever possible to isolate pairs of values and an operator.
- When you have finished building the custom measure expression, click Validate & Save.
To delete all or a portion of the expression
- In the Expression Builder pane, select the part of the expression to be removed, and press the Delete key on your keyboard.
To edit the custom measure from this view
- In the Custom form, make changes as needed and save the record.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Marketing Guide, Version 7.5, Rev. A Published: 18 April 2003 |