The latest release in the OneStream XF Market Place is one that we have been looking forward to since the sneak preview at Splash last year: a Predictive Analytics Market Place solution. This solution allows you to use your EPM data to model a forecast. And, even for a first release, it’s filled with options and competitive against other available solutions.
The most common issue with predictive systems is the quality of the source data. Without proper data quality used for input, what can be expected of the outcome? That’s exactly where OneStream XF distinguishes itself. The platform has a very sophisticated and extensive data quality setup. Guided workflows, full transparency, audit trails, and data controls ensure that the quality of the gathered data is high. Using this data as the source of a predictive model will deliver high quality in the results of your predictive model. And the great news is, all that is now available to every OneStream client.
So, where do you start with Predictive Analytics? We’ll first describe the setup of the solution and after that the usage and outcomes.
How to setup Predictive Analytics
Next to the configuration of database settings that are also required for many other Market Place solutions, Predictive Analytics requires the ‘installation’ of the OneStream Data Science Package. As you might now, data scientists often use Python as one of the instruments in their toolkit. OneStream offers a pre-configured folder that contains the required Python functionality to be used by this Market Place solution. The only requirement is to copy this folder to a location (server or shared drive without execution restrictions) that is accessible from your OneStream environment. The path where you paste this folder is used later during the configuration of Predictive Analytics. If you have a OneStream cloud, the support team will do this for you.
The next step is to import the solution zip via Application Tools > Load/ Extract:
Now the dashboard is available in OnePlace > Dashboards with buttons to create the tables and launch the solution.
In the right top, you’ll find the settings button where you need to enter the path to the Python library in the Global Options page. After that, you’re set up and ready to start configuring models. Make sure the path ends with Python.exe, so not just the folder!
How to configure models
The Predictive Analytics homepage contains 3 main items.
- Setup – to configure predictive models, such as data sources and model length.
- Predict – to run your predictive models against a pre-configured cube-view.
- Audit – to analyze the executed models.
The first step is to set up a template from the Setup screen by clicking the Add button:
The template can be modified via the Edit button but once a model is run, the elements of the Cube View and scenario section cannot be modified anymore. However, you can also easily copy a template if you want to change some parameters.
The template fields are described in detail in the Setup instructions, so I won’t describe all.
Some interesting template fields are:
- Reference Period – last period of the historical dataset
- Historical Range – need 18 to 48 months, dependent on the type of prediction. I’ve created some test data from jan2015 – dec2018 and will load my results to the same scenario as my actual data.
- Default Model – Select a specific Analytical model or a selection where OneStream automatically uses the best one.
The data in a Cube View is the basis for your predictive analysis. The user executing the model must have proper access rights to that Cube View, which means the user can modify data and Access and Maintenance groups. Predictive Analytics doesn’t take the Cube View security into account, so this needs to be set in the Cube View itself to prevent any overrides.
Please note that in the current version it is not (yet) allowed to pull data from multiple cubes in a single Cube View as the source for Predictive Analytics.
Next to that, Bound parameters are required for the different dimensions in the Cube View:
Now your model is configured, you’re good to go.
How to execute your model
After saving your template you can go directly to the Predict page via the buttons on the top. Here you need to select the template we’ve just created:
When you select a data cell in the Cube View that has a template available -for which you’ll need to be in the right Period, 2018M12 in my case – you can press the play button to calculate the model:
You can also press Calculate All to run the available models for your entire Cube View but that can take a while, especially if you haven’t selected specific models and set it to auto. On my demo machine, the environment freezes for a while). Calculating took 10 minutes in my situation:
When the model has been executed for the selected cell, the bottom panel of the dashboard will be populated with the original and predicted data:
After running it for 1 account, the forecasted data is automatically populated (on-base level) and visible in the cube view:
Not all historic periods you’d like to use have to be available in the Cube View. For example, in my case, the Cube View starts at 2018M6 while I use 12 months of historic data.
After running your model, you can clear the results, view the model in detail and comment on the outcomes:
Here you see the best matching models and can select one of them so show the figures attached to it. However, only the best matching outcomes are stored in your cube view.
Analysis and other points of attention
There is also an Audit sheet where you can have an overview of which models have been run by whom on which accounts:
Here you can also review all comments.
For best results, a minimum of 18 months of data is required. For seasonality OneStream advises 24 months and ARIMA (Autoregressive Integrated Moving Average) even 48 months.
The current version supports the most common and frequently used forecasting methods, such as:
- Simple Exponential Smoothing
- Holt Linear (Additive and Multiplicative)
- Holt-Winters Exponential
- Seasonal Additive
- Holt-Winters Exponential Multiplicative
- Holt-Winters Damped Method
- Autoregressive Integrated Moving Average (ARIMA) (also Seasonal)
If you’re not really into statistics, the details of these methods are added as an appendix to the Predictive Analytics 123 Setup Instructions for your reference.
The solution comes with a few default dashboards that can also be embedded in your application dashboards. To do this the Server Task Argument needs to be set up properly, so make sure the right template is shown.
Predictive Analytics is a great addition to your OneStream XF platform, enabling users to create predictive models for more insight into your business.
Pros of OneStream Predictive Analytics:
+ Automatically selecting the best predictive model for your data that can even vary by account
+ Easy to configure and play with your models
+ No (technical) Statistical knowledge required to start modeling on your own data
Cons of OneStream Predictive Analytics:
– Running complex prediction models takes time. Dependent of the size of your dataset, you may need to have some patience.
The setup is described in detail in the documentation and the configuration is easy. Therefore, I classify this solution as Admin Configurable. Please see my earlier post ‘The OneStream XF Market Place in real life’ about classifications.
Let’s discover the OneStream Market Place together
Want to know more about the OneStream Market Place? In a series of blogs, we’ll delve into the details of the Market Place and the solutions available. In the blog ‘The One Stream Market Place in real life’ you’ll find more details about the basics of the Market Place. And in the blog ‘Why you get more out of your OneStream XF software with Task Manager (UTM)’, we discussed why the Task Manager is so popular.
Any questions or suggestions for a Market Place solution you would like to read about? Don’t hesitate to contact me!
Do you prefer to discuss the details live? During our Finext OneStream event we’ll share our experiences as well. This event will take place on April 21 in Amsterdam. Registration will open soon, please let me know if you’d like to receive more information about this event.
IFRS 16 – Step by step towards full compliance
As a company, you are working year after year to comply with new regulations. If you have just completed the implementation of the GDPR, IFRS16 (the new lease standard) is already upon us. To make ...
iXBRL – Leveraging compliancy into efficiency
Regulations prescribe the need for EU-listed companies to report annual disclosures from 2020 onwards in a new format: iXBRL. Because of the mandatory nature of this filing, corporates should already ...
How to implement Scenario Analysis in OneStream XF
Looking for a Scenario Analysis solution? OneStream has recently released a new solution in its Market Place: Scenario Analysis 123. This solution helps you to create and manage multiple rules and to ...
Optimizing financial processes at Ampleon
Ampleon is a worldwide leader in innovative, high-quality RF (radio frequency) Power technology. With a possible IPO, it is essential to the former business unit of NXP to establish a robust financial...