Know How

OBIEE 12c: “There was too much data to process your visualization” Error when Create/Edit Data Set Filter in


“There was too much data to process your visualization. Please further filter your data Exceeded configured maximum number of allowed input records. ResultRowLimit(table) Or CubMaxRecords(Pivot/Chart) needs to reset in the config file. Please check with your administrator” Error Message


Step 1: Edit the instanceconfig.xml file in the following directory:


Step 2: <Views> tag even if Cube Tag does not exist you can add it

<CubeMaxRecords> 150000 </CubeMaxRecords>

CubeMaxRecords should match the ODBC rows limit that they currently have set to:


Step 3: Restart the Services.

Let's make something intelligent together