Skip to Content

Universe Cleanup

I know this might have been asked already but I cant seem to find a definite answer. We are doing a cleanup of our universes that are not being utilized. We have about a 100+ universes currently in production and doing a manual check by going to CMC > Universes > Check Relationships would be tedious and time consuming.

Is there a way to run a report, checking webi reports on universes they utilize? And then cross reference it to a report of a list of our available universes to see which ones are not being utilized?

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Posted on Oct 17, 2019 at 12:57 PM

    You can use some 3rd part tools like 360, which will query the CMS db to get the reports list using the universes. Or you can write .net or java code using SDK to get the information you need.

    If you want to know who accessed the universe , you can use audit reports to get those details.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 17, 2019 at 01:05 PM

    Hi,

    we used the BIClever tools for cleaning (a bit) our situation before migrating to BI 4.2.

    In my opinion they work perfect (you can get all the reports associated to a Universe).

    You might also need to check if there aren't custom apps, QaaWS working on the universes, and that you need to do it manually...but usually the effort is not comparable.

    Another suggestion is to use the reports for the audit (if you check that all the reports of one universe haven't been accessed in the last X years...you can clean reports and universe ;))

    HTH

    Daniele

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 17, 2019 at 01:36 PM

    Should be possible using the CMS DB universe, see blog

    regards
    Thomas

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 17, 2019 at 04:05 PM

    also "BI Support Tools" will give you a complete reports about the universes and reports

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 18, 2019 at 03:48 PM

    You can use Query Builder for a quick-and-dirty list of universes with no WebI reports.

    select si_name from ci_appobjects where (si_kind = 'universe' and si_webi.si_total = 0) or (si_kind = 'dsl.universe' and si_sl_documents.si_total = 0)

    Note that this method (and others that leverage the si_webi and si_sl_documents properties) is not perfect. It's possible for a WebI report to lose its association to a universe and not be captured in the above query. Only by extracting the metadata from reports can you be certain that a universe is unused.

    Of course, if you have anything else that uses a universe (CR, Lumira, etc.), it won't be captured here.

    The BIPST also provides this information, if you run a "Semantic Layer" report.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.