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.

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: 1843
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.


Data & Analytics Practice
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.0292 seconds using 17 queries. (SQL 0.0025 Parse 0.0009 Other 0.0258)
CCBot/2.0 (
Hosted by | Terms of Service
phpBB Customizations by the
Shameless plug for Moments of Light Logo