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

Error:

“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

Solution:

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

[DOMAIN_HOME]\config\fmwconfig\biconfig\OBIPS/instanceconfig.xml

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

<Cube>
<CubeMaxRecords> 150000 </CubeMaxRecords>
</Cube>

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

<ODBC>
<ResultRowLimit>150000</ResultRowLimit>
</ODBC>

Step 3: Restart the Services.