Analytic Solver vs. OpenText Magellan vs. SAP Crystal

Based on my limited experience and use, and therefore limited global knowledge of the software, I would recommend it especially if the data that will be used as inputs to the model has previously worked on a spreadsheet such as Excel. I would also recommend it to analyze problems of medium and small size. Given the experience I have had when I have used it with large problems, there have been noticeable decreases in the speed of response (which are not associated with the size of the system of equations involved in the calculation). Excellent for processing linear programming models.

Incentivized

If you do not have a large budget and are a large organization, I would steer clear of Actuate. If you are looking to do very complex washboarding, I would not use them. Your developers have to be very skilled to work with this. Plan to bring in consultants if necessary to help your process. Adhoc reporting is weak. If your pricing is user based and you expand, this could be very expensive.

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

Incentivized

• Easy to use and learn.
• Strong optimization platform for business and supply chain problems which can be modeled in Excel
• It can handle multiple objectives and more than 8000 decision variables in a problem.
• Lots of tutorial and examples are available to solve the problem

Incentivized

• The report outputs can vary across different types such as HTML, PDF, and Excel
• Their open source offering is very sufficient
• There are great boards and blogs for developers and engineers to expand and use their features.
• The people from the company that I've worked with are professional and courteous.

Incentivized

• 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.

Incentivized

• On the few occasions when I have used it to deal with problems of optimization of relatively large parameters (with a large number of restrictions and decision variables), the program has been slower, not substantially but slower, than programs such as the WinQsb, even when the latter runs on 32-bit machines and not 64. That has caught my attention, even though it is not a real problem for the uses I give to the program.
• Given my partial function as a university professor, it has been much more effective and practical to use other software, due to the limited options that the educational license associated with the software has.

Incentivized

• The documentation on all the available features, but most importantly on the scripting side, can be improved
• The standard look & feel of some basic options, like parameter selection or sorting and filtering, looks dated and can't be customized
• The server portal needs to provide better tools
• More integration is needed with other OpenText products

Incentivized

• 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.

Incentivized

I am no longer working for the company that was using Actuate but I believe they would continue to use it because the stitching costs would be to high. It would require a complete rewrite of the reports and the never version of Actuate (BIRT) even required an almost complete report rewrite

Incentivized

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.

It is quite intuitive to use. It is fit specifically for doing sentiment, emotion, and intention analysis as well as text classification and text summarization. I would have given 10 if it is fit for the purpose of doing image processing and analysis as well. There is a huge market to analyze video and image data.

Incentivized

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.

Incentivized

Always there on the front and backend for us and the client.

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.

Incentivized

Trainer was patient and thorough in going through the basics and willing to answer questions by email after the initial training

Incentivized

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!

Incentivized

We believe in building the models in Excel. A limitation with Excel is that Excel Solver can not take more than 200 decision variables with multiple constraints. It is cheap in terms of license and maintenance fees against other softwares which are available in the market.

Incentivized

It is vastly superior to these in many ways, for complex reporting it is a much more sophisticated solution. Visualizations are very good. Javascript extensibility is very powerful, others don't support this or as well. Pentaho and MS are both OLAP oriented. Pentaho is moving more toward big data, which was not our primary focus. Others are stuck in the Crystal Reports Band metaphor.

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.

Incentivized

• - It has allowed finding ways to optimize (minimizing costs or times) the field processes involved in various projects.
• It has even allowed, in specific cases where it was used for that purpose, to optimize the allocation of resources (people) to work in different jobs that present weekly variations of the activity that these people must perform.
• It has allowed the sensitivity analysis of projects to changes in the decision variables related to them, which, and in very dynamic and changing environments, resulted in substantial decreases in money losses.

Incentivized

• Actuate can handle 50 to 60 sub reports inside a report very well.
• Dynamically creating the datasource, chart, graph, reports are the main advantages. We can do any level of drilling, and can create a performance matrix dashboard efficiently.

• 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.

Incentivized