BusinessObjects Board

determine reports based on a particular universe

building semantic layer
#1

Hi all,

Is there a way to search and determine all the reports that use a particular universe.

thanks,
rao.

p_rao (BOB member since 2007-02-26)

#2

Have you looked at Auditor?

JMulders :us: (BOB member since 2002-06-20)

#3

To get the reports that have never been refreshed, you can also navigate to the universe in the CMC, right-click and choose Tools -> Check Relationships to see associated documents.

BoB LoblaW :us: (BOB member since 2007-10-23)

#4

Query builder will help you get the details…

search the forum for sample query :smiley: :smiley: :smiley:

sivakumar_bo (BOB member since 2006-04-22)

#5

Use the below Query in Query Builder.

SELECT SI_ID, SI_NAME, SI_WEBI , SI_OWNER
FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS
Where PARENTS(“SI_NAME=’Webi-Universe’”,”SI_NAME =’Your Universe Name’”)

You can also refer my blog below for more such queries.

http://blogs.hexaware.com/business-objects-boogle/business-objects-query-builder-part-ii/

Manikandan Elumalai :us: (BOB member since 2009-10-23)

#6

Thank you all for your help. Will check all the various options mentioned here.

p_rao (BOB member since 2007-02-26)

#7

Hi all,

I tried the following queries in the query builder. I first tried :

SELECT * FROM CI_APPOBJECTS WHERE SI_KIND=‘Universe’ AND SI_NAME=’Universe name’

and it gave me all information including a list of ids for webi reports. there are total 40 and then I tried the following query:

SELECT SI_NAME,SI_DESCRIPTION, SI_ID,SI_AUTHOR,SI_PARENT_FOLDER,SI_UNIVERSE,SI_HAS_PROMPTS
FROM CI_INFOOBJECTS
WHERE SI_ID IN (nnnnn,nnnnn,nnnnn)

where SI_ID is the list of ids I got from the first query and it gave me back only 2 reports out of 40. What could be the reason? I have logged into query builder as a user instead of admin as I don’t have the admin privileges. Is this because of that, that I am not able to get the information for the other reports or is it because the reports might have been deleted?

thanks.

p_rao (BOB member since 2007-02-26)