What is the Query Builder SQL to get all reports and their associated universes? Thanks. (BOE 4.2 SP3)
frank35 
(BOB member since 2005-08-25)
Don’t do it like this.
See if the repository documentor can help (SAP BI Repository Documentor - SAP BI BusObj 4)
Damocles (BOB member since 2006-10-05)
Looks good but I need to do it without downloading software onto company systems!
frank35 (BOB member since 2005-08-25)
It’s excel.
Surely you have excel?
Damocles (BOB member since 2006-10-05)
Ok. I have it open now. How do I specify which environment to extract from?
frank35 (BOB member since 2005-08-25)
No auditor installed?
The activity universe can be used for this.
It has to be noted it only “works” if the report has actually been run.
Mak 1 (BOB member since 2005-01-06)
BI4.2 SP03 includes a new data access driver for performing CMS queries via WebI.
Joe
joepeters 
(BOB member since 2002-08-29)
Oh…very nice.
Thanks for sharing Joe 
Mak 1 (BOB member since 2005-01-06)
Does running the Repository Documentor download take up space on the BO Server? (log files etc).
frank35 (BOB member since 2005-08-25)