I have to come up with a business solution to develop BI reports. The requirements to be included are: HeatMaps, Scorecards, Querying, Adhoc Reports, Data Input, Threshold Changes, Export to Excel/ PDF ,Performance data, dashboard, metadata. Can you compare Cognos vs. Business Objects or fill me in on how each product would comply with those requirements?
While each BI vendor can demonstrate a laundry list of things they do, and marketing terms they use, to distinguish from the other, there is a lot of parity between these two leading BI products. I could distinguish them further, but although you provided a good list, I'd need to know more. Looking at this list quickly, I think you'd find either product can fulfill most of these requirements, except for HeatMaps – I'm not sure about that.
These decisions these days come down to broader issues as well as the technical ones. These issues include whether you'll go with best-of-breed vs. a single vendor, your already installed components, the local team you deal with and the deal itself.
One caution about Cognos is their architectures tend to be more "data mart" than "data warehouse" and their cube structures can tend to multiply and divide if you are not careful. The simplest approach, and one which I'd need to see evidence to stray from, is the relational approach.
And remember, it's going to be just as much about execution as it is selection. Don't allow hangovers about the selection cast a pall on executing the business strategy with the chosen tool.
Dig Deeper on Business intelligence software
Related Q&A from William McKnight
There are loads of business intelligence tools out there on the market today. Our business intelligence expert provides some valuable resources for ... Continue Reading
Find out when you should use a DBMS with your data warehouse, and learn about the future of data warehousing data management and current state of ... Continue Reading
Find out how Oracle’s acquisition of Sun may affect Oracle data warehouse strategy and what it means for users. Also, see what role packaged BI ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.