I’m using Designer 6.5.1 with a large universe. I need to know the objects associated to a certain table but by right click the table and click “view associated objects” , nothing happened.
I have checked some objects and they do refer to the table I want to see…
Is there anyway I can get the associated objects quickly rather than check all the objects one by one?
If nothing else helps then you could try this utility that documents the universe. All information is written into an Excel sheet where you can find what you need more easily.
“view associated objects” won’t find objects where @Select() or @Aggregate_Aware() are being used in the select statement, which is why you’re getting no results.
The utility Marek suggested is going to be your quickest option.
I hit this issue when trying to delete a table from designer. The documenting spreadsheet didn’t reveal the issue although it reported an error when I ran it.
I fixed the issue by
making sure I had a backup of the universe!
delete the table from the universe and ignore the warning about dependent objects
run the integrity check
The integrity check parsed everything and highlighted the objects that I had undermined and I was able to fix them easily. The problems lay in two foreign keys that I had defined for index awareness - not sure if these should have been picked up by the documenting excel add-in?