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?