When retrieving data from an ASO application, the application may crash on certain retrievals.
This is due to Internal optimization being executed on MDX formulas.
If users are experiencing intermittent crashes while retrieving on an ASO application, set the following parameter in the essbase.cfg file:
FORMULAOPTLEVEL is an undocumented Essbase configuration setting that controls how MDX formulas are executed in Essbase. Essbase optimizes execution of MDX formulas by analyzing various MDX expression patterns used in a formula. The FORMULAOPTLEVEL configuration setting selectively turns off some of these optimizations. Turning off some of the optimizations may help in resolving the application crashes.