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