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

Comments

Anonymous said…
Excellent!! thanx!! u saved my day...
Anonymous said…
Nice brief and this post helped me alot in my college assignement. Say thank you you on your information.

Popular posts from this blog

BIP Formatting

Repeat Table Header in all pages in BIP

Limit rows per page