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: SAPinsider BI 2018 Vegas: Mar 1.

one shot report

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

Joined: 18 Oct 2005

Posts: 16

PostPosted: Sun Oct 08, 2017 5:15 pm 
Post subject: one shot report

how could one trace a one shot query on a universe which is not saved ?

Back to top
Forum Enthusiast
Forum Enthusiast

Joined: 16 Apr 2007
Posts: 1817
Location: Atlanta, GA

PostPosted: Tue Oct 17, 2017 3:14 pm 
Post subject: Re: one shot report

You may be able to find something in the Audit database.

Assuming that you're using BOBJ 4.x, you would specifically look at sessions in the ADS_EVENT table where the the event types 1005 - Create and/or 1003 - Refresh exist for the Session_ID but where the Session_ID does not have records with the the event types 1008 - Save or 1013 - Retrieve for the same Object_ID.

However, you won't be able to see the SQL for the report unless you have auditing set up to include the query. Best practice is to not include the query because it can dramatically increase the size of your audit database. I usually only turn on the option to save the query if I'm troubleshooting a report issue where I can't find the problem any other way and I turn the option off immediately after I get the query I need.


DecisionFirst Technologies - a Protiviti Enterprise
Nine-time SAP BusinessObjects Partner of the Year.
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.0096 seconds using 17 queries. (SQL 0.0030 Parse 0.0002 Other 0.0065)
CCBot/2.0 (
Hosted by | Terms of Service
phpBB Customizations by the
Shameless plug for Moments of Light Logo