How to Fix Error Exceeded Configured Maximum number of allowed Input Records

Solution :
OBIEE documentation tells us that in case of such issues, we should manually make changes to the pre configuration settings for pivot and chart views.

1.) Go to the Instance Config file and take a backup copy of it .
2.) Locate the cube section in the file, if it doesn't exist you might need to create one.
3.) Include the following set of code between the server instance tags.

<ServerInstance>
  <Views>
    <Cube>
      <CubeMaxRecords>9999999</CubeMaxRecords>
      <CubeMaxPopulatedCells>999999999</CubeMaxPopulatedCells>
    </Cube>
  </Views>
</ServerInstance>

where Cube Max Records refers to the maximum number of records returned by an analysis for the view to process.
and Cube Max Populated Cells refers to the cells in the view that can be populated with data from BI server.
4.) Save the changes and restart the services.

Also the table and Pivot settings can be updated as below

<Pivot>
<MaxCells>1920000</MaxCells>
<MaxVisibleColumns>30</MaxVisibleColumns>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>64000</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<DefaultRowsDisplayed>64000</DefaultRowsDisplayed>
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>64000</DefaultRowsDisplayedInDownload>
<DisableAutoPreview>false</DisableAutoPreview>
</Pivot>

<Table>
<MaxCells>1920000</MaxCells>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>64000</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<DefaultRowsDisplayed>64000</DefaultRowsDisplayed>
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>64000</DefaultRowsDisplayedInDownload>
</Table>

SHARE SHARE SHARE

About test