Reports Based on unx universe from BI platform CMS system database Universe

I have a report that I have written against the SAP provided BI platform CMS system database [unx] universe that will give me a list of all of the objects that relate to a specific universe.


This works great for unv universes. I can schedule the report and create an Excel file of the output to provide to our Universe Developers.

Where I’ve run into a problem is that this report isn’t working for unx universes. This query returns no data for a unx universe.
I tried replacing the Unv-To-Webi and Unv-To-Cnx relationship objects with the Unx-To-Webi and Unx-To-Cnx relationship objects but the query still doesn’t return any data.

Having both sets of relationship objects in the query will still return data for the unv universe but not the unx one. This makes me think there is something else different about the unx universes that needs to be queried for.

Does anyone have any ideas on what the problem might be?

1 Like

I found the problem. The Kind for a unx universe is DSL.MetaDataFile. After I added the Unx-To-Webi and Unx-To_Cnx relationship objects and changed the Kind filter to InList and added DSL.MetaDataFile there, the report works for both universe types.

I found this by querying for a unx universe in Query Builder and checking the SI_KIND property.

1 Like