The increasing the pace of change in business is putting more pressure on Finance organizations to improve agility in planning, budgeting and forecasting, and to better align Finance and operational plans. Yet many organizations relying on spreadsheets and legacy applications continue to manage based on static budgets, and have difficulty aligning financial and operational plans.
Those organizations who have implemented more modern planning, budgeting and forecasting applications are better equipped to adopt dynamic planning techniques and to align plans and forecasts across the enterprise.
This was the focus of a recent webinar sponsored by OneStream Software, featuring several domain experts in planning and multidimensional analysis. Moderated by OneStream’s CRO Craig Colby, the speakers included Cameron Lackpour, Principal Consultant at OneStream and author of “The Truth About CPM” blog as well as Nick Blazosky, Solution Consultant at OneStream.
Here are the highlights from the webinar.
An Extensible Solution for Dynamic Planning
This webinar was one of the most popular OneStream has hosted, with over 550 registrants and almost 300 attendees. After a brief introduction to OneStream by Craig Colby, Cameron Lackpour took over the controls to provide an overview of the key advantages of OneStream when it comes to planning, budgeting and forecasting. Included here were:
One of the most powerful capabilities covered by Cameron was OneStream’s Extensible Dimensionality®. This is the unique ability of OneStream capture more or less detail, by scenario, to support corporate requirements, while providing more detailed planning and reporting across operating units and departments. Mr. Lackpour commented that this capability is unique to OneStream, no other vendor can do this in the same elegant way.
You can see this in the example below, where data about Operating Sales or Returns and Allowances is captured at a detailed level in the GL, then is mapped to summary accounts in the Budget, then abstracted at an even higher level in the Forecast. The power of this is that the level of dimensionality in accounts, or other dimensions, can vary across scenarios and divisions or departments across the enterprise.
This makes life easy for the users in navigating the system and providing the level of detail they need for reporting, planning or analysis – while not bogging down the system with granular details across every scenario and at every level of the enterprise.
Mr. Lackpour highlighted several other key features of OneStream that make financial close process and operational planning easier.
Lastly, Mr. Lackpour spent some time reviewing the Relational Blending capabilities of OneStream, and the Specialty Planning solutions available in the OneStream MarketPlace, which are critical to performing effective Revenue, Cost of Sales and SG&A Planning.
The Power of Relational Blending
In describing Relational Blending Mr. Lackpour highlighted that most budgeting and planning solutions support “cube-based planning”, which provides consistency and standardization across plans, and efficiency in calculations. But there is a lot of detailed information required for planning that doesn’t belong in a cube, and it better handled in relational tables.
OneStream handles this challenge through its Relational Blending capabilities which are leveraged in our specialty planning solutions. These solutions enable customers to capture very granular, dynamically-changing plan detail data in relational tables, which are summarized into planning cubes – with the ability to drill from the cube back into the relational tables. This approach provides the scalability required for operational planning, as well as high performance on complex calculations – and lets the data reside where it belongs.
Mr. Lackpour then provided an overview of OneStream’s specialty planning solutions which leverage this Relational Blending capability:
Because these solutions are available as optional downloads from the OneStream MarketPlace, customers can choose to use them or not at their discretion. But customers that have deployed these solutions are able to eliminate disconnected spreadsheets, handle large volumes of rapidly-changing planning data, and easily link operational plans to financial plans and forecasts.
Seeing is Believing
Mr. Lackpour’s wrapped up his introduction to planning in OneStream by reinforcing the key point that OneStream is a unified platform, that provides multiple solutions in a single scalable application, that maximizes reuse. The OneStream MarketPlace works just like an “app store”, where users can download, configure and deploy new solutions rapidly – and without adding technical complexity.
His introduction to the planning capabilities of OneStream was followed by a detailed demonstration by Nick Blazosky. Mr. Blazosky’s demonstration covered all the key capabilities highlighted by Mr. Lackpour, as well as others such as:
The live demonstration was followed by a Q&A session where the speakers answered a few questions that were submitted by attendees during the webinar. If you missed the webinar or would like to provide your colleagues a chance to view it, follow the link to the webinar replay below. And if your organization needs help in aligning financial and operational planning, please contact us.
John O’Rourke is Vice President of Product Marketing at OneStream Software. With a background in accounting and finance, John has over 30 years of experience in the software industry, including 20 years of experience in product marketing at Hyperion Solutions, Oracle and Host Analytics. He has worked with many customers and partners on financial reporting and planning initiatives and has spoken and written on many topics in corporate performance management. John has also held positions in strategic marketing and product marketing at Dun & Bradstreet Software, Kenan Systems and Decisyon.