Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cognos to SSRS 2008 Expand / Collapse
Author
Message
Posted Wednesday, October 30, 2013 9:03 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:52 AM
Points: 2,031, Visits: 2,535
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
Post #1509826
Posted Thursday, October 31, 2013 6:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 22, 2014 5:52 PM
Points: 6, Visits: 98
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.
Post #1510142
Posted Thursday, October 31, 2013 6:26 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 13,570, Visits: 11,383
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1510144
Posted Sunday, November 3, 2013 11:40 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:52 AM
Points: 2,031, Visits: 2,535
Thanks.

any other inputs?


karthik
Post #1510974
Posted Tuesday, November 5, 2013 7:40 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, November 14, 2014 8:26 AM
Points: 2,894, Visits: 3,278
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 2014, 2012, 2008 R2, 2008 and 2005. 18 October 2014: now over 31,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1511492
Posted Wednesday, November 6, 2013 12:10 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 10:05 AM
Points: 1,556, Visits: 490
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 Luck:)
Post #1511970
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse