380 likes | 1.56k Vues
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.
E N D
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
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 • 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
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 “Metadata volume is interesting, but it’s how you populate it that matters most” • Density • Content • Specifically: zeros • Tiny numbers • Invalid Records
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 Survey of data density using FreeLRU method
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 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 “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 • 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 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 • 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 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
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
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 • Available to administrators
Launch the Utility Launch HFMErrorLogViewer.exe System Message panel Details panel
Details Web suppresses richer details shown in utility
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 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
Paging Watch “PageOutOps > 0” indicating page file usage
Consolidation start and finish Summary indicates start time Details have finish time Is written when it completes
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 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
Questions? • Visit www.Ranzal.com/News.htm for a listing of complete webinars
Chris Barbieri cbarbieri@ranzal.com Needham, MA USA +1.617.480.6173 www.ranzal.com