How do i get list of documents based on a particular universe in query builder?
pkommidi (BOB member since 2006-03-10)
Get the list of report IDs where xxx is your universe name
Select SI_WEBI from CI_APPOBJECTS where SI_KIND='Universe' and SI_NAME='xxx' ) Get reports name from
SELECT SI_ID, SI_NAME FROM CI_INFOOBJECTS WHERE SI_KIND = 'WebI' and SI_ID IN (123,456) Where 123, 456 are report IDs from previous query
.
haider 
(BOB member since 2005-07-18)
check in the download’s.
There’s an excel that you can use which give lot’s of information on the reports (universe used, size,…)
meutte 
(BOB member since 2007-12-06)
(BOB member since 2007-10-05)