Likelihood to Recommend 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.
Read full review Generation of templated reports is the strong suit of SAP Crystal. Allows users to change formats in templates bases on requirement with minimal effort. Automated report delivery requires the user to be aware of sql which cannot be expected from all users. Should support more document export formats and improve the UI for SAP B1 Users
Read full review Pros 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 Interim Director of Business Intelligence and Finance Systems
Read full review Crystal Reports allows us to create a consistent template for all of our reports. Crystal Reports and Server allows us to house a repository for all of our reports to make them easy to find and update when necessary. Crystal Reports can connect to a wide variety of data sources. Crystal Reports can be a little daunting when first implementing. There are a lot of nuances in learning how to truly master this software and it can be frustrating at times. Read full review Cons 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 The export of reports to Excel is very cumbersome and the results are difficult to format. The design of reports and the graphical features (e.g. charts) feel quite rigid. The learning curve for a non-programmer is incredibly steep, making Crystal a specialty tool. Read full review Likelihood to Renew 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 We have been using this product for so many years and it has truly become a cornerstone to our business processes when it comes to developing and distributing information via reports. We currently have over 500 reports developed to date over about 30 systems and that will continue to grow as user needs change.
Read full review Usability Crystal is very robust, but not always easy to use. It create wonderful looking reports, and so deserves a high rating. However, I have to take a couple of points off for the simple fact that I cannot hand it to a user and expect them to be able to do development with it.
Greg Goss SQL Database and Business Intelligence Manager
Read full review Support Rating 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.
Read full review The support community can be difficult to navigate. I've also run into issues with my login. The SAP system has a bizarre mechanism for validating users that requires users to have what is called an S-ID. A basic ID may not give you access to all the features in the portal. The limitation may include not being able to perform a simple task like downloading patches and updates. This isn't a big deal for single user license but for teams it can be a pain.
Read full review In-Person Training Trainer was patient and thorough in going through the basics and willing to answer questions by email after the initial training
Read full review Implementation Rating Just like any other implementation: When designing the differing reports, get end users' input, make sure to design the reports so that they display the information that the company requires, in the best and clearest way possible.
Test, test, test, revise when needed, and, particularly, do sufficient training so users are comfortable using Crystal Reports!
Read full review Alternatives Considered 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 Financial Planning Analyst- Student Assistant/ Consultant
Read full review Crystal reports is useful in case we want to import data from data base . We can write queries in it but
Google Charts require to be implemented in our application using code so crystal reports is better than
Google Charts .
Read full review Return on Investment 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. Read full review It is a decent buy for specific departments in terms of reporting capabilities but updates and cost (frequent) demands are higher with the benefits offered. So long as the requirements are not ever changing, with scheduling functionality, it's a handsome tool. Read full review ScreenShots