Advanced Calculations for PBCS, Planning, and Essbase

Session Number: 8895
Track: Planning
Sub-Categorization: Other Planning
Session Type: Tips, Techniques and Tuning
Primary Presenter: Jake Turrell [Hyperion Solution Architect - Turrell Consulting]
Time: Jun 25, 2019 (08:50 AM - 09:50 AM)
Room: 604, Level 6

Speaker Bio: Jake Turrell is a Hyperion solution architect and Oracle ACE Alumni with over 24 years of experience implementing enterprise performance management solutions. Jake’s technology career began in the early 90s as a financial systems intern at Dell in Austin, Texas, administering IMRS Micro Control (the DOS-based predecessor to Hyperion Enterprise). After working at Dell, Jake joined Ernst & Young’s management consulting practice, where he worked with a variety of technologies. He later returned to the Hyperion world and joined a boutique Hyperion consulting firm in Dallas, Texas.

Jake has spent the past 18 years implementing Hyperion Planning and Essbase solutions for a variety of clients across multiple industries. Certified in both Hyperion Planning and Essbase, Jake holds a BBA in management information systems from the University of Texas at Austin.


Technologies or Products Used: PBCS, Planning, Essbase

Session Summary for Attendees:  Whether you're writing calc scripts or business rules, the process, syntax and techniques are largely the same. This session will cover advanced calculation techniques, including block mode vs. cell mode, bottom-up vs. top-down, string functions, and functions that leverage regular expressions. If you've ever wondered what you can and can't do on the left side of an equation, this is the session for you!