Announcement
ABCRecent Activity
Data Processing and Performance - A comprehensive guide of tables, and design
Overview To maintain well performing application, one must understand how the underlying database works and more importantly its limitations. Understanding how a system works, allows designers and administrators to create reliable, stable, and optimal performing applications. This white paper is intended to guide the design of those optimal data processing strategies for the OneStream platform. First, this document will provide a detailed look at the data structures used by the stage engine as well as those used by the in-memory financial analytic engine, providing a deep understanding of how the OneStream stage engine functions in relation to the in-memory financial analytic engine. The relationship between stage engine data structures and finance engine data structures will be discussed in detail. Understanding how data is stored and manipulated by these engines will help consultants build OneStream applications that are optimized for high-volume data processing. Second, the workflow engine configuration will be examined in detail throughout the document since it acts as the controller / orchestrated of most tasks in the system. The workflow engine is the primary tool used to configure data processing sequences and performance characteristics in an OneStream application. The are many different workflow structures and settings that specifically relate to data processing and these settings will be discussed in relation to the processing engine that they impact. Finally, this document will define best practices and logical data processing limits. This will include suggestions on how to create workflow structures and settings for specific data processing workloads. With respect to data defining processing limits, this document will help define practical / logical data processing limits in relation to hard/physical data processing limits and will provide a detailed explanation of the suggested logical limits. This is an important topic because in many situations the physical data processing limit will accept/tolerate that amount of data that is being processed, but the same data may be able to be processed in a much more efficient manner by adhering to logical limits and building the appropriate workflow structures to partition data. These concepts are particularly important because they enable efficient storage, potential parallel processing and high-performance reporting/consumption when properly implemented. Conclusion Large Data Units can create problems for loading, calculating, consolidating, and reporting data. This really is a limitation of what the hardware and networks can support. Your design needs to consider this. This paper provides some options to relieve some of the pressure points that could appear. NOTE: some tables mentioned in the paper have changed in version 9+. See this note for further details.July 2025 Certification Prep Webinar
Are you ready to schedule your OneStream certification exam, but need a little more preparation? The OneStream Certification Program is pleased to announce our first Certification Prep Webinar for the OneStream Certified Specialist (OCS) - Reports and Dashboards exam! Join us on Thursday, July 31, 2025, at 10:30am ET as we will have experts from OneStream facilitate a 60-minute session on these exam topics: Workspaces Cube Views Dashboard Components ...and more! Our experts presenting will be: Stephen Roberts, Sr. Technical Education Consultant Nicki Baretta, Manager, Remote Consulting Register today to reserve your space today!
OneStream and D365 Integration
Hi everyone, I'm currently working on integrating OneStream with Dynamics 365 (D365) and would love to hear about your experiences. Specifically, I'm interested in knowing which connector you used for the integration. Did you opt for OData, Synapse Link, or another method? Any insights, tips, or recommendations would be greatly appreciated! Thanks in advance!
How can I become a Advanced User of Member Filter Builder in QuickView
I am a Financial Planner and Analyst and My Organization use OnStream. I want to understand better how to extract the data for Multiple scenarios (act, fcst, budget, py) using Member filters, variables understand workflows, and parameters?June 26th: Platform Power Hour Webinar - Genesis
Join us on Thursday, June 26 at 10 AM ET / 4 PM CET to learn how you can ‘Configure, Adapt, and Grow Without Limits’ using Genesis, a Plug-and-Play Architecture available in OneStream v9. In this webinar we’ll demonstrate how Genesis can help you: Easily design and deploy new financial and operational models, planning processes and reporting solutions Create highly curated and personalized dashboards, menus, and user experiences without code Modify existing dashboards to add additional reporting, analytics, and insights Incorporate AI into specific business workflows with AI Narrative Summarization and Commentary Can't attend? Register anyway and we'll send you a link to the recording.
Graph and Charts in OneStream
Hello I have a query regarding Graph editing in OneStream I wanted to know how we can edit the graph in OS. Eg: The client has a waterfall chart built for the EBIDTA and they have the previous 2 years comparison as well. However the October and Nov month shall start from the start point 0 similar to Sept Month whereas currently they start where the previous moth ends. Also the colour of the bar for Oct and Nov shall be Blue similar to Sept and Dec monthLearn about Genesis on the June Edition of Tech Talks!
Register now for the June edition of Tech Talks. On this episode, Jacqui Slone and Doug Kinchley join Matt Kerslake to discuss OneStream Genesis. Join them and learn how Genesis is unlocking new possibilities for finance teams to click-to-configure new financial and operational models, launch new planning processes, and enhance reporting and analysis with ease. Register now! https://www.onestream.com/events/tech-talks-genesis/Switch - sign to first position in SAP connector
The query from SAP is currently returning the negative sign in the last position of a cell. ex. 20.56- when it should be -20.56 Is there an SAP function I can add to the SAP connector solution that would place the - in the first position and how would I achieve this in OneStream?June 18th: ESG as a Strategic Imperative Webinar with BARC
As ESG Reporting becomes a top priority across organizations, finance teams are under pressure to deliver sustainability insights with the same accuracy and rigor as financial data. But how can you add ESG into your reporting process without adding complexity? Join OneStream and BARC for a discussion on how finance professionals can take the lead in ESG performance and compliance, using unified data and streamlined reporting. In this session, you’ll learn how to: How to align ESG and financial data into a single source of truth How to stay compliant with evolving regulatory requirements – without reinventing your process. In today’s complex environment, the ESG is more than a necessity—it’s your opportunity to lead. Own it. Register for this Webinar https://www.onestream.com/events/global-wbn-tl-esg-18jun2025/
