How to get the logged in user , OBIEE
How to get the user logged in OBIEE.
Question from BIP forum
Shashi was asking for , how to get the username, so that, he can use them in the LOV query to filter based on user logged in.
I guess, there are many ways to acheive it, using the NQ_SESSION, and alos using the $SYSUSER.username variables.
But, he just needs the username to be used in the query.
Here it is.
Select :xdo_user_name from dual, returns the username.
Ex: usage
Select dept from table where user_name = :xdo_user_name
Question from BIP forum
Shashi was asking for , how to get the username, so that, he can use them in the LOV query to filter based on user logged in.
I guess, there are many ways to acheive it, using the NQ_SESSION, and alos using the $SYSUSER.username variables.
But, he just needs the username to be used in the query.
Here it is.
Select :xdo_user_name from dual, returns the username.
Ex: usage
Select dept from table where user_name = :xdo_user_name
Comments