Siebel Analytics Web Administration Guide > Administering Siebel Answers >

Configuring Siebel Answers Pivot Table Settings

You can change certain pivot table settings from their internal defaults by adding entries to the Windows registry or the Siebel Analytics Web configuration file instanceconfig.xml:

• Specifying the Maximum Number of Records To Process in a Siebel Analytics Pivot Table
• Specifying the Maximum Number of Populated Cells in a Siebel Analytics Pivot Table

For information about working in the Windows registry or the configuration file instanceconfig.xml, see Making Siebel Analytics Web Configuration Changes.

Specifying the Maximum Number of Records To Process in a Siebel Analytics Pivot Table

You can override the maximum number of records that can be processed by a pivot table. The internal default is 20000.

• Windows registry example:

  HKEY_LOCAL_MACHINE\SOFTWARE\Siebel Systems, Inc.\Siebel Analytics\Web\7.7

  CubeMaxRecords     30000

• instanceconfig.xml example:

  <CubeMaxRecords>30000</CubeMaxRecords>

Specifying the Maximum Number of Populated Cells in a Siebel Analytics Pivot Table

You can override the maximum number of populated cells that Siebel Analytics Web allows in a pivot table. The internal default is 150000. If the user exceeds this value, the server returns an error message when the pivot table is rendered.

• Windows registry example:

  HKEY_LOCAL_MACHINE\SOFTWARE\Siebel Systems, Inc.\Siebel Analytics\Web\7.7

  CubeMaxPopulatedCells     160000

• instanceconfig.xml example:

  <CubeMaxPopulatedCells>160000</CubeMaxPopulatedCells>