By Peter Fugere.
This book is not just written for people who want to implement OneStream for the first time, although the flow of the book does follow the lifecycle of design and implementation. Before you even get the product in your company, you will likely need to build a case for buying the tool. This book will help you to understand the three differentiators that OneStream offers, and help you unlock the full value of a project.
Chapter 2, “Methodology and the Project” by Greg Bankston, covers multiple areas when planning for, and beginning, your implementation. We cover things such as requirements gathering, design considerations, choosing a partner, and testing methodologies.
We also discuss the importance of defining scope, and creating a timeline, as well as supporting your application after the project team has moved on. We even tackle the tough topic of project management, particularly regarding why a project manager is critical, along with understanding different methodologies, such as Waterfall and Agile.
Finally, we discuss the overarching challenges of managing your implementation. What critical elements do you have to balance during the course of a project in order to achieve success? What are the trade-offs involved in them? How can you mitigate risk along the way?
At the end of Chapter 2, you should have a solid understanding of how to best position yourself and your implementation for success, and how to handle obstacles as they arise. Experience has shown that challenges always come up, so it’s best to be ready for them!
Chapter 3, “Design” by Peter Fugere, will cover the critical steps when making sure a project gets off on the right foot. This chapter explains how to utilize Cubes and Extensibility to have a good design. This chapter will start to explain key objectives and provide the foundation for beginning your design. You should leave this chapter with a good understanding of what OneStream is capable of.
Then, the chapter will cover key drivers to help identify the goal when embarking upon a project using OneStream, plus the team that should be assembled. The key to having a good project will be starting the first two phases correctly from chapter 2, thus providing a strong foundation for your project. The design part of this chapter will cover the fundamentals of Dimensions, and some key considerations when designing them.
The main aim of this chapter is to explain how you might get better use from the product, by making some simple updates to the design. I will cover many of the tips and techniques you will need to have a great implementation, which will allow the later chapters to go into deeper detail. There is no ‘secret sauce’ to having a great project. There are some simple guiding principles that – when followed – ensure success. In fact, almost every successful consulting company uses quite similar processes and approaches. The key is simplifying the transfer of ownership and ensuring high-speed End-User adoption.
Chapter 4, “Consolidation” by Eric Osmanski, will cover the concepts and approach for building what many consider to be one of the two pillars of CPM. Consolidation is much more than aggregating data. Global enterprises are tasked with solving complex Consolidation challenges every day – often with legacy tools or spreadsheets that are inflexible, create manual work, and unreliable. As an organization grows and becomes more sophisticated, these tools are no longer able to meet the business’s requirements. In this chapter, we cover the most common challenges and the various solutions OneStream’s unified platform can provide, always keeping in mind the balance between maintenance, User experience, and performance.
Chapter 5, “Planning” by Jonathan Golembiewski, takes his years of experience implementing Planning, and explains some of the most important design considerations. Easily the most common use of OneStream, Planning (with the detailed requirements that today’s companies require) is anything but easy. The volumes of data, the complexity of calculations, and the need for flexibility make OneStream just about a necessity.
Chapter 6, “Data Integration” by John Von Allmen, covers the fundamentals of gathering data from disparate source systems and serving it to the OneStream database in a way that provides transparency, auditability, and security.
Chapter 7, “Workflow” by Todd Allen, will cover what the Workflow is. Why do we have Workflow? And where does one start!? Great questions. For folks who are new to OneStream, Workflow is one of the more powerful portions of the tool. We consider it as the backbone of the system. It defines who does what, when, and how.
In this area of the platform, we can import basically any kind of data. Then transform it, validate it, calculate it, automate it, and perform analysis on it. We can even certify it. Those are just some highlights as Workflow has so much to offer. Take the journey with us through the history and evolution of OneStream Workflow!
Chapter 8, “Rules and Calculations” by Nick Kroppe and Chul Smith, breaks down the intricacies of writing rules. If these calculations were easy, most products could do them. They don’t. OneStream expertly handles the most difficult and sophisticated aspects of Consolidation and Planning, from translation, eliminations, and contributions – and why we do what we do in OneStream – it is all covered here.
Chapter 9, “Security” by Jody Di Giovanni and Tony Dimitrie, provides a unique perspective on security, not just from the standpoint of implementation, but from the authors’ world of experience in support. Both see the impact of bad design practices and the rework required to fix them. Jody and Tony’s views and guidance are truly matchless and invaluable, and they will explain the foundational principles for building security that can last for the lifetime of your implementation.
Chapter 10, “Reporting” by Jacqui Slone and Chul Smith, covers reporting fundamentals. A system is only as good as the Reports you create. In this chapter, you’ll learn how to deliver quality Reports that perform to their peak.
Chapter 11, “Excel and Spreadsheet Reporting” by Nick Blazosky, covers all the things you can do with OneStream in Excel. Quick Views, Cube Views, Table Views, Excel, and Spreadsheet. With so many options, which one should you choose and why? This chapter familiarizes readers with the various ad-hoc reporting methods and how to use them. By the end of this chapter, the reader should be an expert in the various means by which to create ad-hoc Reports.
Chapter 12, “Analytic Blend” by Andy Moore, Sam Richards, and Terry Shea, discusses OneStream’s unmatched ability to “blend” validated financial data, highly dimensional operational data, and detailed transactional data in one platform for comprehensive, controlled, and consumable analysis and visualization. You will be able to combine financial, operational, and transactional data in a single Dashboard for all-inclusive visualization and analysis. Allow your finance team to maintain one source of truth for data, extending access to business managers and executives with confidence. And eliminate data latency and unnecessary replication of financial data for analysis, while retaining security, intelligence, Workflow, governance, and audit trails. Phew!
Chapter 13 sees Shawn Stalker cover the “Introduction to the MarketPlace”. It includes a brief history of the MarketPlace and how it was created, then delves into the MarketPlace’s relationship with the platform development team, development processes, how we differ, and how we work together. Shawn then covers what is in the MarketPlace, before diving into environment considerations, solution upgrading, and customization.
Chapters 14 & 15, “Performance Tuning” by Jeff Jones and Tony Dimitrie, covers how to tune and optimize your application. Again, we have two experts – who are responsible for supporting many of our client applications – sharing their experiences. Not only do they give examples, but they explain why and how to resolve numerous issues.
Click on the cover to see the book