Overall Satisfaction with IBM Cognos
- Framework Manager (metadata modeling tool) is a pretty flexible tool for any complex data modeling.
- With use of Report Studio you can handle any business logic for reporting.
- Event studio is used for event based scheduling.
- Business Insight advanced is used for ad-hoc reporting.
- Query studio out-of-the-box is a bit primitive. It is used for ad-hoc reporting, but if something is changed in Query Studio by and end user, it's not possible to see what exactly was changed without going into Report Studio. This is problematic as it means that end users need licenses for Report Studio which is not feasible.
- Metric studio we have not used at all, and don't know exact purpose of it.
- Single version of truth. We have centralized all reporting to one tool.
Using IBM Cognos
300 - Energy Marketing, C-store, Terminal & Refining.
- Market Basket Analysis.
- Email canned reports.
- Single version of truth.
Evaluating Cognos and Competitors
Six years back we switched from Microstrategy to Cognos.
Cognos Implementation
- Implemented in-house
Cognos Training
- Online training
- In-person training
- Self-taught
IBM documents are good to learn all by yourself.
Configuring Cognos
Cognos Support
No - In last 6 years, we have used limited support.
Using Cognos
Cognos Reliability
Integrating Cognos
- Various .Net based applications.
- SAP ECC 6.0.
Integration with .NET applications works well. Integration with the transaction SAP ERP systems also works pretty well, but integration with the SAP Business Warehouse is a different matter. We tried twice to integrate with the BW and failed each time. We have now abandoned that effort as it was a waste of time and money.
- Amazon cloud.
Relationship with IBM
We negotiated CPU based licensing instead of core based.