About Report Analysis

[system]

Hello All

Is there any way to find schema and table names that are used by set of webi reports without opening each and every report ?

Thanks in Advance

---

nmadithya (BOB member since 2012-07-19)

[system]

Not that I know of but if you look in the BOBs Downloads section of the forum you’ll find this post:

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…

This is the Repository Documenter and there’s a version up to 3.x in there which I’ve been using for a little while now. It’ll document all your reports and universes and tell you what reports are using which universes. What it won’t do is tell you which schemas you’re referencing.

I tried to do something similar myself recently but if you take the time to look through BO VB Object Library I think you’ll find that you can’t get to objects SQL.

I can’t speak for R4 users - I wrote some code that opened up all our Deski reports one by one and analysed which objects and universes they were using and documented it - but of course, that won’t work in R4 because Deski is finally where it needs to be - d.e.a.d!

---

SteveD (BOB member since 2009-11-02)