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: SAP BOBJ User Group DC: Nov 30.

Time spent processing


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



Joined: 05 Sep 2002

Posts: 324
Location: London


flag
PostPosted: Tue Aug 29, 2017 5:00 am 
Post subject: Time spent processing

We have BOXI 4.1 SP3

We do not have access to the latest Auditing Universe, just the one originally shipped.

My question is can we determine the actual BOXI processing time from then Audit tables.

Scenario
Report is scheduled, and goes into
1. Pending mode
2. Pre-processing, prompt resolution, SQL generation etc
3. Waiting for query to return from database
4. Post Processing
5. Distribution


Can we just measure time spent on pre and post processing?
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 13792
Location: England


flag
PostPosted: Wed Aug 30, 2017 5:14 am 
Post subject: Re: Time spent processing

Hi Paul, I don't think you'll get anything other than duration, start and end date time. You could look at duration and compare it to the difference between the start date time and the end date time. If could be that duration purely relates to database refresh - but if you think in terms of instance details you get a create time, start time and end time plus duration......and the start time vs end time is the same as duration - so you can't tell the difference between a report that took 90s on the database and 10s to distribute and a report that took 10s on the database and 90s to distribute.

What lies behind the question?

_________________
My latest idea....
Back to top
Paul Shovlar
Principal Member
Principal Member



Joined: 05 Sep 2002

Posts: 324
Location: London


flag
PostPosted: Wed Aug 30, 2017 7:25 am 
Post subject: Re: Time spent processing

Thanks Nick

That's pretty much the conclusion I'd come to.

What's behind the question is that the number of reports has outgrown our present hardware, and although we are upgrading this, there is a lot of talk about "demand management".

This question came up as one way to determine the most "expensive" reports


icon_smile.gif
Back to top
JohnBClark
Forum Associate
Forum Associate



Joined: 27 Mar 2007
ASUG Icon
Posts: 929
Location: Appleton, WI USA


flag
PostPosted: Wed Aug 30, 2017 9:01 am 
Post subject: Re: Time spent processing

There are some different Event Types though. You might be able to break some information out by those. For example, I would assume that the Refresh event type is for retrieving data from the database and the Retrieve event type would be for retrieving the report from the FileStore. If I remember correctly, it may be hard to correlate these events to a single instance of a report running because they have different Event IDs.

This is an interesting topic but I don't have time to dig into it right now. Wish I did.

_________________
BusinessObjects BI4.1sp7, SQL Server 2012 (CMS)
Working on upgrade to BI4.2sp4
Clustered for fail over redundancy
Reporting Tools: Crystal Reports 2013, Web Intelligence
Operating System: Windows 2012 running on VMWare
Reporting databases: SQL Server, Teradata, DB2, Oracle
Setting up Information Steward 4.2sp7
History: BO5, BO6, XIR2, XI3.1
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 13792
Location: England


flag
PostPosted: Thu Aug 31, 2017 8:05 am 
Post subject: Re: Time spent processing

The other thing to say is the great Matthew Shaw has created a better audit universe for various databases:
https://blogs.sap.com/2015/07/15/unlock-the-auditing-database-with-a-new-universe-and-web-intelligence-documents-for-bi41/

He also might have a view on what can and cannot be done from your original requirement.

_________________
My latest idea....
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.0111 seconds using 17 queries. (SQL 0.0030 Parse 0.0002 Other 0.0079)
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