Thursday, March 13, 2014

How to find all reports associated with a universe - Relationship Queries

Today while talking with SAP Tech Support I stumbled across a wonderful little gem!  I've been asked a few times if I could find all the reports associated with a particular universe.  I know I could accomplish this with the Query Builder tool, but it always requires a lot of research to find the correct query to write.  Also documentation is pretty sparse.

So to cut to the chase, all you do is go into the Central Management Console (CMC), right click your universe, choose Tools then Check Relationships.  Easy Peasy!  You'll see not only reports, but a few other things as well.

No comments:

Post a Comment