Document Universe Overloads/Access Restrictions

[Former Member]

Is there a good way to document universe overloads/access restrictions? I can't seem to find anything. We have a ton of universe objects which are restricted for certain users/groups, and we need to re-work this list. Ideally, I'd love to have these listed out by restriction name - restricted object, or restriction name - row-level restriction.

Any help is much appreciated!

[Former Member]

There is no tool from which you can get the report directly. But using Query Builder you can get Generate the report the way you need and Query to the CMS might be something like SELECT SI_NAME, ...<etc> from CI_APPOBJECTS where SI_PARENTID= <Universe ID> ....

Hope this will Help You.

Best Luck.

KUNAL

[Former Member]

Hi Kunal,

Yep, that's exactly what I did. The query I used was:

Select SI_NAME, SI_OBJECTS

from CI_APPOBJECTS

where SI_KIND like '%OVERLOAD%' and SI_PARENT_CUID = '<universe ID>'

This worked fairly well, but it would be great if SAP would give us an ability to output these queries to Excel to make them more manageable.

Thanks!

Bill