In BO 4.2 SP3, you are finally able to run queries against CMS database without 3rd party tools! SAP has introduced a new CMS data access driver. So it is now possible to use a universe and standard BO tools to query the metadata of the CMS repository database.
Download “The LCMBIAR contains the connection to CMS database “SAP BI platform CMS system database” and a sample universe universe “SAP BI platform CMS system database”.
Now you can easily get a list of all your Web Intelligence documents:
Or you can find dependency between universe and Webi document: