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: Upcoming Events: ASUG New England fall meeting: Oct 27.

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
titofacasa
Forum Member
Forum Member



Joined: 18 Oct 2005

Posts: 14



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

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

thx
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



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


flag
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.

-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.0160 seconds using 17 queries. (SQL 0.0039 Parse 0.0003 Other 0.0118)
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