What users are saying about
196 Ratings
Top Rated
140 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
Top Rated
140 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.1 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

Amazon Redshift

If the number of connections is expected to be low, but the amounts of data are large or projected to grow it is a good solutions especially if there is previous exposure to PostgreSQL. Speaking of Postgres, Redshift is based on several versions old releases of PostgreSQL so the developers would not be able to take advantage of some of the newer SQL language features. The queries need some fine-tuning still, indexing is not provided, but playing with sorting keys becomes necessary. Lastly, there is no notion of the Primary Key in Redshift so the business must be prepared to explain why duplication occurred (must be vigilant for)
Arthur Zubarev | TrustRadius Reviewer

Feature Rating Comparison

BI Standard Reporting

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

Ad-hoc Reporting

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

Report Output and Scheduling

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

Data Discovery and Visualization

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

Access Control and Security

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

Mobile Capabilities

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

Budgeting, Planning, and Forecasting

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

Consolidation and Close

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

Financial Reporting and Compliance

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

Analytics

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

Integration

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

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

Amazon Redshift

  • Redshift is fully managed. Small teams do not have the resources to maintain a cluster. CloudWatch metrics are provided out-of-the-box, and it is easy to configure alarms.
  • Redshift's console allows you to easily inspect and manage queries, and manage the performance of the cluster.
  • Redshift is ubiquitous; many products (e.g., ETL services) integrate with it out-of-the-box.
  • Writing .csvs to S3 and querying them through Redshift Spectrum is convenient.
Gavin Hackeling | 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

Amazon Redshift

  • It could benefit from adding data integrity and programming tools common to other database management systems.
  • Amazon Redshift is based on PostgreSQL 8.0.2. That version of PostgreSQL was released in December 2006. While PostgreSQL was much improved since then, the new features were not implemented in Redshift. Many basic features are missing from it.
  • Primary keys can be declared but not enforced. Referential integrity (foreign keys) can be declared but not enforced. UNIQUE and CHECK constraints are not supported and cannot be declared.
  • IDENTITY can be declared on a column, and Redshift will put unique values into it. However: IDENTITY values in the newly inserted rows won’t be incremental or sequential. To implement a sequential number, you need to write your own custom code.
  • There are no stored procedures in Redshift. We are writing SQL script files, and then parsing and running them one statement at a time from a Python program. This also enabled us to implement execution-time error logging.
  • In SQL scripts, to check for the row count of affected rows, a complicated join query against some system tables or views has to be executed.
  • Data Control Language (DCL) does not exist. No statements like IF, WHILE, DO, RAISERROR, etc.
  • On performance of views… Views do not “pass-through” a query parameter which is a potential problem for performance.
  • When selecting against a view with the WHERE clause outside of the view, the inner query of the view will be executed first without consideration for the WHERE clause, and only then the WHERE clause will be applied.
  • Certain clauses of SQL work many times faster than other clauses. So be careful and test your statements for performance earlier rather than later, especially if working with a large data set.
  • There was a situation when DELETE FROM JOIN was unacceptably slow. Replacing JOIN with the USING clause made DELETE instantaneous.
Michael Romm | 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

Amazon Redshift

No score
No answers yet
No answers on this topic

Usability

Oracle Hyperion

No score
No answers yet
No answers on this topic

Amazon Redshift

Amazon Redshift 8.5
Based on 8 answers
Just very happy with the product, it fits our needs perfectly. Amazon pioneered the cloud and we have had a positive experience using RedShift. Really cool to be able to see your data housed and to be able to query and perform administrative tasks with ease.
Brendan McKenna | TrustRadius Reviewer

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

Amazon Redshift

Amazon Redshift 7.4
Based on 6 answers
The support was great and helped us in a timely fashion. We did use a lot of online forums as well, but the official documentation was an ongoing one, and it did take more time for us to look through it. We would have probably chosen a competitor product had it not been for the great support
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

Amazon Redshift

Than Vertica: Redshift is cheaper and AWS integrated (which was a plus because the whole company was on AWS).
Than BigQuery: Redshift has a standard SQL interface, though recently I heard good things about BigQuery and would try it out again.
Than Hive: Hive is great if you are in the PB+ range, but latencies tend to be much slower than Redshift and it is not suited for ad-hoc applications.
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

Amazon Redshift

  • Redshift has had a very positive impact on our business. It has been used to provide analytics on marketing campaigns to boost revenue.
  • Redshift is instrumental in our payment collection business processes. It powers everything from who gets called to who gets sent collection emails.
Seth Goldberg | TrustRadius Reviewer

Pricing Details

Oracle Hyperion

General

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

Amazon Redshift

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
Amazon Redshift
8.0

Likelihood to Renew

Oracle Hyperion
5.0
Amazon Redshift

Usability

Oracle Hyperion
Amazon Redshift
8.5

Support Rating

Oracle Hyperion
8.0
Amazon Redshift
7.4

Add comparison