Webi Report Name and UserID viewable in Oracle

[cctran]

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

[Marek Chladny]

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.

[cctran]

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