Optimize

Identify Bottlenecks Robbing HFM of Consolidation Performance

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.

Ascension Suite was built by 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.

Benefits

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

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

Subcube Analyzer

  • Quickly find overly dense subcubes in HFM applications
  • View subcube population changes over time
  • Detect database zeros

Features

  • 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

Screenshots

HFM Rules Profiler Function Analysis


HFM Rules Profiler Timing Block Analysis


HFM Subcube Analyzer

Successes

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 Accelatis 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.