Can you export packaging information (ERD or other data model) from Cognos 8.3?

views:

479

answers:

+1 Q:

Can you export packaging information (ERD or other data model) from Cognos 8.3?

Hey,

I was wondering if there's a way to export package information from Cognos 8 from a regular user level or from the framework level.

For instance, I want the field names that cognos is pointing to on the database, i want the datatype, the description cognos uses when you right click a data element, etc..

Any suggestions?

+1 A:

The answer appears to be yes, to anything that supports CWM (the Common Warehouse Model) but as for how...

One suggestion: ask IBM.

MarkusQ 2009-03-18 17:51:53

haha.. i might as well look in the mirror for 412 days

CheeseConQueso 2009-03-18 17:56:29

Yeah, there's that. Any chance of getting it from the other end (e.g. database logs)? Though if you're using Cognos you're probably in an environment where it takes three weeks to find out how to contact the person responsible for managing the people who make sure there are towels in the bathroom.

MarkusQ 2009-03-18 18:28:34

I actually work with the dba. I'm a programmer, but don't have access rights yet because of licensing issues. We just started using it this week and I'm in training. You can't search for a table.field name, cant see any ERDs, etc... Me and another person are manually logging paths in excel YAY!

CheeseConQueso 2009-03-18 18:33:14

I feel your pain. Or maybe I'm just having flashbacks. Sad to say, you're probably doing it the most efficient way. I'm assuming, of course, you've asked the dba for the design docs/schema? Which brings up an interesting question: where do those docs go to?

MarkusQ 2009-03-18 19:00:57

From what i understand, you can export content out of the framework manager (regular users do not have access to this). This might have to be my route, but I'd rather find a way to do it at the user level

CheeseConQueso 2009-03-18 19:19:08

+1 A:

(Unfortunately I'm not at my work computer right now) but Cognos saves everything in .xml files. I have an xml pretty printer that I use on model.xml before and after edits, so that I can use windiff to see what exactly changes in the model. I have also used an xml editor on model.xml on several occasions for global search and replace.

Having said that, I'm not sure how much of the database schema you can infer directly from model.xml, but I suspect if you had a script that could read and walk model.xml, and connect to the database to describe the objects, you could get what you need.

2009-04-26 23:32:17

+1 A:

hi,

it appears that Powerdesigner 15 imports from xmi models.

regards Mark

mark vogt 2010-04-07 11:52:34

ansaurus

tags:

views:

answers:

Can you export packaging information (ERD or other data model) from Cognos 8.3?

related questions