Skip to Main Content

Analytics Software

How to reduce Essbase currency conversion process time

Kiran.C.TJan 17 2020 — edited Jan 17 2020

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'].

Comments
Post Details
Added on Jan 17 2020
1 comment
60 views