Powerful Report Studio and Event Studio: We have stringent requirements for the reports that go to investors. Report Studio helps us to deliver pixel-perfect reports in both HTML and PDF formats. Event studio is such a powerful tool: We have over 400+ reports going out every day based on different conditions; a few are periodic, a few are based on availability of data, etc. Without Event Studio, it would be a nightmare to maintain these huge jobs.
Room for Improvement:
Even though I identified Event Studio as one of the most valuable features, it still has room for improvement. Sometimes events get stuck; we need to restart Cognos services and do clean up in order to clear the queue. Error messages are not that straightforward.
The other area that needs improvement is Cognos Workspace. When we add multiple reports to the workspace, the performance is not up to the mark.
Another area of improvement is ‘interactivity’. Cognos is not even comparable from the interactivity perspective with other reporting tools such as Tableau.
Use of Solution:
I have used it for over 7+ years.
I have not encountered any stability issues.
I have not encountered any scalability issues. Cognos is very scalable. We could have a distributed installation (which we are already using) with multiple content managers and application tier components; we have never faced scalability issues.
I would say technical support is good, not great. We have contacted support for a number of issues. The main thing tech support needed was to replicate the issue at their end, which is not always possible. We still have issues that tech support is unable to address.
We were using Microsoft reporting services as our reporting solution.
Initial setup was quite complex. We started with a single-server installation, and faced performance issues; then, we tried a distributed installation. A distributed installation is quite complex, especially when the requirements are high, such as AD integration, load balancer support, enabling single sign on, etc.
Cost and Licensing Advice:
It is a very good product. I feel the price is OK, as it is not just a tool but it is a reporting platform.
Other Solutions Considered:
Before choosing this product, we did not evaluate other options. However, we did evaluate a few others recently for some other requirements. We figured out that MicroStrategy is also at par (or even on a bit higher side in some features), but considering the tradeoff between the features, price and effort to migrate, we felt it is better to go with Cognos.
This is a best-in-class reporting platform. But keeping in mind the high price of this tool, it is better to evaluate it before going for it. You might not need all the features provided by this tool, in which case you end up paying more. Also, it might not be suitable for small firms.
Disclosure: I am a real user, and this review is based on my own experience and opinions.