Cognos Impromptu to SSRS

  • Hi,

    I want to migrate reports from the Impromptu(cognos) tool to SSRS reports. Please suggest me some useful material on the same. Urgent!!

    Thanks

  • Haven't seen any specific Imp to RS converters. I owuld recommend reviewing the Imp Catalog in detail, determine how close it is to the actual DB schema. You'll want to know how many computed fields were added to the catalog, as you'll need to replicate these for each/every query you run in RS, unless they are generic enough to add to views in the source DB.

    *Theoretically*, if most of the queries are straightforward in Imp, you could take the SQL and simply put that in to a dataset in RS and then play with the display of the data on the report.

    Steve.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply