Overall Satisfaction with IBM Cognos
When I was using IBM Cognos, it was the primary reporting solution for the enterprise, both at HIll-Rom and at Ethicon Endo-Surgery. It was the official tool for users to consume information from the enterprise data warehouse. I've also used it as a third-party integrator.
- The strength of Cognos has always been their data modeling layer. Both in Framework Manager and in Transformer, very sophisticated data models could be applied to any database-housed source data.
- Very easy to implement security on data access.
- The ability to control what queries/operations were handled by Cognos, versus those that would be passed off to the database.
- Having both the Framework models and the report studio specs be xml documents made third-party integration quite nice.
- Printing reports is very easy.
- Drilling up/down/through very easy to do.
- The data models aren't available to anything besides Cognos Reports. So if a custom application or an analysis tool from another vendor wants to access the data, they can't take advantage of any of the modeling work done in Framework Manager, they have to do it all over again. This is a travesty. The modeling should be presented as a federated database layer that any application can take advantage of.
- The data modeling environment doesn't lend itself to good development practices: You can't tell easily what the impact will be to making a change (Will this break report? cubes?), there's no built-in version control, only one person can work on a model at a single time, large files become unwieldy.
- The general level of graphics is behind other vendors. The maps in particular are terrible.
- The tool is expensive, and locks you in.
- Working with a performant, dimensional source like a cube requires learning and using archaic mdx, and is very difficult to do in Report Studio.
I didn't select IBM Cognos, I only used it in situations where it had already been selected. Cognos was better for a long time than most of the traditional BI vendors. And their modeling is still second to none.
IBM Cognos Analytics Feature Ratings
Using IBM Cognos
300 - All of them
15 - DBA, Server Admin, Data Modelers,Studio Gurus
- Getting data from the EDW
- It's a reporting tool. It doesn't have a lot of innovation. Connect people to data. That's it!
IBM Cognos Support
Pros | Cons |
---|---|
Good followup Knowledgeable team Problems get solved Quick Initial Response | Slow Resolution Not kept informed Difficult to get immediate help |
Using IBM Cognos
Pros | Cons |
---|---|
Like to use Relatively simple Well integrated Feel confident using | Difficult to use Requires technical support Slow to learn Cumbersome Lots to learn |
- Modeling dimensional structures in Transformer.
- Creating security and data models in Framework Manager
- Scheduling reports
- Impact analysis
- Report studio reports against a dimensional source like a cube.
- Any type of mapping report.