Universe Cleanup

[wallbertelicot]

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?

[Joe_Peters]

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.

[ayman_salem]

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

[TJe]

Should be possible using the CMS DB universe, see blog

regards
Thomas

[daniele_tiles2]

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

[former_member185603]

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.