Siebel Marketing Guide > Creating Measures >

Aggregation and Restrictions for Custom Measures


External Data Mapping explains customer hierarchies, and targeting levels within a hierarchy. Using measures, you can extend these concepts with aggregation and restrictions.

Aggregation determines how a custom measure is calculated. If you want to aggregate a custom measure, make sure you select a customer hierarchy and targeting level when creating the custom measure because aggregation is tied to the targeting level. After you have chosen a hierarchy and targeting level, an aggregation function is required.

Restrictions allow you to limit a measure to a portion of the data and the rest of the records in the table are ignored when the measure is computed. For example, you might want to restrict data to a geographic region by ZIP (Postal) Code, or by a time period. The restriction applies to any related measure that uses this restricted custom measure. The restrictions can be defined by buckets or attribute hierarchies that belong to the selected customer hierarchy and targeting level.

NOTE:  A measure used at the bucket level should be aggregated to the same level as the bucket. Attempting to use data at a lower level will cause undesired results.


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