TrustRadius: an HG Insights company

Oracle Hyperion (legacy) vs. PrestoDB (or Presto)

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Oracle Hyperion (legacy)

    Score7.5 out of 10
    N/AOracle's Corporate Performance Management suite was acquired from Hyperion in 2007. Hyperion customers are encouraged to migrate to Oracle Fusion Cloud EPM.N/A

    PrestoDB (or Presto)

    Score10 out of 10
    N/APresto is an open source SQL query engine designed to run queries on data stored in Hadoop or in traditional databases. Teradata supported development of Presto followed the acquisition of Hadapt and Revelytix.N/A
    Pricing
    Oracle Hyperion (legacy)PrestoDB (or Presto)
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    Oracle Hyperion (legacy)PrestoDB (or Presto)
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Features
    Oracle Hyperion (legacy)PrestoDB (or Presto)
    Budgeting, Planning, and Forecasting
    Comparison of Budgeting, Planning, and Forecasting features of Oracle Hyperion (legacy) and PrestoDB (or Presto)
    Feature
    Oracle Hyperion (legacy)
    10.0
    22 Ratings
    8% above category average
    PrestoDB (or Presto)
    -
    Ratings
    Long-term financial planning10.017 Ratings00 Ratings
    Financial budgeting10.020 Ratings00 Ratings
    Forecasting10.021 Ratings00 Ratings
    Scenario modeling10.016 Ratings00 Ratings
    Management reporting10.021 Ratings00 Ratings
    Analytics and Reporting
    Comparison of Analytics and Reporting features of Oracle Hyperion (legacy) and PrestoDB (or Presto)
    Feature
    Oracle Hyperion (legacy)
    8.2
    20 Ratings
    9% below category average
    PrestoDB (or Presto)
    -
    Ratings
    Personalized dashboards8.018 Ratings00 Ratings
    Color-coded scorecards7.115 Ratings00 Ratings
    KPIs9.917 Ratings00 Ratings
    Cost and profitability analysis9.917 Ratings00 Ratings
    Key Performance Indicator setting8.015 Ratings00 Ratings
    Benchmarking with external data6.013 Ratings00 Ratings
    Best Alternatives
    Oracle Hyperion (legacy)PrestoDB (or Presto)
    Small Businesses
    No answers on this topic
    Amazon RDS
    Score8.1 out of 10
    Medium-sized Companies
    No answers on this topic
    SingleStore
    Score8.2 out of 10
    Enterprises
    No answers on this topic
    SAP IQ
    Score5.4 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Oracle Hyperion (legacy)PrestoDB (or Presto)
    Likelihood to Recommend
    10.0
    (23 ratings)
    7.8
    (2 ratings)
    Likelihood to Renew
    5.0
    (1 ratings)
    -
    (0 ratings)
    Support Rating
    8.0
    (1 ratings)
    -
    (0 ratings)
    User Testimonials
    Oracle Hyperion (legacy)PrestoDB (or Presto)
    Likelihood to Recommend
    Discontinued Products
    Well suited: For use in multiple offices around the world. I was able to obtain financial reporting data from 5 foreign offices and then consolidate their data with 3 domestic USA offices to prepare a consolidated financial statement. Less Appropriate: Translating the financial value for consulting services could be a bit challenging because that required human interaction and judgement. It would have been great to be able to set up some software to be able to interpret this and let it run for all future project work revenue projection.
    Incentivized
    Read full review
    Open Source
    Presto is for interactive simple queries, where Hive is for reliable processing. If you have a fact-dim join, presto is great..however for fact-fact joins presto is not the solution.. Presto is a great replacement for proprietary technology like Vertica
    Incentivized
    Read full review
    Pros
    Discontinued Products
    • This product handles budgeting by Employee and/or Position very well. It is highly flexible and allows Hyperion administrators the ability to develop a planning application that fits a variety of different business needs.
    • It is great at calculating benefits using business rules to automate the population of these fringe costs in the overall budget planning process. This greatly reduces user error.
    • It allows you to seed the operating budget based on changes to key drivers, such as percentage increases, flat dollar increases and more detailed changes using business rules.
    • Allows visibility into the plans for each unit across the organization, rolled up into an overall budget for the campus.
    • It handles the creation of budgets with multiple chartfield segments or dimensions, which most other budgeting systems cannot handle well. It can aggregate these very quickly.
    Incentivized
    Read full review
    Open Source
    • Linking, embedding links and adding images is easy enough.
    • Once you have become familiar with the interface, Presto becomes very quick & easy to use (but, you have to practice & repeat to know what you are doing - it is not as intuitive as one would hope).
    • Organizing & design is fairly simple with click & drag parameters.
    Incentivized
    Read full review
    Cons
    Discontinued Products
    • One pain point for us is the consolidation and translation process. Needing to translate the data over and over again is frustrating and there is no visibility into how many users are running a translation. If multiple users attempt to translate the same data set, say goodbye to your performance but you have no way of knowing! (Unless you want to pull up a task audit which is not a very realistic expectation). It has the been the quickest way for us to bring the system to it's knees. The consolidation process performs in direct correlation to the complexity of the calculation/consolidation rules. So, while the product is extremely flexible, you still have to be careful how you design your rules and calculations to make sure that you do it on the smallest subset of data as possible to avoid large processing times. This makes sense, but requires some significant expertise that most organizations do not have in-house.
    • The Hyperion Financial Reporting product is ridiculously outdated and clunky to use. The interface for designing reports is not intuitive, and not easy to modify once a report is built. I think there must be a strategic decision to move away from it and go to something more like Oracle BI because I just can't understand why in the world they don't update the reporting product. It also requires a significant level of expertise to be able to use. Not a great solution at all if you want multiple end-users to create reports in something other than Excel. Nobody except the HFM admin (which I used to be) in our company even touches this module.
    • Another pain point is the amount of IT support that is required to run this thing, and again, specialized knowledge of Hyperion products and how they work is required for IT to adequately support it. This goes for application servers and the Oracle database that the applications are running on.
    Read full review
    Open Source
    • Presto was not designed for large fact fact joins. This is by design as presto does not leverage disk and used memory for processing which in turn makes it fast.. However, this is a tradeoff..in an ideal world, people would like to use one system for all their use cases, and presto should get exhaustive by solving this problem.
    • Resource allocation is not similar to YARN and presto has a priority queue based query resource allocation..so a query that takes long takes longer...this might be alleviated by giving some more control back to the user to define priority/override.
    • UDF Support is not available in presto. You will have to write your own functions..while this is good for performance, it comes at a huge overhead of building exclusively for presto and not being interoperable with other systems like Hive, SparkSQL etc.
    Incentivized
    Read full review
    Likelihood to Renew
    Discontinued Products
    We're in the middle of the road because we are not sure that other products on the market fit the bill for what we need yet. Hyperion is expensive and burdensome from an administrator and maintenance standpoint, but it still seems to be the best solution for what we need. Show us an equally capable SaaS consolidation product and we'll talk again.
    Read full review
    Open Source
    No answers on this topic
    Support Rating
    Discontinued Products
    The premium support team provides much needed dedicated customer service which we are after for what we have paid for this service. We are satisfied with the service and support and do not have any instance where there was an issue that requires escalation to get the right support team. Though the incidence of major issues that requires the premium support are less, we prefer to keep this as a safety net.
    Incentivized
    Read full review
    Open Source
    No answers on this topic
    Alternatives Considered
    Discontinued Products
    I use Oracle Hyperion Enterprise Performance Mangement because the company I work at requires me to use it in the Financial Planning sector as most of their data is stored in it. I am open minded and ready to use other performance management tools created by Oracle if my work permits.
    Incentivized
    Read full review
    Open Source
    Presto is good for a templated design appeal. You cannot be too creative via this interface - but, the layout and options make the finalized visual product appealing to customers. The other design products I use are for different purposes and not really comparable to Presto.
    Incentivized
    Read full review
    Return on Investment
    Discontinued Products
    • Oracle Hyperion allows us to automate and consolidate financial data that used to be performed manually in spreadsheets. From that perspective the ROI is huge.
    • Oracle Hyperion functionality is extensive and allows us to perform most functions for planning, consolidating and reporting on our financial data.
    • One negative with Oracle Hyperion is that it is complicated to implement and maintain. It takes expertise at all levels (infrastructure and management) to realize the benefits from it.
    Incentivized
    Read full review
    Open Source
    • Presto has helped scale Uber's interactive data needs. We have migrated a lot out of proprietary tech like Vertica.
    • Presto has helped build data driven applications on its stack than maintain a separate online/offline stack.
    • Presto has helped us build data exploration tools by leveraging it's power of interactive and is immensely valuable for data scientists.
    Incentivized
    Read full review
    ScreenShots