My understanding from speaking with BO\SAP is that it is not possible to capture the SQL of a query while it is executing. Does anyone know if, in fact, there is a way to do this in XI 3.1? We have a need to see the queries that are running and their generated SQL in XI. We are planning to use Active Directory in XI (Webi\Deski) but pass through security is not an option for us because our database will not support AD, therefore we need the query insight from XI…
Any information or insights would be appreciated…
BTW, I have submitted an enhancement request to BO\SAP to allow the auditing of queries while they execute but I don’t expect them to do anything with it…
What they told you is correct. BusinessObjects doesn’t have any built in feature to capture the SQL sent to the database. At this point, you would ned to have the database capture the SQL. Of course, if you’re using a generic account to access the database, you won’t know who ran the SQL.
Thanks for the response. We intend to use Active Directory security to XI but since our database does not support it, we are left with implementing a generic account on the database which is the problem.
I was hoping that somone out there has found a way to tweak XI auditing to track and report the SQL for queries which are currently running on the database. It seems reasonable that the Webi (connection server) and Deski (3-tier mode) processing servers should know what SQL was passed through them to the reporting database and that those queries are still in progress…
In Oracle you could have a database against the v$ tables - which would give you the same view as the session browser in TOAD. I’ve put something like that together in the past. It was rough and ready but met a need.
I know this is an old post, but wanted to let you know this. We add a SQL comment to the END_SQL Universe Parameter which include @Variable(‘BOUSER’) so that we know who ran the report when the SQL is captured. For example in DB2 it looks like this:
– This SQL ran by @Variable(‘BOUSER’)
(BOB member since 2002-09-05)
(BOB member since 2002-08-08)
I agree, capturing it would be very helpful in troubleshooting.
(BOB member since 2002-08-15)