While creating a stored process in my dashboard I came across a requirement of storing the BI portal logon, which is actually used as the physical folder name where the report has to be stored.
Is there any function or automatic macro that could help me to get the user id who is currently running the process?
When I tried to use %sysuserid I got "sassrv" in the report, even when I logged into portlet with my windows authenticated user ID
Then I found that "sassrv" is the user id that is used by stored process server.
Can anyone suggest me how to get the user id who logged into BI portlet and use it in stored process?