Siebel Analytics Performance Tuning Guide > Siebel Analytics >

Subset Large Physical Dimension Tables

Often, a family of queries references only a well-defined subset of a large physical dimension. Suppose a family of queries references only competitor accounts in a large Accounts dimension table. To improve the performance of these queries, create a CompetitorAccounts dimension table and direct this family of queries to this smaller min-dimension table rather than to the larger dimension table.

You can accomplish this readily by identifying the subsets, creating the table, and including the subsets in the Business Model.


 Siebel Analytics Performance Tuning Guide 
 Published: 18 April 2003