List of Objects and corresponding tables in Universe

[system]

Hi All,

I am using BO 6.1.3 and I have a Universe with around 70 tables and 350 objects.I don't have access to repository and it is in different place.

I was asked by the client to provide them a excel sheet with object name,class name,table name and column name with conditions in the object.

Is there any way to do this?

Thanks in Advance,
Srinath

---

srinath2003 (BOB member since 2005-01-06)

[system]

Hi Srinath,

You can query to universe tables to get list off all objects, tables etc.

If not check this post. This is for mass update of universe objects. You can use this to just pull the objects and nto to update. You have two macros in the worksheet. So you can just use the first macro I guess its something like “Get…” and you can modify this macro to get the conditions and table names also. I used and modified once to pull objects,descriptions and conditions.

120×120 10.4 KB

Update 23-Oct-2009: Another version that can change CLASS names and descriptions can be found here later in this thread. Author: Dwayne Hoffpauir, EDS Corporation Further discussion on this utility should take place in this topic. Author Notes: Option Explicit 'require variables to be declared before being used Dim DesignerApp As Designer.Application Dim Univ As Designer.Universe Dim Wksht As Excel.Worksheet Sub GetInfo() Set DesignerApp = New Designer.Application …

---

Raja Saripalli (BOB member since 2005-12-14)

[system]

The version you are using dont you have a save as pdf functionality?? If you do I guess you can give your boss the pdf file with the info he asked for. Else the only other way is what raj suggested.

---

BOB_DW (BOB member since 2004-08-26)

[system]

@sraj

If not check this post. This is for mass update of universe objects. You can use this to just pull the objects and nto to update. You have two macros in the worksheet. So you can just use the first macro I guess its something like “Get…” and you can modify this macro to get the conditions and table names also. I used and modified once to pull objects,descriptions and conditions.

Mass update to object names / descriptions

Actually, I think this utility might be more useful.

---

Dwayne Hoffpauir (BOB member since 2002-09-19)