Performance tuning hfm in the field
1 / 34

Performance Tuning HFM in the Field - PowerPoint PPT Presentation

  • Uploaded on

Performance Tuning HFM in the Field. HUGmn 2010 Jim Heflin Chris Barbieri. Application Design: the Foundation of Performance. Hyperion Financial Management Metadata design as it impacts performance Data volume and content measurement Rules performance measurement Reading the HFM logs.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Performance Tuning HFM in the Field' - edythe

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Performance tuning hfm in the field

Performance Tuning HFM in the Field

HUGmn 2010

Jim Heflin

Chris Barbieri

Application design the foundation of performance
Application Design: the Foundation of Performance

Hyperion Financial Management

Metadata design as it impacts performance

Data volume and content measurement

Rules performance measurement

Reading the HFM logs

Designing hfm s 12 dimensions
Designing HFM’s 12 Dimensions

  • User controlled

    • Entity

    • Account

    • ICP

    • Scenario

  • User defined

    • Custom 1

    • Custom 2

    • Custom 3

    • Custom 4

  • Application Profile

    • Year

    • Period

    • View

  • System

    • Value dimension, includes currencies

Application profile
Application Profile

  • Year

    • No inherent impact on performance

    • Cannot be changed after the application is built

    • Impacts the number of tables that can be created in the database

  • Period

    • The base periods comprise the column structure of every table, whether you use them or not.

    • For this reason, avoid weekly or yearly profiles unless it is key to your entire application’s design

  • View

    • No impact, but only YTD is stored and Periodic, QTD are on-the-fly derivations

What s a subcube

Parent subcube, stored in DCN tables

Currency subcubes, stored in DCE tables

What’s a Subcube?

  • HFM data structure – Year, Scenario, Value, Entity

  • Database tables stored by year_scenario

    • Each record contains all periods for the [Year]

    • All records for a subcube are loaded into memory together

Data design
Data Design

“Metadata volume is interesting, but it’s how you populate it that matters most”

  • Density

  • Content

    • Specifically: zeros

    • Tiny numbers

    • Invalid Records

Loaded data
Loaded Data

  • What percent of the loaded data is a zero value?

    • No hard rule, but <5% may be reasonable

    • No zeros are best, watch ZeroView settings on the scenarios

  • Watch out for tiny values, resulting from allocations

  • How much does the data expand from Sub Calculate?

    • Am I generating zeros, or tiny numbers?

Data density using freelru
Data Density Using FreeLRU

Survey of data density using FreeLRU method

Hfm 11 1 1 the magic of 64 bit
HFM 11.1.1: the magic of 64 bit!

  • 32 bit provides 2 GB of RAM for HFM

    • Possibility of using 3 GB switch

    • All versions, including 11.1.1 32 bit edition

    • Can manage about 1-3 million records in RAM

  • 64 bit provides 128 GB RAM for HFM

    • Starting with release 11.1.1

    • Out of the box support for 12 million records in RAM

    • Ranzal lab and field testing shows 30-50% faster than 32 bit!

    • HFM 64 bit white paper available from Chris Barbieri

Measure and analyze rules
Measure and Analyze Rules

How much time do I spend in each rule?

Do some months take longer than others?

Rewrite the rule for optimal performance

Is it because they have more data?

Let’s focus on the “top 10”

Establish a baseline
Establish a Baseline

“Performance begins with perception. Establish this and a baseline before applying science.”

Chris Barbieri

Sr. Product Issues Manager

Hyperion Solutions

March 5, 2006

  • Effect of caching

    • Data cache on database server AND on HFM application server

    • Caches may be empty during first run

    • Performance is significantly better when data reads comes from memory cache rather than disk

      • This is why cache management is so important

    • Run the same process 3 times in a row and use the average

Rules of thumb
“Rules” of Thumb

  • Most application between 0.25 and 2.0 seconds per entity, per period

    • Consolidate all with data for entire hierarchy, full year

    • Divide by total number of entities (descendents of selected parent), divided by 12 periods

    • Most applications are closer to 0.25 seconds

  • Rules Impact Ratio

    • Blank rules file, Consolidation Rules = N for baseline

    • Divide consolidation time with rules by time without

    • Usually 2-5 times

Data density calc time
Data Density <> Calc Time

Loose correlation between density and calc times

Most applications are rules bound

When HFM app server CPU is < 20%, it is communicating with the database server

The black art of reading hfm event logs
The Black Art of Reading HFM Event Logs

  • Where does HFM store its event information?

  • Maintaining the logs

  • How can I view this?

  • OK, what does it actually tell me?

Understanding hfm logs
Understanding HFM Logs


  • Messages are informational –start/stop consol, log in, log out etc.

  • Some messages are purposely out of time order (consol starts get printed at completion of consol


  • Often due to subcube size issues

  • HFM Subcube Troubleshooting Guide / Memory Management in HFM documents


  • Access rights

  • Syntax Issues

Where are the hfm events stored
Where are the HFM events stored?

  • Text file containing XML, named HsvEventLog.log

  • Pre-HFM or 9.3.0

    • ..\Hyperion Solutions\Hyperion Financial Management\Server Working Folder\

  • Starting with 9.3.1 Oracle moved all product logs to a common parent folder

    • HYPERION_HOME\Logs\FinancialManagement

    • or


How can i view this
How can I view this?

  • Administration Module

    • Web: Administrators only

  • HFM Error Log Viewer utility

    • Free standing executable

    • Bundled with HFM under \Consultant Utilities

Web system messages
Web System Messages

  • Available to administrators

Launch the utility
Launch the Utility

Launch HFMErrorLogViewer.exe

System Message panel

Details panel


Web suppresses richer details shown in utility

Find registry
Find “Registry”

Each server’s registry settings are written during an application start-up.

Most but not all registry entries are written

We’ll cover the actual entries in another presentation

Page file size
Page File Size

Increased in, 9.3.1 to 130 and 260 MB

Still exists in 64 bit HFM 11.1.1, but likely unused


Watch “PageOutOps > 0” indicating page file usage

Consolidation start and finish
Consolidation start and finish

Summary indicates start time

Details have finish time

Is written when it completes

Extracting log entries
Extracting Log Entries

HFM writes to both the event log and the database

You can extract the database entries to a text file, which is preferable to the event logs

Can also truncate the entries using this utility

And split large files (anything > 30 MB is too large)

Ranzal performance lab team
Ranzal Performance Lab Team

Co-founded in 2007

Kurt Schletter

  • Over 20 years in IT

  • Hyperion Support Manager at United Technologies, serving 3,600+ HFM users

  • 5+ years Hyperion product infrastructure services

  • MBA, Rensselaer Polytechnic Institute

  • B.S. Management with Computer Applications, Worcester Polytechnic Institute

Chris Barbieri

Established HFM performance tuning techniques and statistics widely used today

4+ years as Sr. Product Issues Manager at Hyperion

Member of HFM launch team in 2001, certified in HFM and Enterprise

MBA, Babson College

B.S. Finance & Accounting, Boston College

Performance tuning hfm in the field


  • Visit for a listing of complete webinars

Performance tuning hfm in the field

Chris Barbieri

Needham, MA