OneStream made planning and reporting efficient
March 30, 2024

OneStream made planning and reporting efficient

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with OneStream

OneStream is used for
- Consolidation of 8 international subsidiaries, based on SAP R/3 local data.
- Monthly detailed financial forecast based S&OP plan data and other transactional data extracted from SAP BW, the forecast calculations include profit and loss details on entity level with IC revenue, raw material cost updates and balance sheet calculations with specific details for working capital and other inputs.
Use case of the forecast is to track results versus target and previous forecast.
- Reporting set was build for management reviews, which can be quickly generated by changing variables.



  • Workflows to have step by step processes
  • Import data from different sources with validation of metadata and extensive transformation rules
  • Consistently calculate all variables
  • Freedom to define cost drivers with member formulas
  • Deploying of market place solutions is cumbersome and often requires external support.
  • Calculation of a planning scenario can take quite some time depending on the data structure.
  • Version upgrades require preparation and resources.
  • Reduced corporate month end closing by 2 days, hardly any overtime
  • Dozens of Excel reports and calculation files eliminated
  • 3 days per month were spent on combining numbers, now used to analyze the results.
IBM Analytics seemed quite competitive. OneStream was selected because it has the consolidation and planning functionalities in the same cube. Overall cost for implementation and use were lower.
Lucanet and Anaplan seemed to have less flexibility to adapt the planning functionalities to our use.
Our selection was made in 2020.

Do you think OneStream delivers good value for the price?

Yes

Are you happy with OneStream's feature set?

Yes

Did OneStream live up to sales and marketing promises?

Yes

Did implementation of OneStream go as expected?

No

Would you buy OneStream again?

Yes

It is good for detailed planning based on workflow. Functionality was added to determine raw material purchases, which works well with details we already used to calculate inventories.
Reporting can be very flexible when metadata naming convention is consistent.
Metadata organization is not straightforward, new items are always added at the bottom and can't be sorted.

OneStream Feature Ratings

Long-term financial planning
9
Financial budgeting
9
Forecasting
9
Scenario modeling
8
Management reporting
8
Financial data consolidation
8
Journal entries and reports
7
Multi-currency management
9
Intercompany Eliminations
8
Minority Ownership
8
Local and consolidated reporting
9
Detailed Audit Trails
8
Financial Statement Reporting
8
Management Reporting
9
Excel-based Reporting
9
Automated board and financial reporting
8
Personalized dashboards
9
Color-coded scorecards
8
KPIs
8
Cost and profitability analysis
9
Key Performance Indicator setting
8
Flat file integration
9
Excel data integration
9
Direct links to 3rd-party data sources
8
Pixel Perfect reports
7
Customizable dashboards
7
Report Formatting Templates
7
Drill-down analysis
7
Formatting capabilities
8
Report sharing and collaboration
9
Publish to Web
7
Publish to PDF
9
Report Versioning
7
Report Delivery Scheduling
7
Pre-built visualization formats (heatmaps, scatter plots etc.)
7
Location Analytics / Geographic Visualization
8
Predictive Analytics
8
Multi-User Support (named login)
8
Role-Based Security Model
8
Multiple Access Permission Levels (Create, Read, Delete)
8
Report-Level Access Control
8
Single Sign-On (SSO)
8