My Favorite Calc Code

Session Number: 8921
Track: Essbase
Sub-Categorization: Calculations
Session Type: Tips, Techniques and Tuning
Primary Presenter: Ron Moore [Principal Architect - Alithya]
Time: Jun 24, 2019 (03:45 PM - 04:45 PM)
Room: 611, Level 6

Speaker Bio: Ron Moore, a principal architect with Alithya, has more than 20 years of experience with Essbase, versions 3x through 11x, and an extensive background in finance and economics. Ron is certified in Essbase, Planning, and PBCS. He was one of the first Essbase certified consultants in the world. He founded Marketing Technologies Group, which specialized in Essbase and Planning training, consulting, and collaborative development. He has led many full-cycle projects, from gathering requirements and designing through implementation, training, and roll-out. He’s also received 19 Oracle University Quality Awards.
Technologies or Products Used: Essbase, Planning, Calc Manager

Session Summary for Attendees:  How do you learn a new language? How do you figure out how to do something new in a language your already know? Code samples! This is a collection of some of my favorite bits of code. Some of it is useful in every application you build. Some of it solves an unusual problem. Some it of it is just plain cool. This includes BSO and MDX code.

We will also explore some design concepts such as when to use outline formulas vs. script-based calculations, dimensional design for different calculation requirements, and how to take advantage of calc manager's modular approach.
Here are a few of the snippets we will cover:

• Transposing data from one dimension to another
• Forecasting with S curves
• Rolling forecasts
• Using XREF to code overrides
• Useful date calcs
• Useful Planning expressions

This session is designed for developers with a beginning to intermediate skill level in BSO and or MDX calculations.