Bookshelf Home | Contents | Index | Search | PDF

Siebel Marketing Guide > Defining Attributes and Buckets > Defining Bucket Values >

Building Rollups for Buckets

---

Frequently, you need to have both a set of buckets and a total for the bucket values. To create a rollup, you have to construct a bucket that uses the same base measure as the original. Verify that this rollup has one bucket that encompasses every possible value the base variable may have. You can use one of the following two methods for making one bucket cover all values:

If the base measure is likely to return only positive numbers, use >= 0 (greater than or equal to zero). If you prefer, you might replace the zero with a negative number, for example, -99.
The other method is to choose an unlikely value for the measure and use the <> (not equal to) operator. For example, Account Balance returns a value with dollars and cents. Thus, -0.001 is an unlikely value because of the number of digits after the decimal point. By setting the bucket to <> -0.001, the bucket should catch all records.

Bookshelf Home | Contents | Index | Search | PDF