Finding specific tables being used is repository universes

[system]

Hello ,

Is there any way to find specific tables that are being used in any one of The universes in the repository ?
i do not want to search each universe seperatly but all of them at once.

Thanks.

---

babutang (BOB member since 2006-01-27)

[system]

Hi

In my Opinion, the Repository’s Universe related tables contains information about the Universe, not about the table used on the Universe.

Regards

Siva.M

---

looksmee (BOB member since 2006-02-08)

[system]

@looksmee

Hi

In my Opinion, the Repository’s Universe related tables contains information about the Universe, not about the table used on the Universe.

Regards

Siva.M

Thanks ,

Any one else have any idea ?

---

babutang (BOB member since 2006-01-27)

[system]

A glance into BOB downloads would have fetched you lots of utilities for your requirement
found one here

Macro to fetch number of tables and columns in Universe

Author: nithya_raj Author notes: Discussion: NA Platform: BO XI R2 Version: v 1.0 Code: Dim des_app As Designer.Application Dim des_unv As Designer.Universe Dim des_class As Designer.Class Dim des_obj As Designer.Object Dim des_table As Designer.Table Dim des_column As Designer.Column Dim i As Integer Dim j As Integer Dim k As Integer Dim x As Integer Dim RowCount As Integer Dim univ_name As Designer.Universe Dim Wkst As Excel.Worksheet Sub main() 'Logon and Open Universe Set des_app…

.

---

haider (BOB member since 2005-07-18)