We’re using the Document a Universe Utility and loading the xls into SQL Server:
https://bobj-board.org/t/59650
We also load all metadata from ER Studio (business/techinical metadata). We also load all Informatica mappings.
We have a utility that dumps the CMS repository to a flat file using the BOESDK (this is handy)
The last piece of puzzle is getting all the universe objects that each report is using. This is what I’m working on now.
Metadata integrator (CMS Collector in DI, Metadata Manager) does much of this but we don’t own so is not an option. I’m opening each Webi doc on the server, what I need are these fields:
REPORT_CUID|UNV|QUERYNAME|CLASS|OBJECT
The resultSet object has the fields but not the classes. The other info can be had from the infoObject in CMS. Our object names are not unique, how do i get the class name? there is an ITreeNodes object, I was going to investigate that but haven’t got the time. Any help appreciated!
Regards,
Mark Stockwell, BOCP
see me in Dallas at GBN
http://bocaew.prod.web.sba.com/displaymod/detailevent.cfm?conference_id=2&event_id=306
mstockwell 
(BOB member since 2006-10-23)