Intermittent error encountered when executing a cross tab report.
Error Message:
QE-DEF-0425 Exception was encountered while building the cube
RSV-SRV-0025 Unable to execute this request
The maximum size for a measure in a crosstab and chart is 19 digits. You can use the maximum of 19 integer with 0 decimal precision. The default decimal precision is 7, so 100000000000 works but 1000000000000 would generate the error. If default precision is already been set properly, increase the cgi script timeouts on the web server.
Steps:
1. Open CQEConfig.xml file from <crn install>\configuration in a text editor. If the has an extension .sample, please rename it to CQEConfig.xml.
2. Change the following line:
<entry name="crosstabDecimalPrecision" value="7"/>
to
<entry name="crosstabDecimalPrecision" value="4"/>
Note: The value="4" may be set lower if needed.
