Optimization

Identify Bottlenecks in Essbase Calcs and HFM Business Rules

  • Own the maintenance and optimization of your Essbase Calcs and HFM rules.
  • Remedy negative calculation impact quickly.
  • Pinpoint the exact cause of HFM Rules challenges
  • Understand when Subcube densities could start causing performance issues

Essbase Calc Profiler

  • Measure time spent in each FIX
  • Custom timings on calc script lines and line counts available with the click of a button

HFM Rules Profiler

  • Measure time spent by Function and Entity
  • Capture data changes caused by Rules
  • Custom timings and line counts available with the click of a button

HFM Subcube Analyzer

  • Quickly find overly dense subcubes in HFM applications
  • View subcube population changes over time
  • Detect database zeros
  • Measure time spent by Function and Entity
  • Capture data changes caused by Rules
  • Custom timings for suspect blocks of code
  • Custom counters for how many times a line of code is executed
  • Quickly find overly dense subcubes in HFM applications
  • View subcube population changes over time
  • Detect database zeros

Success Summary – Major Account Structure Growth

An EPM client was about to acquire a new division and grow their account structure by 40%. They had concerns about data volume in HFM and whether the increased accounts would cause performance issues. The Datavail HFM Subcube analyzer was able to detail the current data populations and provide the client confidence that the acquisition would not cause performance issues due to data explosion.

Success Summary – Reduced Financial Close Time by ½ Day

How much is ½ day worth on your financial close?

Optimization


Two common causes of HFM performance issues are HFM Rules issues, and Subcube density issues. Both of these issues require an in-depth knowledge of the causes and remedies that most clients must reach externally to resolve.

One of the most elusive elements of HFM that can bring performance to its knees is HFM Rules. Leveraging VB Script, it’s a powerful way to get HFM to meet your exact needs, but in the process of customization it’s possible to create unanticipated performance issues. The elusive part comes from the level of expertise it takes to analyze these rules to determine the causes and potential remedies. There are several very competent consultants in the industry who are capable of doing this analysis and solving these problems.

Datavail’s Application Performance Management platform was built by Accelatis – a company acquired by Datavail in 2017 – one of the premier HFM experts in the industry. It empowers you to analyze and remedy your HFM rules challenges and enjoy consistently high performance without the time and expense associated with depending on external resources to address this issue for you each time you are impacted.