Essbase ASO Application Crashing When Retrieving Data


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 2

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.

Thanks,
~KKT~

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s