Siebel Marketing Guide > Creating Measures > Aggregation and Restrictions for Custom Measures >

Adding Restrictions to Custom Measures

Build a restriction for the measure using the custom measure Restriction view. This view provides information about the selected custom measure in the form and allows you to select attribute hierarchies and buckets to use as restrictions from the Restriction tree. When you select a specific value from an Attribute Hierarchy or Bucket, you restrict the aggregation to records with the selected value.

Table 36 provides examples of custom measure aggregations and restrictions.

Table 36. Custom Measure Restrictions
Measure Name
Level
Aggregation Function
Expression
Restricted to
Result
Monthly Account Usage
Account
Sum
Transactions
2001 (from a time-based attribute hierarchy)
Only aggregates transactions that occur during 2001
Number of Customer Withdrawals
Customers
Sum
Transactions per Account
Transaction Type = Withdrawal
Only aggregates transactions of type withdrawal

To apply restrictions to custom measures

  1. From the application-level menu, choose View > Site Map > Marketing Administration > Measures.
  2. In the All Measures list, select the custom measure, and drill down on the measure name.
  3. Click the Restriction view tab.
  4. In the Restriction tree pane, expand the folders for Attribute Hierarchies and Buckets to display values.
  5. Select a value:
    1. To include a value, click a value's check box and a check mark appears.
    2. To exclude a value, clear the check mark by clicking on it.
    3. To select values in a range of values, click Select Group and select the range of values.

      4. Selected attributes have a check mark.


 Siebel Marketing Guide, Version 7.5, Rev. A 
 Published: 18 April 2003