BusinessObjects Board

Identify the users and reports based on a set of objects

other Auditor
#1

Hi,
We are on BO 4.1 SP7 and we would like to know how to identify the list of users and reports who are using a set of universe objects.

e.g. What reports and users are using object called “SSN” from “Employee” universe.

Note we are using out of box Auditing.unx universe which doesn’t have any information(Objects) on Universe and Reporting Objects.

Appreciate if any one can share the query which can be run against BO Audit Tables to retrieve the required information.

Appreciate your help.

Thanks
Leo

Leo :us: (BOB member since 2004-01-07)

#2

You can’t get this information from either the Audit tables or the CMS database - neither of those have information about the specific objects that are used in reports.

Instead, you would have to use the Webi RESTful Web Services SDK to determine which reports are using that particular object. Then you would have to look at the audit database to get the usage info for those particular reports.

-Dell

hilfy :us: (BOB member since 2007-04-16)