OBIEE 12c: “There was too much data to process your visualization” Error when Create/Edit Data Set Filter in 126.96.36.199
“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.