BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Identify the users and reports based on a set of objects


 
Search this topic... | Search Auditor... | Search Box
Register or Login to Post    Forum Index -> Other Products -> Auditor  Previous TopicPrint TopicNext Topic
Author Message
Leo
Principal Member
Principal Member



Joined: 06 Jan 2004

Posts: 157
Location: New Jersey


flag
PostPosted: Sun May 14, 2017 11:47 am 
Post subject: Identify the users and reports based on a set of objects

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
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1790
Location: Atlanta, GA


flag
PostPosted: Thu Aug 10, 2017 12:45 pm 
Post subject: Re: Identify the users and reports based on a set of objects

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

_________________
DecisionFirst Technologies - a Protiviti Enterprise
Nine-time SAP BusinessObjects Partner of the Year.
www.decisionfirst.com
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Other Products -> Auditor  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0119 seconds using 17 queries. (SQL 0.0027 Parse 0.0002 Other 0.0091)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo