show all objects and associated tables in an universe

[system]

Hi guys,
I have been asking a lot of question today sorry…

i have a small question…is there anyway i can have a list of all the objects and their associated class names and the database table and column name?
example:

universe: ODS

Object name | associated column | class name(optional)

order id | ODS.tab_1.ord_id | A
customer name | ODS.tab_1.cust name | A
Connection | ODS.tab_1.con_name | B

the output can be anything…an excel extract or any BO report.

I am using BO XI release 2

Thank you in advance

---

SpeedinDeath (BOB member since 2010-03-30)

[system]

In BOB Downloads there is a utility that documents universes.

Document a BO Universe in Excel

Author: André Lützkendorf Platform: Windows Version: GetSetUniverse 3.5.25 Code: VBA code within the uploaded xls file Author notes: 1. What can you do with the tool? Presentation of all universe objects and properties This includes general universe information (defined in parameters) all object properties object dependencies (lineage/ impact analysis) (which table will be used by which object, which objects will be used by which objects with @functions) contexts hierarchies joins inc…

---

tmcd (BOB member since 2005-10-02)

[system]

wonderful…absolutely wonderful…
thank you thanks a lot !!!

---

SpeedinDeath (BOB member since 2010-03-30)

[system]

Don’t thank me. Thank the author - André Lützkendorf.

I would highly recommend taking a half hour or so and browsing the various downloads made available by the gracious folks of the BOB forum. It is time well spent.

---

tmcd (BOB member since 2005-10-02)