SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Cognos to SSRS 2008


Cognos to SSRS 2008

Author
Message
karthik M
karthik M
Hall of Fame
Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)

Group: General Forum Members
Points: 3033 Visits: 2584
All,

we are going to migrate 41 Cognos report to SSRS. This project is in initial stage now.

As part of this migration, I have done the below analysis on COGNOS side for all the reports.


1) No of SQL Call/Procedure Call
2) No of Expressions
3) No of Filters
4) Chart Type
5) Input Parameters
6) Execution Time
7) Header / Font Size / Colors / Note

is there any anlysis needs to be done before starting the project?
what are all the constraints will occur during this migration?
is there any functionality/logic which need more attention in SSRS?
is there any functionality/logic which is easy in COGNOS but not in SSRS?
where I have to focus on SSRS side for completing the report without any issue?

Note: I am going to develop SSRS report first time in real time.

Inputs are welcome!

karthik
Carol Mayers
Carol Mayers
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 116
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlreportingservices is a very useful Website for SSRS questions.

WROX - Professional Microsoft SQL Cerver 2008 Reporting Services book is a very useful reference and how to book.
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28095 Visits: 13268
Cognos handles parameters way better than SSRS.
In Cognos you have prompt pages, while in SSRS you have almost no control over how parameters are prompted to the end users.

SSRS is - in my opinion - sometimes a bit easier on the layout.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
karthik M
karthik M
Hall of Fame
Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)

Group: General Forum Members
Points: 3033 Visits: 2584
Thanks.

any other inputs?

karthik
EdVassie
EdVassie
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 5998 Visits: 3866
Consider packaging your SQL queries in stored procedures, and not imbed the query in the report. (There are about as many people who would fight to the death to support this viewpoint as there are who would fight to the death supporting imbedding SQL in the report.)

If you do package the SQL in a stored procedure, you can test the SQL completely independently of the report. I have often found with complex reports that have imbedded SQL, it can be difficult to troubleshoot if the problem is in the SQL or the report definition.

You can get the SQL that is used for the report out of Cognos.

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017: now over 40,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Quote: When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist. - Archbishop Hélder Câmara
Chris Hurlbut
Chris Hurlbut
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1852 Visits: 540
You also might want to check the schedules in Cognos.
As someone above stated, ensure you know where the data is coming from.
Are there any security settings you need to be concerned with?

Hopefully you can do in parallel environments to validate the data on the new report.

Good LuckSmile
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search