COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: srikalyan on 24 Oct 2005 01:19:27 PM

Title: [Solved] Project for migration from Impromptu Reports v6.0 to ReportNet
Post by: srikalyan on 24 Oct 2005 01:19:27 PM
Friends,
I have a project to migrate IMRs v6.0 to ReportNet. What technical specifications or requirements are needed to consider this? Do we have a tool to do this or do we need to recreate all the reports?

Any ideas!!?

Thanks in advance.
Title: Re: Project for migration from Impromptu Reports v6.0 to ReportNet
Post by: cognosfreelancer on 24 Oct 2005 02:50:26 PM
Hello

There are atleast two tools that I know of that can do this.

However a pre requisite is that you need to upgrade your reports from version 6 to version 7.3.

One tool is from Cognos and is a command line utility.

Another tool is from Envisn.

I worked on both and would recommend Envisn any time.

NKT
Title: Re: Project for migration from Impromptu Reports v6.0 to ReportNet
Post by: sir_jeroen on 24 Oct 2005 03:00:39 PM
I wouldn't recommend it (personal opinion) because you have to convert your "catalog" to a framework model, but you will have to check ALL relations for cardinality and not all used functions in your catalog are converted. We came up to a lot of problems and decided to do it all from scratch.
Title: Re: Project for migration from Impromptu Reports v6.0 to ReportNet
Post by: srikalyan on 24 Oct 2005 03:40:26 PM
Thanks cognosfreelancer & ReportNet Addict.

ReportNet Addict:
How much time do you think it'll take to re-create an impromptu report into ReportNet?

cognosfreelancer & ReportNet Addict:
What factors do you think should I consider to determine the time required for migrating an IMR to ReportNet?

Title: Re: Project for migration from Impromptu Reports v6.0 to ReportNet
Post by: sir_jeroen on 24 Oct 2005 03:57:18 PM
That depends all on how complex your reports are.Btw it's important to have good modeled frameworks with dimensions/hierarchies because these give better reliable results. And these dimensions/hierarchies are not implemented in a catalog and will therefore not be created. Thus you will have to do this by hand and remap your reports to these new query items.
I would also recommend you to take the course: "Metadata modelling part 2" by cognos. This is the best course you can take and will give you a better look on building packages.

Migrating reports is in my point of view a risky business because if the joins are incorrectly converted and don't have the proper cardinality you could get incorrect results, heavy load on you server.. etc, etc.... If you do it by building from scratch you have total control over your packages and report and you can better tune your reports. E.g. using dimensions/hierarchies gave us in some circumstances a significant performance boost (this could also be otherwise but then you know where to look :D).
Title: Re: Project for migration from Impromptu Reports v6.0 to ReportNet
Post by: srikalyan on 25 Oct 2005 08:26:20 AM
Thanks a Zillion, ReportNet_Addict!!! Will trouble you again soon ;)
Title: Re: Project for migration from Impromptu Reports v6.0 to ReportNet
Post by: sir_jeroen on 25 Oct 2005 08:28:48 AM
Oh.. didn't know you knew my current rate... I'll send you a bill :P
Title: Re: Project for migration from Impromptu Reports v6.0 to ReportNet
Post by: srikalyan on 25 Oct 2005 08:53:08 AM
Quote from: ReportNet Addict on 25 Oct 2005 08:28:48 AM
Oh.. didn't know you knew my current rate... I'll send you a bill :P

:) Sure Sir, If you think you have the time to work on our project maybe as an architect!!!
Title: Re: [Solved] Project for migration from Impromptu Reports v6.0 to ReportNet
Post by: sir_jeroen on 25 Oct 2005 10:05:24 AM
What's your location? :D
Title: Re: [Solved] Project for migration from Impromptu Reports v6.0 to ReportNet
Post by: cognosfreelancer on 25 Oct 2005 10:10:44 AM
ReportNet Addict

What tool did you use for your migration before you decided to rebuild from scratch.

NKT
Title: Re: [Solved] Project for migration from Impromptu Reports v6.0 to ReportNet
Post by: sir_jeroen on 25 Oct 2005 10:14:07 AM
I'm a ReportNet user from the first hour... So we used the application provided my Cognos. And we stopped using it very quick... It's only usable for small catalog conversions....
Title: Re: [Solved] Project for migration from Impromptu Reports v6.0 to ReportNet
Post by: srikalyan on 25 Oct 2005 10:15:36 AM
Quote from: ReportNet Addict on 25 Oct 2005 10:05:24 AM
What's your location? :D
The most happening place on earth: Hyderabad, India. 8)
Title: Re: [Solved] Project for migration from Impromptu Reports v6.0 to ReportNet
Post by: sir_jeroen on 25 Oct 2005 10:16:51 AM
Ok.. send me a ticket and your rate and i'll see... Already got another offer so make it better :D