Does anyone know how to create a report that identifies the universe, the universe tables, and database connection it uses? Is there also a way to identify which objects are being used in what reports.
I am using XIR2 Sp2 on windows server with an Oracle Repository.
mcliffordgoo 
(BOB member since 2003-02-13)
Hi,
Please have a look at the following utilities from BOB download section:
document universe connection utility
document a universe utility
list of objects in the reports utility
Marek Chladny 
(BOB member since 2003-11-27)
This is perfect!!! My DBA’s will love me and my work will be minimal. Thanks so much. 
mcliffordgoo (BOB member since 2003-02-13)
Is there anything that associates the universe and connection together? The excel sheets list the connections and parms and the universe excel sheets list the objects, class, conditions, etc but does not associate the the universe to the connection.
At the end of the day the DBA want a way to identify which reports will be effected if they conduct maintenance on a databse.
mcliffordgoo (BOB member since 2003-02-13)
It looks and works great! But am I right that it only works for Desktop Intelligence reports? I would like to use this tool for WebI reports. I tried myself to change in the VB script ‘.rep’ to '.wid’, but this doesn’t seem enough. When I refresh the document, it doesn’t seem to finish.
Any suggestions? Thanks!
AndreasJ 
(BOB member since 2006-08-24)