Aimed at everyone from novices to seasoned veterans, this handbook—by OneStream Distinguished Architect Jon Golembiewski—will break down the Finance Engine and outline how to write Finance Business Rules and Calculations. Its insights will help propel OneStream applications to the next level.

• Fundamentals of the Finance Engine
• Detailed breakdown of the Cube and Data
• A look under the hood of the api.Data.Calculate function
• Techniques for tackling complex calculation requirements
• How to use the Custom Calculate function to make calculations dynamic
• How to write calculations for optimal performance
• How to troubleshoot calculations
• How to solve and avoid common errors and pitfalls
• Real-world calculation examples with detailed explanations
• A full application with all referenced code examples is available to download upon request from OneStream Press

To access the complete publication, you must purchase either the PDF or the physical copy of the book. Purchases can be made at onestreampress.com.

Table of Contents

Introduction
Chapter 1: Finance Engine Basics
Chapter 2: Cube Data - Available Excerpt
Chapter 3: api.Data.Calculate
Chapter 4: The Data Buffer Cell Loop
Chapter 5: Reporting Calculations
Chapter 6: Managing Calculations
Chapter 7: Troubleshooting and Performance
Chapter 8: Common Rule Examples