SYMPTOM:
When attempting to Edit a cube created using Data Import from Database or FFSQL, in Strategy Web 9.4.1, users experience a long processing time or a generic request timeout error.
CAUSE:
This is working as designed in Strategy Web 9.4.1. When editing this type of cube, Strategy Web executes the full SQL of that cube before displaying the returned data to show the first rows of the cube in the Editing page. At the time of the editing, the execution of that SQL may be too slow due to performance problems or because it retrieves too much data, or may actually time out because the server never receives a response from the DB.
To confirm if this is the problem, execute the full SQL of the cube through the Strategy DB Query tool and compare the execution times. A request has been logged to prevent the full execution of the query when editing.
ACTION:
This issue has been addressed in Strategy Web 10. Upgrade to this verison to take advantage of this fix.
The Strategy Internal Reference Number for the issue discussed in this technical note is 819654.
