Report that shows list of reports and the universes used

[system]

hey guys

is it possible to produce a report that shows the reports and the universes they use?

thanks!

---

outatime (BOB member since 2007-11-20)

[system]

I do not believe the Activity Universe/database contains the Universe a report was written against…I could be wrong, and if so , you should be able to create a report easily.

However, you might want to check out the BOB downloads section, specifically this topic:

BOXI Repository Documentor

I have created the attached spreadsheet for XI R3 which will retrieve information about the reports, Universes, connections and categories in the BOXI environment. It will also provide information as to which reports use a specific universe and which reports may be affected by a universe change too - as returned when querying via the query builder. It should be ran under the administrator account for the best results, but also works for delegated administrators/users. The first tab has a secti…

There is a tool there that will provide you exactly what you are looking for, though it uses Excel instead of a BOBJ tool to acomplish it.

---

JPetlev (BOB member since 2006-11-01)

[system]

The Activity Universe can be used to discern reports and the Universe they use:

“Document Name” under Actions>Document Operations
“Universe Name” under Actions>Action Details.

…although you will get duplicates if your Report has changed Universes.

HTH

---

mcnelson (BOB member since 2008-10-09)

[system]

thank you guys!

---

outatime (BOB member since 2007-11-20)