About This Book

Publication

Published in 2024 by OneStream Press.

Copyright (c) 2024 OneStream Software LLC, Matt Ha, Eric Hanson, Jannesa Zhang

OneStream and the OneStream logo are trademarks of OneStream Software LLC, www.OneStream.com, and used with permission.

ISBN: 978-1-8382528-1-6

All Rights Reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording or otherwise, without the prior permission of the publisher.

This book is sold subject to the condition that it shall not, by way of trade or otherwise, be lent, re-sold, hired out or otherwise circulated without the publisher’s prior consent in any form of binding or cover other than that in which it is published and without a similar condition including this condition being imposed on the subsequent purchaser.

OneStream Press has endeavored to provide trademark information about all the companies and products mentioned in this book by the appropriate use of capitals. However, OneStream Press cannot guarantee the accuracy of this information. OneStream Press is an imprint of Play Technologies (England) Limited. 6 Woodside, Churnet View Road, Oakamoor, ST10 3AE, United Kingdom.

www.OneStreamPress.com

Disclaimer

While the advice and information in this book is believed to be true and accurate at the date of publication, OneStream Press, the authors, and OneStream Software LLC do not guarantee the accuracy, adequacy, or completeness of any information, and are not responsible for any errors or omissions or the results obtained from the use of such information.

OneStream Press, the authors, and OneStream Software LLC make no warranty, express or implied, with respect to the material contained herein, and hereby disclaim any liability to any party for any loss, damage, or disruption caused by errors or omissions, whether such errors or omissions result from negligence, accident, or any other cause.

About the Authors

Matt Ha joined the OneStream services team in 2019 with a background in data science and systems implementation. As a Lead Technical Consultant, his main roles are acting as a technical SME and triaging complex technical builds across various projects. He was born and raised in LA but got his degree in Mechanical Engineering in the Bay Area, where he currently lives in an overpriced tiny box. In his free time, you can find Matt backpacking or skiing in the outdoors (depending on the weather), making gifts for friends in his woodshop (i.e., dad’s garage), or getting voluntarily beat up at the local jiu-jitsu gym.

Dedicated to my family, friends, and girlfriend Annie, who has been extremely patient in rescheduling date nights so I could meet my chapter deadlines.

Eric Hanson joined OneStream Software in 2021 and currently serves as a Director of North America Consulting Services for the South Region. He started his OneStream career as a Senior Consultant after leaving a customer who had implemented OneStream. Eric has implemented solutions for some of the largest customers at OneStream. He now leads a highly skilled implementation team that focuses on configuring and implementing OneStream successfully for customers.

Firstly, this book is dedicated to my wife (Jessye) and two children (Brant and Owen). All three of you are my pillars of support and love. You have continued to be my support system even when times are hard. Next, the book is dedicated to all of my colleagues at OneStream who have helped make me a better OneStreamer. A specific shoutout to Eric Osmanski, Chul Smith, Sam Richards, Nick Blades, and the entire Services Team. I also owe a debt of gratitude to past colleagues as well (Mark – H, S, A, I, Cynthia, Ana, Melissa, Denna). Next, thank you to Amanda G. for continuing to guide and support me through the process. Finally, this book wouldn’t have been possible without my other two authors – Matt and Jannesa – both of whom are two of the smartest and (most importantly) kindest humans on planet Earth.

Jannesa Zhang joined OneStream in 2019. Her experience involves nearly a decade in the EPM and consulting space, where she enjoys enhancing financial processes through software enablement and tackling some of the most complex customer requirements in the consolidations and planning space.

To my family and friends who encourage me to go for it. I am still unclear what “it” is, and I guess I’ll figure “it” out.

To my OneStream colleagues who have provided me with overwhelming behind-the-scenes support and encouraged me to be a little better than I am each and every day, and for that I strive to continue and to extend the same goodwill and care to those around me. I want to thank George Waddell for being such a great advocate and providing me with guidance when I was a fresh punk out of college, new to this whole EPM and consulting area, and then convincing me to join OneStream! I want to thank Chul Smith for providing the solid foundation and understanding of OneStream (it also helps that I happened to be staffed on all the projects you were overseeing as architect and had no choice but to share some of your insights 😊). Thank you, Jenn Stemm, for bringing the new-ish hire under your wing and showing me the magical power of establishing clear lines of communication and expectations when the sh$t hits the fan; glad to know I could learn from the best. Thank you, Eric Osmanski; by sheer chance and on my first day with the company, I happened to sit next to you in Boston, and I distinctly remember asking you, “How do I login to

OneStream?” – gosh how far I have come with my questions – and I am very appreciative that you still respond to my questions! Finally, Matt Ha and Eric Hanson – I can’t believe I bamboozled you into writing a book with me; thanks for being such great sports about it and I hope we can still be friends.

Technical Reviewers

Peter Fugere is recognized as a leader within the corporate performance management (CPM) community, where he has been working to deliver world-class solutions for the past 25 years. He has worked extensively with Oracle Hyperion Financial Management, Oracle Hyperion Planning, Oracle EPM Cloud Financial Consolidation and Close, Oracle Hyperion Financial Data Quality Management, Hyperion Enterprise, Upstream, and SAP BPC (Business Planning and Consolidation) before leaving Hyperion in 2004 to help build another consulting practice. He has published books and written whitepapers on the topic of implementation and best practices. He joined OneStream in 2013, is currently OneStream’s Chief Solution Officer, and is responsible for OneStream’s “Architect Factory”.

Eric Osmanski is the Vice President of Solution Network Architecture where he is responsible for the strategy, planning, and execution of solution development projects, including leading engagements with development partners pursuing similar initiatives. Prior to his current role, he was a Distinguished Architect focusing on the design, development, and maintenance of applications for OneStream’s largest and most complex customers.

Chul D. Smith has over 25 years of accounting, finance and IT experience using, maintaining, implementing and supporting consolidation and finance systems as both client and consultant. In 2006, he moved from corporate consolidations in Minneapolis, MN to HFM consulting in Paris, France. In 2007, he relocated to London, England, where he spent the next four years consulting with a small Swedish IBM Cognos Controller consultancy. The use of Controller across Europe expanded his work experience to nine countries in multiple industries.

His 2012 United States homecoming triggered his return to HFM and FDM as a freelance consultant with projects in New York City, Montreal, and Sherbrooke, Quebec. He began working with OneStream XF in 2013, and a year later was hired to join their services team. Today, he’s a Distinguished Architect within OneStream’s Strategic Customer Advisory team.

Chul holds a Bachelor of Science in Accounting from the University of Minnesota – Carlson School of Management and a non-practicing CPA license in the state of Minnesota.

Errata

Despite best efforts, mistakes can sometimes creep into books. If you spot a mistake, please feel free to email us at [email protected] (with the book title in the subject line).

The errata page for this book is hosted at www.OneStreamPress.com/Admin

Version Updates

The OneStream platform is constantly evolving, with each release bringing new features and capabilities. The majority of the material in this book covers the OneStream Platform Version of at least 7.3 while incorporating a few features that are only available with Version 8.0 at the time of writing.