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

Bhaskar gravatar image

333 16 17 20

(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

Tom Redd gravatar image

Tom Redd
57 4 4 4

(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

Slick84 gravatar image

1.3k 75 102 142

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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: 5697 times

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