BIP (OBIEE 11.1.1.7): Pre Process Function

Hello,

I created function as described in BIP Admin Guide section 9.1.7  About Pre Process Functions and Post Process Functions.

The function simply does the following:

     dbms_application_info.set_client_info(client_info=>'BIP User: '||p_username);

     DBMS_SESSION.SET_IDENTIFIER(p_username);

where p_username is :xdo_user_name passed to the function as indicated in the above mentioned documentation.

This allows the DBA to query v$session view to see which BIP sessions are active.

One curious thing I noted that although I am only setting the identifier and client_info as indicated above, BI Publisher populates the MODULE column of v$session with the executing report !