BO to Cognos

[anuramu]

Hi,
I am trying to estimate the effort involved to convert BO universes/ reports to Cognos. Is there a tool to convert BO universes automatically to Cognos Projects/catalogs?

Would I be right in assuming that the sql of a BO report would be the catalog?

Cheers,
Anuradha

 

[DoubleD]

I am not aware of any tool to do that conversion. The structure behind BO vs Cognos is very different. Cognos Catalogs are built on a proprietary structure so the BO SQL probably would not convert.
Unfortunately, I believe you're looking at a manual conversion.

Pain is stress leaving the body.

DoubleD

 

[anuramu]

Can Framework Manager be used for conversion of universes to 'first cut' Projects that can be modified to take care of contexts?
Also what would be approximate estimate (in time) for converting say about 15 tables, star schema with 3 to 4 contexts to a catalog or project. Iam not sure whether it would take a day or a week.

 

[DoubleD]

That all depends on how much time you plan to spend setting up the metadata.
A base catalog against your suggested objects should only take a day to generate in Framework Manager. But if you build everything with standards and properly document all of your objects, you're looking at more like a week.
Also depends on whether you have a database model you can import, such as ERWIN.
There are a lot of unknown factors here. I've never attempted converting from BO to Cognos so I'm only able to give you my best guesses.

Pain is stress leaving the body.

DoubleD