I am using webi XI r2, how can I extract the list of all reports pointing to a particular universe?
sliver 
(BOB member since 2008-02-14)
You might have to use your custom JSP or .NET or VBA code to extract this information from the repository. In earlier versions, this was possible by querying the BO repository consisting of database tables.
I am not sure about Query Builder…
BO_Chief 
(BOB member since 2004-06-06)
In your query builder panel you can write this select
(Select SI_WEBI from CI_APPOBJECTS where SI_KIND=‘Universe’ and SI_NAME=‘xxx’ )
xxx is your universe name , this query extract list of reports id , which use that univers , if you want get reports name use this query
SELECT SI_ID, SI_NAME FROM CI_INFOOBJECTS WHERE SI_KIND = ‘WebI’ and SI_ID in
si_webi from above query
Zara 
(BOB member since 2007-02-07)
Zara,
What connection would you use for this particular query?
jcaparula (BOB member since 2002-08-15)
There is no connection (like what universes use) needed to run these queries. As long as your XI system is up and running, you can access Query Builder by visiting this address in your browser:
//:/businessobjects/enterprise115/adminlaunch/query/logonform.jsp
Be sure to log in as a user with necessary rights such as the Administrator.
BoB LoblaW (BOB member since 2007-10-23)
Hi,
In Query Builder I am trying to club these two queries into a single query but not able to do so, has any one done that ?
Thanks in Advance,
Vinod
vinodk (BOB member since 2006-12-01)
Query Builder does not support sub queries so it isn’t possible to combine the 2 statements. Definitely annoying.
BoB LoblaW (BOB member since 2007-10-23)
However, you can use the SDK to extract the information from one query and use that on the second query.
Below is a post that shows how this could be done:
https://bobj-board.org/t/115414
darcstorm 
(BOB member since 2008-07-22)