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.
Hyperion Financial Management
Metadata design as it impacts performance
Data volume and content measurement
Rules performance measurement
Reading the HFM logs
Currency subcubes, stored in DCE tablesWhat’s a Subcube?
“Metadata volume is interesting, but it’s how you populate it that matters most”
Survey of data density using FreeLRU method
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”
“Performance begins with perception. Establish this and a baseline before applying science.”
Sr. Product Issues Manager
March 5, 2006
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
System Message panel
Web suppresses richer details shown in utility
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
Increased in 22.214.171.124, 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
Summary indicates start time
Details have finish time
Is written when it completes
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)
Co-founded in 2007
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