You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Severe ASO Performance Degradation After Essbase was Upgraded to 21.7.4

We are experiencing a severe performance degradation in ASO after our Development environment was upgraded to Essbase version 21.7.4.0.0.004.
The exact same cube runs fast in Production (11.1.2.4), but in Development the performance became extremely slow only after the update.

Issue Summary

  • Some level-0 members have formulas.
  • In the previous version, formulas performed normally.
  • After the upgrade to 21.7.4, any ad hoc query that includes these formula members becomes extremely slow.
  • The query becomes fast only if we remove the formula entirely.
  • Nothing was changed in the application. Only Essbase was updated.

The same formulas run fast in Production (11.1.2.4) and used to run fast in Development before the update.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!