BusinessObjects Board

how to know which report using which universe

building reports webintelligence
#1

Hello,

in our environment we have 5 universes and about 100 reports and also some other reports which are based on stored procedure

is there any possible way (not like, go to CMC and see each report properties because it is about 100 plus reports)

can we know which report is using which universe (name)
which report using stored procedure

can any one tell me? Please

Thanks in advance
ash

asni (BOB member since 2007-04-06)

#2

Use query builder. You may have to fiddle with the queries but it should be able to display the information you are looking for.

mcliffordgoo :us: (BOB member since 2003-02-13)

#3

If you have auditor configured you can determine which report files are running against your universes.

sseeling (BOB member since 2006-01-12)

#4

Please look at the post https://bobj-board.org/t/101886

Query Builder will give you a current “snapshot” of what is currently in your repository.

cduey :us: (BOB member since 2002-09-05)

#5

Hello Michael,

thanks for your post
i used Query Builder

by issuing below query i got SI_ID’s
select * from ci_appobjects where SI_KIND = ‘Universe’

by issuing this query i got universe using reports
select SI_KIND,SI_NAME,SI_COMMENTS,SI_FCDP_SOURCENAME from ci_infoobjects where SI_ID in
(7627,5414,…)

but obviously i got half result (which i am looking for) but its not complete
even output also not good

how can i get Folder information i mean report exist in which folder by one universe

i would any other ways except Query Builder
no with Audit reports

how is this idea

i will have a report with prompt Enter Universe name : user enter s existed universe name then it will show all of reports based on the given universe

is this possible

Thanks & Regards
ash

asni (BOB member since 2007-04-06)

#6

hi sseeling,

Thanks for your post

in our current system we dont have configured auditor, any way if we have how we can determine using given reports or any other way

could you tell me please

regards
ash

asni (BOB member since 2007-04-06)