What users are saying about
196 Ratings
22 Ratings
196 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.8 out of 100
22 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.8 out of 100

Likelihood to Recommend

Oracle Hyperion

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.
Anonymous | TrustRadius Reviewer

Vertica

Vertica as a data warehouse to deliver analytics in-house and even to your client base on scale is not rivaled anywhere in the market. Frankly, in my experience it is not even close to equaled. Because it is such a powerful data warehouse, some people attempt to use it as a transactional database. It certainly is not one of those. Individual row inserts are slow and do not perform well. Deletes are a whole other story. RDBMS it is definitely not. OLAP it rocks.
Eva Donaldson | TrustRadius Reviewer

Feature Rating Comparison

BI Standard Reporting

Oracle Hyperion
7.4
Vertica
Pixel Perfect reports
Oracle Hyperion
7.2
Vertica
Customizable dashboards
Oracle Hyperion
7.1
Vertica
Report Formatting Templates
Oracle Hyperion
7.8
Vertica

Ad-hoc Reporting

Oracle Hyperion
7.6
Vertica
Drill-down analysis
Oracle Hyperion
8.3
Vertica
Formatting capabilities
Oracle Hyperion
7.7
Vertica
Integration with R or other statistical packages
Oracle Hyperion
7.3
Vertica
Report sharing and collaboration
Oracle Hyperion
7.0
Vertica

Report Output and Scheduling

Oracle Hyperion
6.8
Vertica
Publish to Web
Oracle Hyperion
6.4
Vertica
Publish to PDF
Oracle Hyperion
6.5
Vertica
Report Versioning
Oracle Hyperion
7.1
Vertica
Report Delivery Scheduling
Oracle Hyperion
7.4
Vertica

Data Discovery and Visualization

Oracle Hyperion
7.1
Vertica
Pre-built visualization formats (heatmaps, scatter plots etc.)
Oracle Hyperion
6.9
Vertica
Location Analytics / Geographic Visualization
Oracle Hyperion
7.3
Vertica
Predictive Analytics
Oracle Hyperion
7.2
Vertica

Access Control and Security

Oracle Hyperion
7.3
Vertica
Multi-User Support (named login)
Oracle Hyperion
7.3
Vertica
Role-Based Security Model
Oracle Hyperion
6.6
Vertica
Multiple Access Permission Levels (Create, Read, Delete)
Oracle Hyperion
7.4
Vertica
Single Sign-On (SSO)
Oracle Hyperion
7.9
Vertica

Mobile Capabilities

Oracle Hyperion
5.6
Vertica
Responsive Design for Web Access
Oracle Hyperion
6.1
Vertica
Dedicated iOS Application
Oracle Hyperion
5.0
Vertica
Dedicated Android Application
Oracle Hyperion
5.0
Vertica
Dashboard / Report / Visualization Interactivity on Mobile
Oracle Hyperion
6.2
Vertica

Budgeting, Planning, and Forecasting

Oracle Hyperion
8.2
Vertica
Long-term financial planning
Oracle Hyperion
8.4
Vertica
Financial budgeting
Oracle Hyperion
8.5
Vertica
Forecasting
Oracle Hyperion
8.2
Vertica
Scenario modeling
Oracle Hyperion
7.5
Vertica
Management reporting
Oracle Hyperion
8.5
Vertica

Consolidation and Close

Oracle Hyperion
7.8
Vertica
Financial data consolidation
Oracle Hyperion
8.3
Vertica
Journal entries and reports
Oracle Hyperion
7.9
Vertica
Multi-currency management
Oracle Hyperion
8.2
Vertica
Intercompany Eliminations
Oracle Hyperion
7.7
Vertica
Minority Ownership
Oracle Hyperion
7.4
Vertica
Local and consolidated reporting
Oracle Hyperion
7.8
Vertica
Detailed Audit Trails
Oracle Hyperion
7.6
Vertica

Financial Reporting and Compliance

Oracle Hyperion
8.2
Vertica
Financial Statement Reporting
Oracle Hyperion
8.5
Vertica
Management Reporting
Oracle Hyperion
8.4
Vertica
Excel-based Reporting
Oracle Hyperion
8.9
Vertica
Automated board and financial reporting
Oracle Hyperion
7.7
Vertica
XBRL support for regulatory filing
Oracle Hyperion
7.5
Vertica

Analytics

Oracle Hyperion
7.5
Vertica
Personalized dashboards
Oracle Hyperion
8.0
Vertica
Color-coded scorecards
Oracle Hyperion
7.3
Vertica
KPIs
Oracle Hyperion
7.4
Vertica
Cost and profitability analysis
Oracle Hyperion
7.8
Vertica
Key Performance Indicator setting
Oracle Hyperion
7.2
Vertica
Benchmarking with external data
Oracle Hyperion
7.4
Vertica

Integration

Oracle Hyperion
8.0
Vertica
Flat file integration
Oracle Hyperion
8.2
Vertica
Excel data integration
Oracle Hyperion
8.5
Vertica
Direct links to 3rd-party data sources
Oracle Hyperion
7.3
Vertica

Pros

Oracle Hyperion

  • 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.
Teal Sexton | TrustRadius Reviewer

Vertica

  • Extremely fast query performance - Vertica is one of the fastest query engines out there.
  • Scales to TBs - Scales reasonably well up to 10-20 nodes and 10 - 100s of TB of data.
  • Easy to Use - Fairly easy to user, we made quite some headway with just 1 person running it for a while.
Praveen Murugesan | TrustRadius Reviewer

Cons

Oracle Hyperion

  • 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.
Matt Downing | TrustRadius Reviewer

Vertica

  • Could use some work on better integrating with cloud providers and open source technologies. For AWS you will find an AMI in the marketplace and recently a connector for loading data from S3 directly was created. With last release, integration with Kafka was added that can help.
  • Managing large workloads (concurrent queries) is a bit challenging.
  • Having a way to provide an estimate on the duration for currently executing queries / etc. can be helpful. Vertica provides some counters for the query execution engine that are helpful but some may find confusing.
  • Unloading data over JDBC is very slow. We've had to come up with alternatives based on vsql, etc. Not a very clean, official on how to unload data.
Traian Antonescu | TrustRadius Reviewer

Likelihood to Renew

Oracle Hyperion

Oracle Hyperion 5.0
Based on 1 answer
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.
Matt Downing | TrustRadius Reviewer

Vertica

No score
No answers yet
No answers on this topic

Support Rating

Oracle Hyperion

Oracle Hyperion 8.0
Based on 1 answer
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.
Anonymous | TrustRadius Reviewer

Vertica

Vertica 7.5
Based on 2 answers
I haven't had any recent opportunity to reach out to Vertica support. From what I remember, I believe whenever I reached out to them the experience was smooth.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Oracle Hyperion

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.
Ricky Bhatia | TrustRadius Reviewer

Vertica

SAP HANA, Oracle, MySQL, and PostgreSQL are too heavyweight for achieving real-time latency requirements. Google BigQuery is limited to Cloud that makes hard to integrate with a large ingestion pipeline that may have both Cloud-based and on-prem components. Hadoop is much more complex to setup. Snowflake is again Cloud-based and is a new player so its reputation is not well known.
Anonymous | TrustRadius Reviewer

Return on Investment

Oracle Hyperion

  • 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.
Anonymous | TrustRadius Reviewer

Vertica

  • The ROI on fast, interactive querying is very high.
  • Table size limitations force us to use other tools, slowing things down.
  • Relatively expensive pricing forces us to regularly upgrade our Vertica subscription and database. Each upgrade leads to a downtime of a few days.
Anonymous | TrustRadius Reviewer

Pricing Details

Oracle Hyperion

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Vertica

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

Oracle Hyperion
7.8
Vertica
7.5

Likelihood to Renew

Oracle Hyperion
5.0
Vertica

Support Rating

Oracle Hyperion
8.0
Vertica
7.5

Add comparison