BusinessObjects Board

How to get list of objects and column names

building semantic layer
#1

Hi Everyone,

I wanted to know if there is a way to get the list of objects and their source(table.column_name) from the universe.

Appreciate your help,
Thanks

nisha_18 (BOB member since 2004-08-10)

#2

Hi,

What BO version do you use?

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#3

You might find these utilities helpful:[list]Document a universe using Excel and the Designer SDK
Universe Documentation Generator[/list]

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

#4

I am using BO 6.5 version

Thanks

nisha_18 (BOB member since 2004-08-10)

#5

Thanks Dwayne…Excel untility helped me get what I was looking for…Appreciate all your help

Thanks

nisha_18 (BOB member since 2004-08-10)

#6

The alternative is the following SQL that you need to run against the BO repository tables:

SELECT c.uni_longname AS universe_name,
       b.obj_name AS object_name,
       d.tab_name AS table_name
  FROM unv_obj_tab a,
       unv_object b,
       unv_universe c,
       unv_table d
 WHERE a.object_id = b.object_id 
   AND a.universe_id = b.universe_id
   AND a.universe_id = c.universe_id
   AND a.universe_id = d.universe_id
   AND a.table_id = d.table_id

Add conditions for universe or object or table name(s) as you need.

Please note that this SQL displays all tables that are selected in the object’s properties -> tab Definition -> button Tables

Marek Chladny :slovakia: (BOB member since 2003-11-27)