Skip to Content
avatar image
Former Member

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


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



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.



    Add comment
    10|10000 characters needed characters exceeded