EAL Performance Issue When Using Cross Dimension Variance by Year or Using the @PRIOR function (Doc ID 1504507.1)

Last updated on AUGUST 08, 2016

Applies to:

Oracle Essbase Analytics Link for Hyperion Financial Management - Version 11.1.1.4.000 and later
Information in this document applies to any platform.

Symptoms

ISSUE
When a dynamic Essbase Variance is created e.g. "Actual" - "Budget" EAL performs the calculation efficiently. When a cross dimension Variance by Year is used e.g. "Actual" - "Budget"->"2011" or even using the @PRIOR function, the query is not performed efficiently.

The prior year query generates significantly more individual queries. No more than one dimension member is submitted concurrently meaning performance is impacted significantly

This problem is not in EAL, the problem is in Essbase. Performance is impacted when using dynamic formulas where two and more dimensions are involved.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms