text listing of relationships

[ry1633]

This might be an easy question and I haven't found much info in the support docs or IBM's knowledge base, and so it might not even be possible. 

In Framework Manager 10.2.1, is` there a way to generate a text listing of all the joins and relationships in your model?  I ask because I'm working on a project that is starting to get large, and it's quickly becoming difficult to get a screenshot at 100% or 75% of my model diagram.  I can do a reasonable one by leaving some stuff out of the Diagram settings, but it was getting difficult and the project is starting to get a bit large in terms of objects and query subjects in my model.

[Lynn]

This might be an easy question and I haven't found much info in the support docs or IBM's knowledge base, and so it might not even be possible. 

In Framework Manager 10.2.1, is` there a way to generate a text listing of all the joins and relationships in your model?  I ask because I'm working on a project that is starting to get large, and it's quickly becoming difficult to get a screenshot at 100% or 75% of my model diagram.  I can do a reasonable one by leaving some stuff out of the Diagram settings, but it was getting difficult and the project is starting to get a bit large in terms of objects and query subjects in my model.

You can run a model report and then save the XML and then open it in Excel. It is pretty ugly and very wide but might give you some other options to consider. I generally rip out columns and rows that I don't care about to end up with something reasonable. If memory serves, the relationships are listed toward the end of the report.

[ry1633]

what would be a good example of a third party tool to look for?  I tried the XML report, and it didn't give me the relationships.  Maybe I just need to look harder.

[Lynn]

what would be a good example of a third party tool to look for?  I tried the XML report, and it didn't give me the relationships.  Maybe I just need to look harder.

Our kind Cognoise hosts, Avnet BSP, have a product called MetaManager. There is an animated link for it at the top right corner of the site.

If you want to try harder with the model report, make sure you click on the namespace that contains your database view where the relationships reside and then run the model report. If you scroll all the way to the bottom of the HTML model report you should see them there.

When I run the model report as XML and then open in Excel after saving, I find the relationships at the very bottom of the report way (way, way, way) over to the right side of the spreadsheet. It tends to string out all the different elements across different columns so the resulting spreadsheet is very wide. You should be able to do a search in the spreadsheet for one of your relationship names to help find it.

As an example, below is what I see for one of my joins between a fact table and a date dimension. There are eight columns required to display everything. I think I might have ripped out some other columns to get just the basics.

Code Select Expand


UTILISATION <--> CALENDAR_DATE [Utilisation Physical].[UTILISATION].[CALENDAR_DATE]        [Utilisation Physical].[UTILISATION] one many [Utilisation Physical].[CALENDAR_DATE] one one
UTILISATION <--> CALENDAR_DATE = [Utilisation Physical].[CALENDAR_DATE].[CALENDAR_DATE]    [Utilisation Physical].[UTILISATION] one many [Utilisation Physical].[CALENDAR_DATE] one one



[ry1633]

Probably should have refined my question some and I apologize about that.  Is there a way to show the cardinality of the relationships in the report?  that's what after too.

[Lynn]

Probably should have refined my question some and I apologize about that.  Is there a way to show the cardinality of the relationships in the report?  that's what after too.

The cardinality is shown in the model report. You can scroll to the right in the snippet I posted previously to see the words that identify cardinality.

[ry1633]

Got it figured out.  Thanks Lynn - this was a big help.  :)  -ryan