About Foundation Second Edition
Beyond offering a training guide, the focus of this book is on the ‘why’ of design and building an application. While the foundational principles of building a solid, scalable OneStream application have remained largely unchanged, updates contained in this second edition reflect implemented software enhancements, along with the ongoing development of the OneStream landscape. Manage your Implementation with the OneStream methodology Understand Design and Build concepts Build solutions for the Consolidation of financial data, and develop Planning models Create Data Integration solutions that will feed your models Develop Workflows to guide and manage your End-Users Advance your solutions with Rules and Security Take advantage of detailed Data Reporting using tools such as Analytic Blend and Advanced Excel functionality Tune Performance, and optimize your application New content on Workspaces, Smart Integration, Dashboard design, and more. Over 180 updated images. The information contained within this book is relevant to software version 8.4.0. 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 Foreword by Tom Shea Introduction [Peter Fugere, updated by Chul Smith] Methodology and the project [Greg Bankston, updated by Greg Bankston] Design and Build [Peter Fugere, updated by Chul Smith] Consolidation [Eric Osmanski, updated by Nick Bolinger] Planning [Jonathan Golembiewski, updated by Jonathan Golembiewski] Data Integration [John Von Allmen, updated by Joakim Kulan] Workflow [Todd Allen, updated by Chul Smith] Rules and Calculations [Nick Kroppe and Chul Smith, updated by Nick Kroppe and Chul Smith] Security [Jody Di Giovanni, updated by Bobby Doyon] Reporting [Jacqui Slone and Chul Smith, updated by Chul Smith] Excel and Spreadsheet Reporting [Nick Blazosky, updated by Nick Blazosky] Analytic Blend [Andy Moore, Sam Richards, and Terry Shea, updated by Chul Smith] Introduction to the Solution Exchange [Shawn Stalker, updated by Shawn Stalker] Performance Tuning [Jeff Jones and Tony Dimitrie, updated by Jeff Jones]About Admin
Whether you are a novice or seasoned administrator, this book examines key concepts to help you understand and manage the financial and data processes of your OneStream application. Written for administrators, this book is filled with technical and functional contexts – whether syntax-related to business rules or general accounting concepts – and dives into practical examples and use cases that provide guidance and insights into commonly encountered themes. By the end of this book, you will have a deep understanding and appreciation of the capabilities that the OneStream platform offers, and have the tools needed to tackle the wide variety of administrative actions that may surface. In this book, we will cover: Components within OneStream, such as application properties, metadata, and workflow Data troubleshooting for missing or off data, whether that is related to integration setup, workflow setup, calculation adjustments in business rules, or more. Translations involving cube and metadata settings, plus the loading and viewing of FX rates. The security framework, and all the nooks and crannies that can be secured within OneStream. Constraining and locking data through systems-level and process-level controls. Considerations – as companies mature – for the updating of new or existing business processes. 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 Chapter 1: Introduction Chapter 2: Testing Chapter 3: Application Properties Chapter 4: Metadata Management Chapter 5: Translation Chapter 6: Work the Workflow Chapter 7: Data Troubleshooting Chapter 8: Import and Validation Errors Chapter 9: Constraining and Locking Data Chapter 10: Business Rules Chapter 11: Cube Views Chapter 12: Securing the Pieces Chapter 13: Compliance and Audit Chapter 14: Business as “Usual” IndexAbout Advanced Reporting and Dashboards
Written for administrators, dashboard and report designers, plus end users, and filled with background knowledge and step-by-step guides, this book deep dives into cube views, dashboards, reporting, and highlights the tools and tricks that will take user experiences to a new level. We examine how leveraging the full power of the OneStream Platform will help you move beyond the standard interface, align your end-user experiences with your business and process requirements, promote user adoption through efficiency and ease of use, and truly maximize the value of your OneStream implementation. By the end of this book, you will have a deep understanding of the components that drive the user experience and how and when to use them. You’ll walk away with a plethora of tools and ideas to incorporate into your application to deliver your very own user experience. In this book, we will: Design and build cube views, based on data entry and reporting needs. Discuss the use of cube view extender business rules to expose advanced formatting capabilities. Explore how navigation links and drill to dashboard functionality provide intuitive analysis. Identify the benefits of configuring personalized home pages to ensure user adoption. Create working role-based dashboards inspired by real-world customer requirements. 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 Getting Started Keeping The User in Mind The Moving Pieces OnePlace / Out-of-the-Box Basics Cube View Concepts Fundamentals of Cube View Design and Build Cube View Formatting Taking Cube Views to the Next Level Build Your Own Cube View Dashboards Splash Screens and Home Pages Executive Dashboards Administrator Dashboards Dashboards for Budgeting, Planning, and Forecasting What Have We Learned?About Finance Rules and Calculations
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 ExamplesAbout Foundation
In this practical guide, The Architect Factory team at OneStream Software explains each part of an implementation, and the design of solutions. Readers will learn the core guiding principles for implementing OneStream from the company’s top team of experts. Beyond offering a training guide, the focus of this book is on the ‘why’ of design and building an application. Manage your Implementation with the OneStream methodology Understand Design and Build concepts Build solutions for the Consolidation of financial data, and develop Planning models Create Data Integration solutions that will feed your models Develop Workflows to guide and manage your End-Users Advance your solutions with Rules and Security Take advantage of detailed Data Reporting using tools such as Analytic Blend, Advanced Excel reporting, and Dashboarding Tune Performance, and optimize your application 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 [Peter Fugere] Methodology and the project [Greg Bankston] Design and Build [Peter Fugere] Consolidation [Eric Osmanski] Planning [Jonathan Golembiewski] Data Integration [John Von Allmen] Workflow [Todd Allen] Rules and Calculations [Nick Kroppe and Chul Smith] - Available Excerpt Security [Jody Di Giovanni] Reporting [Jacqui Slone and Chul Smith] Excel and Spreadsheet Reporting [Nick Blazosky] Analytic Blend [Andy Moore, Sam Richards, and Terry Shea] Introduction to the MarketPlace [Shawn Stalker] Performance Tuning I [Jeff Jones and Tony Dimitrie] - Available Excerpt Performance Tuning II [Jeff Jones and Tony Dimitrie]
