BO4 - BEGIN_SQL + oracle to capture bouser and docname

[former_member272336]

Hi,

We would like to know for each sql kicked off by web intelligence who the report user is and what the docname is.

Looking at the manual for idt can see reference to the BEGIN_SQL parameter but that is only teradata.

Anyone been able to use BEGIN_SQL to capture the docname + username for each sql which is running so that when sql running on database we can see what that relates to  as all sessions on database just show as wireportserver.exe

Thanks

[nscheaffer · Accepted solution]

I have not done this myself, but perhaps you can use END_SQL.

Webi Report Name and UserID viewable in Oracle

Hope this helps,

Noel

[former_member193452 · Accepted solution]

To capture the report / user/universe information for queries the END_SQL parameter can be used with the following syntax

/* this syntax */

Example /* @Variable('BOUSER') */

user BOUSER

Data provider name DPNAME

Data Provider type, DPTYPE

Universe name, UNVName,

Document name DOCName

to put multiple values, separate each with a semi colon ;

Jacqueline

[former_member272336 · Accepted solution]

Thanks for replies.  Put following  in END_SQL and generates what we want.

/* @Variable('UNVNAME') - @Variable('BOUSER') - @Variable('DOCNAME') */