Sometimes you see very large SQL expressions which are killing your database systems. With audit reports you can find which reports have run after they finished. But with this little code you can directly find the user, the report and the universe from your database directly on demand.
http://www.dallasmarks.org/blog/2011/10/tips-and-tricks-identifying-business-objects-queries-using-end_sql/
Just put this lines to your universe parameters "END_SQL" line:
/* @Variable('UNVNAME') - @Variable('BOUSER') - @Variable('DOCNAME') */
Thats it. Your query will look like this:
Your dba will appreciate you.
Showing posts with label current. Show all posts
Showing posts with label current. Show all posts
Tuesday, November 27, 2012
Subscribe to:
Comments (Atom)

