Siebel Analytics Server Administration Guide > Setting Up Aggregate Navigation >

About Aggregate Navigation


Aggregate tables store precomputed results, which are measures that have been aggregated (typically summed) over a set of dimensional attributes. Using aggregate tables is a very popular technique for speeding up query response times in decision support systems.

If you are writing SQL queries or using a tool that only understands what physical tables exist (and not their meaning), taking advantage of aggregate tables and putting them to good use becomes more difficult as the number of aggregate tables increases. The aggregate navigation capability of the Siebel Analytics Server, however, allows queries to use the information stored in aggregate tables automatically, without query authors or query tools having to specify aggregate tables in their queries. The Siebel Analytics Server allows you to concentrate on asking the right business question; the server decides which tables provides the answers the fastest.

For the Siebel Analytics Server to have enough information to navigate to aggregate tables, you need to configure certain metadata in the repository. This section provides details about and examples of how to set up the necessary metadata, and is divided into the following subsections.


 Siebel Analytics Server Administration Guide 
 Published: 23 June 2003