topic Re: How do I fetch BI portal logon name in a Stored process of a dashboard? in Developers

How do I fetch BI portal logon name in a Stored process of a dashboard?

deleted_user — Thu, 08 Oct 2009 14:11:35 GMT

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?

Re: How do I fetch BI portal logon name in a Stored process of a dashboard?

Vince_SAS — Thu, 08 Oct 2009 15:12:03 GMT

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

Re: How do I fetch BI portal logon name in a Stored process of a dashboard?

deleted_user — Wed, 11 Nov 2009 08:39:10 GMT

Thanks Vince