- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 10-08-2009 10:11 AM
(1009 views)
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?
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?
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I think _METAUSER may be what you are looking for. See:
http://support.sas.com/documentation/cdl/en/stpug/61271/HTML/default/a003152603.htm
Vince DelGobbo
SAS R&D
http://support.sas.com/documentation/cdl/en/stpug/61271/HTML/default/a003152603.htm
Vince DelGobbo
SAS R&D
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Vince