To use Fusion Middleware Control to set configuration options for views:
Go to the Business Intelligence Overview page, as described in Section 2.2.3, "Using Fusion Middleware Control to Manage Oracle Business Intelligence System Components."
Display the Performance tab of the Capacity Management page.
Click Lock and Edit Configuration to enable changes to be made.
Complete the elements using the descriptions in the help topic for the page. Click the Help button on the page to access the page-level help for the following options:
Maximum Number of Rows to Download option
Maximum Number of Rows Per Page to Include option
Click Apply, then click Activate Changes.
Return to the Business Intelligence Overview page and click Restart.
Method 2:
To manually edit the settings that change the display of data in views:
Open the instanceconfig.xml file for editing, as described in Section 3.6, "Where Are Configuration Files Located?"
Locate the Table, Pivot, Trellis, Charts, Narrative, Ticker, and Treemap parent sections, in which you must add the elements that are described in Table 19-2.
Include the elements and their ancestor elements as appropriate, as shown in the following example:
<ServerInstance>
<Views>
<Table>
<MaxCells>10000</MaxCells>
<MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>500</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<DefaultRowsDisplayed>30</DefaultRowsDisplayed>
<DefaultRowsDisplayedInDelivery>250</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>65000</DefaultRowsDisplayedInDownload>
<DefaultRowsDisplayedInDownloadCSV>65000</DefaultRowsDisplayedInDownloadCSV>
</Table>
<Pivot>
<MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>
<MaxVisibleColumns>300</MaxVisibleColumns>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>500</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<DefaultRowsDisplayed>30</DefaultRowsDisplayed>
<DefaultRowsDisplayedInDelivery>250</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>65000</DefaultRowsDisplayedInDownload>
<DefaultRowsDisplayedInDownloadCSV>65000</DefaultRowsDisplayedInDownloadCSV>
</Pivot>
<Trellis>
<Simple>
<MaxCells>1000</MaxCells>
<MaxVisibleSections>10</MaxVisibleSections>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>100</MaxVisibleRows>
<MaxVisibleColumns>75</MaxVisibleColumns>
<MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>
<DefaultRowsDisplayed>10</DefaultRowsDisplayed>
<DefaultRowsDisplayedInDelivery>100</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>6500</DefaultRowsDisplayedInDownload>
</Simple>
<Advanced>
<MaxCells>5000</MaxCells>
<MaxVisibleSections>50</MaxVisibleSections>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>250</MaxVisibleRows>
<MaxVisibleColumns>150</MaxVisibleColumns>
<MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>
<DefaultRowsDisplayed>25</DefaultRowsDisplayed>
<DefaultRowsDisplayedInDelivery>250</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>10000</DefaultRowsDisplayedInDownload>
</Advanced>
</Trellis>
<Charts>
<MaxVisibleColumns>2000</MaxVisibleColumns>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>2000</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<JavaHostReadLimitInKB>4096</JavaHostReadLimitInKB>
</Charts>
<Narrative>
<MaxRecords>40000</MaxRecords>
<DefaultRowsDisplayed>30</DefaultRowsDisplayed>
</Narrative>
<Ticker>
<MaxRecords>40000</MaxRecords>
</Ticker>
<Treemap>
<MaxCells>5000</MaxCells>
<MaxVisiblePages>10000</MaxVisiblePages>
<MaxVisibleRows>10000</MaxVisibleRows>
<MaxVisibleSections>50</MaxVisibleSections>
</Treemap>
</Views>
</ServerInstance>
Note that this example does not include elements that might exist in the file, but that are centrally managed by Fusion Middleware Control and cannot be changed manually.
Save your changes and close the file.
Restart Oracle Business Intelligence.
