Forum Stats

  • 3,768,299 Users
  • 2,252,772 Discussions
  • 7,874,520 Comments

Discussions

How to reduce Essbase currency conversion process time

Kiran.C.T
Kiran.C.T Member Posts: 2 Blue Ribbon
edited Jan 17, 2020 10:27AM in Essbase On-Premise

Hi All,

We are using Hyperion Essbase 11.1.2.3.508 version. Earlier, our Essbase currency conversion process used to take 40min to complete but these days it is taking approx.12 hrs to complete. Can you please let us know is there any way to improve the process? Below are the log screenshots for your reference.

Now:

  20> },
  21> (Descendants ([Consolidation Group], [Consolidation Group].Levels (0))
  22> )))))))))))))))" 
  23>     Amount "([GBP_RPT])"
  24>     Amountcontext "( [Periodic])"
  25>     Target "([GBP_REP_Curr])"
  26>     Range "{( [Periodic])}"
  27> SPREAD;

OK/INFO - 1300006 - Essbase generated [83582] cells.
OK/INFO - 1013374 - The elapsed time of the allocation is [41327.2] seconds.
OK/INFO - 1241188 - ASO Allocation Completed on Database ['IFRS9REP'.'IFRS9REP'].

Earlier:

  20> },
  21> (Descendants ([Consolidation Group], [Consolidation Group].Levels (0))
  22> )))))))))))))))" 
  23>     Amount "([GBP_RPT])"
  24>     Amountcontext "( [Periodic])"
  25>     Target "([GBP_REP_Curr])"
  26>     Range "{( [Periodic])}"
  27> SPREAD;

OK/INFO - 1300006 - Essbase generated [62104] cells.
OK/INFO - 1013374 - The elapsed time of the allocation is [2827.03] seconds.
OK/INFO - 1241188 - ASO Allocation Completed on Database ['IFRS9REP'.'IFRS9REP'].

Tagged:

Answers

  • Tim_Faitsch
    Tim_Faitsch Member Posts: 198
    edited Jan 17, 2020 10:27AM

    The time it takes to process these calculations seems to increase exponentially when increasing the number of combinations in the POV. So I'm guessing that one or more of the member sets inside the POV has increased.

    The first thing I'd try is splitting the statement up along some logical lines. For example, if you have a dimension in the POV where there are two members, create two nearly identical statements that contain just one of the members each. See what the performance is for that. You might be best off separating them on month -- so you'd have 12 nearly identical statements.

    The good news is that Essbase 19c should be much faster for handling calculations like this.