Pre-Tuning And Sizing Your Hyperion Planning And Essbase Applications Before Building Anything Agenda • Introductions • Who is this guy and what is ClearLine? • Major Areas to be covered • Pre-Tuning • Outline Design • Database Settings & Caches • Data Load Tuning • Calculation Optimization • Compression • Application Sizing • Cube Size • Calculation Cache Size • Sizing Spreadsheet • Q & A © 2011 – ClearLine Group, L.L.C. 2 INTRODUCTIONS © 2011 – ClearLine Group, L.L.C. 3 Steve Light • Director in ClearLine’s Hyperion Practice • 17 years experience with Hyperion Products • Started on Essbase 3 and certified on 4, 5, 6, 7, 9.0, 9.3, & 11 • Beta tester for ASO on 7.1 and worked with 7x & 9x • Hyperion Planning 2, 4, 9.3, and 11 (Classic & EPMA) • Analyzer / Web Analysis, Financial Reports • Worked on 58 different projects at 42 companies • Industries • Aviation, Banking, Consumer Products, Financial, Health Care, Insurance, Manufacturing, Retail, Pharmaceutics, Publishing, Telecom, and Transportation © 2011 – ClearLine Group, L.L.C. 4 Overview of ClearLine Group Boutique consulting firm of highly experienced Hyperion EPM experts • Core team has a deep history of success working together for over 12 years. ‘Pioneers’ consulting in the Hyperion technologies • Backgrounds blend industry and consulting experience • Breadth of skills from expert level advisory, executive visioning and project management to hands-on architecture and implementation • All full-time employees, focused on the long-term success of the firm • ClearLine provides a consistent source of high caliber experts who leverage the collective experience of our group to deliver superior results © 2011 – ClearLine Group, L.L.C. 5 Provide customers with ‘end-to-end ‘ services Services range from initial visioning / roadmap process to project oversight and advisory to full implementation and production support services. © 2011 – ClearLine Group, L.L.C. 6 Introduction To PRE-TUNING & SIZING DURING REQUIREMENTS & DESIGN © 2011 – ClearLine Group, L.L.C. 7 Why pre-tune & size during requirements & design? • Allows for better up front “go / no go” decisions on the project • Sets the correct expectations with the end users and project sponsors • Will aid in project management and CoE standards • Saves time across the entire project • Better defines “wants” verse “needs” during requirements by allowing more accurate cost benefit analysis • Avoids “trial and error” prototyping to see what is possible verses practical • Helps to stop the development team from painting themselves into a corner during the build • It is usually more difficult to reduce scope in later phases of a project • Stops the common mistakes like: • Let’s put it all in and take out what doesn’t work later • We’ll worry about tuning after we get the numbers right © 2011 – ClearLine Group, L.L.C. 8 What is the bottom line for Planning & Essbase tuning? • Simplify it where possible • Reduce the size of the database • Avoid reserving space • Avoid inter-dimensional irrelevance • Improve the use of memory • Set the appropriate caches • Improve the Hardware • Memory / Processors • 64-bit • Reduce the amount of I/O • Reduce passes through the database • Restrict the number of data blocks • Streamline processes • Remember that there may be other applications on the server © 2011 – ClearLine Group, L.L.C. 9 Introduction To PRE-TUNING OUTLINES © 2011 – ClearLine Group, L.L.C. 10