OBIEE 11g: Exceeded configured maximum number of allowed input records

Oracle have limited various numbers of outputs for rows, columns, prompts, cells and pivots to default values. These values are ususally set high enough to never become an issue, but for really large reports you will bump up against an error message saying you have exceeded some maximum.

So what do you do?

Step 1

Edit the instanceconfig.xml file. Typically, this file is located in the following directory: <OBIEE11g_install>\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1
If you are running a load balanced environment please make sure all environments have the same settings (or share the same settings) or you'll be forever chasing down 'weird' customer experiences.

Step 2

There are parts of the instanceconfig.xml you cannot edit directly and those sections will be marked as only being updateable via Oracle Enterprise Manager. The parts we can edit I have marked in bold.

<Views>
<Pivot>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<DisableAutoPreview>false</DisableAutoPreview>
<MaxCells>10000000</MaxCells>
<MaxVisibleColumns>1000</MaxVisibleColumns>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>10000</MaxVisibleRows>
<MaxVisibleSections>25000</MaxVisibleSections>
<DefaultRowsDisplayed>128000</DefaultRowsDisplayed>
</Pivot>
<Table>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>10000</MaxVisibleRows>
<MaxVisibleSections>2000</MaxVisibleSections>
<DefaultRowsDisplayed>64000</DefaultRowsDisplayed>
<MaxCells>10000000</MaxCells>
</Table>
</Views>

Note that the value you choose for <MaxCells> should never be more than <MaxVisibleColumns> * <MaxVisibleRows>.

In the case above <MaxVisibleColumns>1000</MaxVisibleColumns> * <MaxVisibleRows>10000</MaxVisibleRows> = <MaxCells>10000000</MaxCells>

Please restart all presentation services to pick up the new settings.

OBIEE - Javascript and CSS locations

In OBIEE 11g, the path for Javascript and Custom Style Sheet is located at-

OBIEE\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\

And for using them-
<script type="text/javascript" src="res/test.js"></script>
<link href="res/test.css" type="text/css" rel="stylesheet">

Refererence- https://forums.oracle.com/forums/thread.jspa?threadID=2453825&tstart=0

OBIEE Maintenance Mode

Setting the maintenance on makes the system readonly. This feature is of particular importance to us when you want to do maintenance activities but still allow the users to access the application. Users will not be able to save any reports and thus maintain the consistancy of the webcatalog.

You need to be able to access the Administration page from your answers login.

The maintenance mode can be toggled ON/OFF on the main OBIEE page when you login to analytics with the link http://servername:port/analytics. At the top right corner of the page click administration link, on the resulting page under Maintenance and Troubleshooting section, you will notice the link toggle Maintenance Mode. Click the link to turn ON/OFF. In a clustered environment the mode can be toggled on each node separatley.

When set ON, users will recieve a message saying the "System is in Maintenance Mode. Please Try again later". whenever any user tries to save a report.

This means that you as administrator can lock down changes to the dashboard and catalog while a release is underway, a backup is taking place, .... Usually some activity where it is ideal that no changes are being made until the operation completes.

Changing The Range in Charts

You can override the default settings for charts. You usually want to do this because the size of chart, range, or layout doesn't match with what you had in mind for the design of your report

You want to stretch out your report, or if your graph never goes below a certain value change the axis default limits.

Easy enough, go to the Results Tab, Click on the little pencil to edit your graph and then in the layout and design panel click on the xyz image (along the top of the panel). When you hover your mouse over the image you get the tooltip "Edit graph properties".

A modal properties box appears, that allows you to edit the graph settings and parameters. The scale tab, shown above, is where you can override the defaults used for axis limits and scales.