Skip to Content

how to extract list of universe and related reports in the repository using auditing database

Jul 04, 2017 at 11:50 AM


avatar image
Former Member


I need to extract the list of UNV universes and the corresponding reports from the BO 4.1 repository. I need the details as a report so that we can run the report on specific duration.

Query builder will provide the result but we will not be extract to excel as required. Is it possible to generate this report from the Audit database.

As I tried in the Audit universe, the report name and universe name are in the same column object name and its differentiated only with object type i.e universe or report. But I need both the information together. Below are the details required in the report

Universe Name

Universe Type (unv or unx)

Universe folder

Report Name

Report Folder



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Manikandan Elumalai Jul 04, 2017 at 01:24 PM

If you are planning to extract his from Audit universe you may need to use this report (16. USA4 – Usage – Universe Objects usage. Identify infrequent used objects.wid) downloaded from here.

You can also use query builder to extract this info for each universe.



10 |10000 characters needed characters left characters exceeded