Siebel Analytics Server Administration Guide > Setting Up Aggregate Navigation > About Aggregate Navigation >

Specify the Aggregate Levels for Each Source

Each aggregate table column contains data at a given set of levels. For example, a monthly sales table might contain a precomputed sum of the revenue for each product in each store during each month. If the granularity of the data is at the sales transaction level, then this aggregate table contains highly summarized data.

Such an aggregate table could be used to answer the following logical SQL request:

select product_name, store_name, month, sum(revenue)
from product, store, time, facts

For the Siebel Analytics Server to be able to use the aggregate table to answer this query, it needs to know that the data in the aggregate table is stored at the product, store, and month levels. You configure this metadata in the Logical Table Source window.

Specify Content of Source

To use a source correctly, the Siebel Analytics Server needs to know what each source contains. You can specify the content of a source in the Content tab of the Logical Table Source dialog box. For more information see, Defining Content of Sources.

WHERE Clause Filter

The WHERE clause filter is used to constrain the physical tables referenced in the logical table source. If there are no constraints on the aggregate source, leave the WHERE clause filter blank.

For example, if you have an aggregate source that includes all soda brands, but you are only interested in the data from Fizzy Brands, the following is a valid WHERE clause filter, where Brand is a column of the physical table Product:

Product.Brand = 'Fizzy Brands'

Each logical table source should contain data at a single intersection of aggregation levels. You would not want to create a source, for example, that had sales data at both the Brand and Manufacturer levels. If the physical tables include data at more than one level, add an appropriate WHERE clause constraint to filter values to a single level.

Any constraints in the WHERE clause filter are made on the physical tables in the source.


 Siebel Analytics Server Administration Guide 
 Published: 23 June 2003