I have user the user name as 'USER1' to login to BI publisher.is it possible to display my user name like 'USER1' in prompt level or in layout level.i know we have to use 'xdo_user_name' but can any one explain how to use it.please help me thanks
Asked
Active
Viewed 2,418 times
1 Answers
0
This works for me on an RTF template in BIP.
Put this somewhere in the beginning in your template
<?param@begin:XDO_USER_NAME;'Error'?>
And then wherever you need to print the username, put:
<?$XDO_USER_NAME?>
For me, this prints my BIP username in the output.
Ranjith R
- 1,571
- 1
- 11
- 11
-
One more question can i pass the username to a parameter in BIP to be used? – Eswar Vignesh Jun 25 '16 at 10:00
-
You don't have to pass it, it will be passed into the report at runtime. You can use it in your SQL query using :xdo_user_name. you cannot use () function call. – Ranjith R Jun 26 '16 at 08:32
-
yes . it worked .i used it in the SQL to create a data set .like 'SELECT :XDO_USER_NAME from dual' – Eswar Vignesh Jul 12 '16 at 08:35