BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Nov 1.

Webi Report Name and UserID viewable in Oracle
2 members found this topic helpful

 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
cctran
Senior Member
Senior Member



Joined: 21 Apr 2005

Posts: 98



PostPosted: 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
Forum Advocate



Joined: 27 Nov 2003

Posts: 19312
Location: Bratislava


flag
PostPosted: 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
Senior Member



Joined: 21 Apr 2005

Posts: 98



PostPosted: 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
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0269 seconds using 17 queries. (SQL 0.0025 Parse 0.0008 Other 0.0236)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo