
General Notice: BOB is going to retire...please see details here. General Notice: No events within the next 45 days. |
Author |
Message |
cctran Senior Member


Joined: 21 Apr 2005
              Posts: 98

|
Posted: Fri Oct 26, 2007 2:54 pm Post subject: Webi Report Name and UserID viewable in Oracle |
|
|
We're on BOXIr2 SP2 on Oracle 9i.
We have various users developing and running reports, where some reports are not developed efficiently, and causing database temp space and memory issues.
Our DBA is monitoring run reports from Oracle and trying to identify 'problem' reports. The issue is that it's difficult to identify the report name and the userID running the report.
Is there a good way to create a universe object, so that the UserID and reportname are viewable from Oracle 'behind the scenes'? These items would not be displayed on the reports.
thanks,
cctran |
|
Back to top |
|
 |
Marek Chladny Forum Advocate


Joined: 27 Nov 2003
                Posts: 19318 Location: Bratislava

|
Posted: Fri Oct 26, 2007 3:05 pm Post subject: Re: Webi Report Name and UserID viewable in Oracle |
|
|
Hi,
Have a look at END_SQL parameter of the universe. It may help.
Open a universe in Designer -> menu File -> Parameters -> Parameter tab -> END_SQL. Read help for more information
Read also this not so old post. _________________ BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com
Latest Blog Posts • 2013-07-16 Number of reports in a WebI document • 2013-04-01 Optional prompts in a universe • 2012-06-08 Calendar table script for Oracle |
|
Back to top |
|
 |
cctran Senior Member


Joined: 21 Apr 2005
              Posts: 98

|
Posted: Thu Nov 08, 2007 6:11 pm Post subject: Re: Webi Report Name and UserID viewable in Oracle |
|
|
END_SQL works great.
We used this to add the BOUSER and REPORT name as comments to the SQL. For anyone else needing the same (we're on BOXIr2):
@variable('BOUSER') = BO userID.
@variable('DOCNAME') = Report name (took some digging around to find this system variable).
thanks |
|
Back to top |
|
 |
|
|