Get List of All Objects in Particular Universe

[Former Member]

Hi,

Is there a way to extract/export the "names" of all objects in a universe to Excel or a text file so that I can then sort and analyse all the objects.

Thanks

[thomas_wagenbichler]

Hi Marc,

if you have access to the BusinessObjects repository database, you can query the appropriate tables.

1.) Find the ID of the universe you want use:

select uni_longname, universe_id from <bo_schema>.unv_universe

2.) List the objects of that universe:

select obj_name from <bo_schema>.unv_object where universe_id = <id_value> [order by obj_name]

Use your favorite method to capture the query result in a file.

Best regards,

Thomas

[Former Member]

**Hi Marc,**

**u cn refer to the answer below.....**

*i don't have idea on excel/txt file but there is one more option that is u can save to pdf*

*goto designer and open the univers*

*use pull-down menu to set tool--options*

*in options window select print/pdf tab*

*there u cn select check box what u want to save to pdf*

press ok

then File--SaveAs

select pdf format to save file

**points are welcome if the above info is useful to u......**

[Former Member]

Marc,

such an Excel program is provided courtesy of Dwayne Hoffpauir and posted to the "BOBJ" forum, available vis this link: http://www.forumtopics.com/busobj/viewtopic.php?t=59650&postdays=0&postorder=asc&start=0

Keep in mind that you if you go this route it requires that Designer and Excel are resident on the server or workstation when this is ran.

Hope this helps you out.

Thanks,

John