[Solved] Project for migration from Impromptu Reports v6.0 to ReportNet

[srikalyan]

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.

[cognosfreelancer]

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

[sir_jeroen]

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.

[srikalyan]

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?

[sir_jeroen]

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).

[srikalyan]

Thanks a Zillion, ReportNet_Addict!!! Will trouble you again soon ;)

[sir_jeroen]

Oh.. didn't know you knew my current rate... I'll send you a bill :P

[srikalyan]

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!!!

[sir_jeroen]

What's your location? :D

[cognosfreelancer]

ReportNet Addict

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

NKT

[sir_jeroen]

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....

[srikalyan]

What's your location? :D

The most happening place on earth: Hyderabad, India. 8)

[sir_jeroen]

Ok.. send me a ticket and your rate and i'll see... Already got another offer so make it better :D