I am trying to check how long a query running in a report is taking. Say that I open a file in Webi, that file in turn runs a query (in this case, against HANA). Is there a log where we can see how long it took to run? If so, where is it located? We are running BOBj 4.1
Thanks
lgarcia3 (BOB member since 2016-10-17)
The default location for logging files in BI4.1 is:
C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\logging
You will need to enable logging for WebI servers. This is done in the CMC -> Servers -> Web Intelligence Servers. Go through each server, and set the Log Level to High.
But be warned - the log files contain a lot of detail and can be difficult to follow.
joepeters 
(BOB member since 2002-08-29)
Great! Thanks!
lgarcia3 (BOB member since 2016-10-17)
If you auditing enabled, you can find the refresh duration in Audit database, as well.
Also, I’m not familiar with HANA, but I assume it has some way at the database to track the duration of a query. You would need a way to find the relevant query, but your DBA can probably help with that.
MichaelWelter 
(BOB member since 2002-08-08)
Michael, thanks! Yes, I was finally able to find the logs. I am new to Business Objects in general. I have worked with different systems and logs normally have the query executed and the time it took to comeback to the system (if the query is successful or course). In this case, I don’t see anything like it. Maybe I am looking in the wrong place. Also, we set up the logs to the highest possible level of detail and not sure that helps much. I am not Audit enabled; so any idea where this information may be?
Thanks
lgarcia3 (BOB member since 2016-10-17)
Have you talked to your HANA DBA? They may be able to get that information from the DB.
MichaelWelter (BOB member since 2002-08-08)