cognos vs ssrs, side by side comparision

Can we always use SSRS instead of cognos reports?
if not then why?
I have never worked on cognos just recently started googling around to see why congnos is needed sometime for reporting instead of SSRS

more ▼

asked Apr 27, 2010 at 11:01 AM in Default

avatar image

333 17 19 24

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

The bank where I was employed used SQL Server 2005 and SSRS as well as Cognos. Cognos was used more in the Data Warehouse environment because it was churning millions and millions of data or terabytes worth of data and the marketing team needed real time results as quick as possible.

We did a benchmark test and Cognos could churn out more data via reporting than SSRS could. We basically used the best of both breeds.

more ▼

answered Apr 27, 2010 at 09:54 PM

avatar image

Tom Redd
57 4 6 6

(comments are locked)
10|1200 characters needed characters left

My last company I worked for migrated from SSRS to Cognos. Even though SSRS was capable of most specific situations, there were certain "Advanced" BI analytics that Cognos was able to do. I'm not exactly sure what though.

However, my manager was always against this move as he wanted to strictly to keep this a Microsoft workshop. Not sure if it was a carefully thought-out technical move or a dumb executive cost-saving move.

more ▼

answered Apr 27, 2010 at 12:28 PM

avatar image

1.3k 75 104 147

thanks, I googled around, it says almost similar stuff like cognos advanced ad hoc reports and better BI functanalities. So far SSRS and MDX has not failed me for requirements. will look little further at Cognos features.

Apr 27, 2010 at 12:49 PM Bhaskar
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 27, 2010 at 11:01 AM

Seen: 7331 times

Last Updated: Apr 27, 2010 at 11:19 AM

Copyright 2016 Redgate Software. Privacy Policy