Oracle^® Business Intelligence Presentation Services Administration Guide > Administering Oracle BI Answers >

Configuring Answers Pivot Table Settings

You can change certain pivot table settings from their internal defaults by adding entries to the <PivotView> element in the Oracle BI Presentation Services configuration file (instanceconfig.xml):

• Specifying the Maximum Number of Records to Process in an Oracle Business Intelligence Pivot Table
• Specifying the Maximum Number of Populated Cells in an Oracle Business Intelligence Pivot Table
• Specifying the Maximum Number of Sections in an Oracle Business Intelligence Pivot Table

For information about working in the Oracle BI Presentation Services configuration file (instanceconfig.xml), read Making Oracle BI Presentation Services Configuration Changes.

Specifying the Maximum Number of Records to Process in an Oracle Business Intelligence Pivot Table

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

The following entry is an example:

<CubeMaxRecords>30000</CubeMaxRecords>

Specifying the Maximum Number of Populated Cells in an Oracle Business Intelligence Pivot Table

You can override the maximum number of populated cells that Oracle BI Presentation Services has 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.

The following entry is an example:

<CubeMaxPopulatedCells>160000</CubeMaxPopulatedCells>

Specifying the Maximum Number of Sections in an Oracle Business Intelligence Pivot Table

You can override the maximum number of sections that Oracle BI Presentation Services displays in a pivot table. The internal default is 1000.

The following entry is an example:

<MaxVisibleSections>500</MaxVisibleSections>