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.
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.
Performance Tuning HFM in the Field
Hyperion Financial Management
Metadata design as it impacts performance
Data volume and content measurement
Rules performance measurement
Reading the HFM logs
Parent subcube, stored in DCN tables
Currency subcubes, stored in DCE tables
“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 18.104.22.168, 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