OneStream vs. Oracle Autonomous Data Warehouse

Financial Planning / Forecasting, People Planning, and Financial Close and Consolidation are well suite while we are still evaluating GL Account Reconciliations and other solutions available via the Solution Exchange. Overall, we believe OneStream is going to allow us to "get out of excel" and perform Global Consolidation in the system

Incentivized

Invited by the Vendor

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

II would recommend Oracle Autonomous Data Warehouse to someone looking to fully automate the transferring of data especially in a warehouse scenario though I can see the elasticity of the suite that is offered and can see it is applicable in other scenarios not just warehouses.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Consolidation of Group Results across 600 Entities
• Flexibility of Reporting through Dashboard Reporting Suite and Excel Interface
• Ability to create Bespoke Models for specific requirements. (Ifrs15/16/BC/DC/Payroll, Covenance Reporting, etc.)
• Singular Cube for One source of the Truth
• Customisable Maintenance Platform to facilitate high growth strategy

• Very easy and fast to load data into the Oracle Autonomous Data Warehouse
• Exceptionally fast retrieval of data joining 100 million row table with a billion row table plus the size of the database was reduced by a factor of 10 due to how Oracle store[s] and organise[s] data and indexes.
• Flexibility with scaling up and down CPU on the fly when needed, and just stop it when not needed so you don't get charged when it is not running.
• It is always patched and always available and you can add storage dynamically as you need it.

• Journal copy feature would be good to have
• The Excel Add in is limited to only one application. Would be good to have the ability to pull from say Dev and Prod so side by side comparisons could be done
• Better interface to handle metadata changes

• It is very expensive product. But not to mention, there's good reasons why it is expensive.
• The product should support more cloud based services. When we made the decision to buy the product (which was 20 years ago,) there was no such thing to consider, but moving to a cloud based data warehouse may promise more scalability, agility, and cost reduction. The new version of Data Warehouse came out on the way, but it looks a bit behind compared to other competitors.
• Our healthcare data consists of 30% coded data (such as ICD 10 / SNOMED C,T) but the rests is narrative (such as clinical notes.). Oracle is the best for warehousing standardized data, but not a good choice when considering unstructured data, or a mix of the two.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

Currently we are using OneStream with people 80 - 100 to load the PL, BS , Forecast budget and People Planning. OneStream give us more visibility on trend and way forward thinking. Thanks to OneStream for the tool which helps the business in growing way. Thinking of innovation OneStream is right path.

Incentivized

Invited by the Vendor

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

Because

• It is really simple to provision and configure.
• Does not require continous attention from the DBA, autonomous features allows the database to perform most of the regular admin tasks without need for human intervention.
• Allows to integrate multiple data sources on a central data warehouse, and explode the information stored with different analytic and reporting tools.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

Overall usability as an end-user is very easy. There are more people in the system getting information now than the prior platform used. People are gathering their information quicker as well. From an administrator standpoint, there are fewer glitches and issues than the prior platform. This is very good.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

OneStream support is focused on the infrastructure. Which means mainly when there issues with accessing to the system, they will be able to help. When the question is to much leaning towards functional it really becomes billable. The other issue is that the response time is not optimal. There is a lot of pingpong of messages and the time between the message can sometimes be long. Sometimes this result into a simple ticket to be taking days before it is closed.

Incentivized

Invited by the Vendor

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

onestream offers a range of training. I have attended a number of trainings. During the trainings a vast amount of information is discussed. The trainings also include exercises. The speed of the training is pretty high. When reviewing the training material afterwards, I found that the material is not complete as reference as it relies also very much on the verbal explanation and elaboration.

Incentivized

Invited by the Vendor

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

Understanding Oracle Cloud Infrastructure is really simple, and Autonomous databases are even more. Using shared or dedicated infrastructure is one of the few things you need to consider at the moment of starting provisioning your Oracle Autonomous Data Warehouse.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

OneStream is the overall clear winner against HFM. There are a few things HFM does better (a couple things in Smart View), but it just doesn't have as much capability. The single, integrated platform that OneStream is provides a massive upgrade from HFM.

Incentivized

Invited by the Vendor

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

As I mentioned, I have also worked with Amazon Redshift, but it is not as versatile as Oracle Autonomous Data Warehouse and does not provide a large variety of products. Oracle Autonomous Data Warehouse is also more reliable than Amazon Redshift, hence why I have chosen it

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Customers have moved from multiple EPM systems as well as multiple EPM applications to OneStream.
• Their ROI has been quite high as lesser admins are required, no need to move data back & forth, no need for an additional dashboarding / BI tool, once a user is on OneStream can leverage it for more than 50+ use cases at no additional license cost.
• Automation, direct integration, scheduling, complex calculation capabilities, all help to further improve ROI and free up the time for the team to do value-adding tasks.
• Last but not the least is the confidence on the numbers is much higher.

• Overall the business objective of all of our clients have been met positively with Oracle Data Warehouse. All of the required analysis the users were able to successfully carry out using the warehouse data.
• Using a 3-tier architecture with the Oracle Data Warehouse at the back end the mid-tier has been integrated well. This is big plus in providing the necessary tools for end users of the data warehouse to carry out their analysis.
• All of the various BI products (OBIEE, Cognos, etc.) are able to use and exploit the various analytic built-in functionalities of the Oracle Data Warehouse.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info