I’m trying to generate a list of all webi associated with each of our universes using the CMS system Universe. There are a large number of webi reports that I know to use a universe that don’t get returned in the query. If I look at that in the CMC I can see the relationship between the webi and universe and the webi works fine. When I query the using the Universe’s Technical Properties dimension, the Property Value for PropertyPaths SI_DSL_UNIVERSE and SI_UNIVERSE are 0 for the missing webi. For others using the same database the universe info is listed. It seems like it is either corrupted or needs to be refreshed.. Thoughts?
I would lean toward the data just being missing, not necessarily corrupted.
This could be caused by the reports being older reports where that information was not recorded or it could have been lost when using the various promotion tools over the years.
You might be able to populate that by using the change data source options on the reports but that could end up being a manual process for all of the reports.
Have you created a webi report over the BI on BI universe for the webi docs associated with the universe?