Siebel Analytics Performance Tuning Guide > Siebel Analytics > Add Aggregate Tables >

Aggregates Shipped with Siebel Analytics

Siebel ships many aggregate tables with Siebel Analytics which are used to improve query performance.

For example, the aggregate table W_PLREVN_OP_A summarizes revenue measures across Product Lines. In many cases, this aggregate table can greatly compress the rows stored in the W_REVN_F base fact table, a fact table that stores revenue measures at the product level.

For a list of aggregate tables shipped with Siebel Analytics, see the Siebel eBusiness Data Warehouse Data Model Reference guide.


 Siebel Analytics Performance Tuning Guide 
 Published: 18 April 2003