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

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Oct 19.

List reports that use a particular object


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



Joined: 25 Aug 2005

Posts: 377
Location: London


flag
PostPosted: Mon Sep 18, 2017 4:07 am 
Post subject: List reports that use a particular object

Is it possible to run a query against the audit DB or universe that lists all reports from a given universe that use a particular object? Thanks.

BOE 4.2 SP3
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



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


flag
PostPosted: Tue Sep 26, 2017 1:42 pm 
Post subject: Re: List reports that use a particular object

Unfortunately, no. The information about which objects are used is stored in the reports themselves, not in the CMS database.

I believe this information might be available through the use of SAP Information Steward (which is a separate license).

I know this information is available through the RESTful Web Services Webi and Semantic Layer SDKs. However, if you need to get to the specific fields that are in use in the universe objects you also have to get information from the universes through the Designer SDK (for .unv) or the Java Semantic Layer SDK (for .unx). I have written a set of programs that do this and store the information in a SQL Server database, but the code belongs to my employer, so I can't really share it.

-Dell

_________________
Protiviti
Data & Analytics Practice
https://www.protiviti.com/US-en/data-management-advanced-analytics
Back to top
Judith Dotson
Forum Member
Forum Member



Joined: 16 Aug 2002

Posts: 11
Location: New York


flag
PostPosted: Thu May 10, 2018 4:06 pm 
Post subject: Re: List reports that use a particular object

Hi, does anyone know if there are any vendor products available that might have this feature; i.e. find reports in the Public Folders that use a specific universe object?

Thank you.

_________________
Judith Dotson
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.0314 seconds using 17 queries. (SQL 0.0027 Parse 0.0009 Other 0.0277)
CCBot/2.0 (https://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