Kscope19 Logo-No Location.png

View Printable Version

Best Practices and Performance Tuning for Using Hybrid BSO in EPBCS

Session Number: 8911
Track: Planning
Sub-Categorization: Design
Session Type: Tips, Techniques and Tuning
Primary Presenter: Amit Sahasrabudhe [Manager, Planning and Analytics - Huron Consulting]
Co-Presenter: David DeLozier [Manager, Enterprise Solutions & Analytics - Huron Consulting Group]
Time: Jun 25, 2019 (03:45 PM - 04:45 PM)
Room: 602/603, Level 6

Speaker Bio: Amit is a BI/EPM professional with extensive experience in implementing enterprise performance management solutions primarily based on Hyperion Planning and Essbase. He has been involved in numerous EPM projects in the US, the UK, and India. Prior to entering the exciting enterprise performance management field, Amit worked on data warehousing projects, where he obtained a solid experience in RDBMS and ETL systems. More recently, Amit has successfully implemented Oracle Planning and Budgeting Cloud solutions.

Amit currently works as a manager in Huron Consulting Group's EPM practice, where he is involved in managing projects and architecting EPM solutions. Amit brings to the table a unique blend of project management plus system design & development experience. He has been involved in projects with a pure onshore as well as onshore-offshore models. Amit has also been instrumental in setting up a managed services framework for a number of his customers thus ensuring that the customer's EPM solution is maintained, helping the customer realize its full potential

Amit is an Oracle certified Planning consultant and regularly contributes to his personal blog (epminsight.com). He also works as a volunteer at a foreign language school run by a non-profit organization and takes up numerous roles like teaching, managing a small library, and other administrative tasks at the school.

Technologies or Products Used: EPBCS

Session Summary for Attendees:  This session aims to impart upon the audience knowledge about technical details, best practices, and tips for optimally using Hybrid BSO in EPBCS. The session will begin with a brief overview of the new Hybrid BSO functionality, covering steps to enable Hybrid BSO, including the validation process that is performed before Hybrid mode is enabled. Next, we will discuss specific thresholds enforced by the frameworks which will help the audience determine if their application can be converted to Hybrid BSO. This session will draw comparisons between BSO, Hybrid BSO, and ASO, covering pros and cons of enabling the hybrid mode for EPBCS. Specific use cases will be discussed where hybrid BSO will yield significant benefits over standard BSO. The session will end with Hybrid BSO performance tuning tips regarding dense-sparse settings, storage, block sizes, and calculation behavior changes for specific functions.

Be sure to keep your user profile up to date! Click here to update now.