At the time of building a Cube through Data Advisor, getting error "The number of fact rows '57127398' exceeds the maximum number of rows set for the IBM Cognos Express server. Please contact your System Administrator". We have set the following limit in dataadvisorservice.xml file "<MaxFactRowsPerCubeError>200000</MaxFactRowsPerCubeError>
Only one particular cube is throwing this error, able to build other cube with 8 crore data.
Can anyone help to resolve this issue.