1 / 34

Performance Tuning HFM in the Field

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.

gili
Download Presentation

Performance Tuning HFM in the Field

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Performance Tuning HFM in the Field HUGmn 2010 Jim Heflin Chris Barbieri

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

  3. Metadata

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

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

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

  7. Metadata Volumes (Americas)

  8. Data

  9. Data Design “Metadata volume is interesting, but it’s how you populate it that matters most” • Density • Content • Specifically: zeros • Tiny numbers • Invalid Records

  10. 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?

  11. Data Density Using FreeLRU Survey of data density using FreeLRU method

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

  13. Rules

  14. 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”

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

  16. “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

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

  18. The Black Art of Reading HFM Logs

  19. 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?

  20. Understanding HFM Logs Messages • 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 Warnings • Often due to subcube size issues • HFM Subcube Troubleshooting Guide / Memory Management in HFM documents Errors • Access rights • Syntax Issues

  21. Where are the HFM events stored? • Text file containing XML, named HsvEventLog.log • Pre-HFM 9.2.0.2 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 • HYPERION_HOME\Logs\HFM

  22. How can I view this? • Administration Module • Web: Administrators only • HFM Error Log Viewer utility • Free standing executable • Bundled with HFM under \Consultant Utilities

  23. Web System Messages • Available to administrators

  24. Launch the Utility Launch HFMErrorLogViewer.exe System Message panel Details panel

  25. Details Web suppresses richer details shown in utility

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

  27. System Memory at Inception

  28. Page File Size Increased in 9.2.0.3, 9.3.1 to 130 and 260 MB Still exists in 64 bit HFM 11.1.1, but likely unused

  29. Paging Watch “PageOutOps > 0” indicating page file usage

  30. Consolidation start and finish Summary indicates start time Details have finish time Is written when it completes

  31. 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)

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

  33. Questions? • Visit www.Ranzal.com/News.htm for a listing of complete webinars

  34. Chris Barbieri cbarbieri@ranzal.com Needham, MA USA +1.617.480.6173 www.ranzal.com

More Related