how to get login username

Post Reply
iesak
Posts: 20
Joined: Mon Feb 23, 2009 4:49 pm
Version: 9.4
Excel Version: 2003

how to get login username

Post by iesak »

is there any functions to get login username ?
lotsaram
MVP
Posts: 3698
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: how to get login username

Post by lotsaram »

In 9.1 + TM1User()
User avatar
yyi
Community Contributor
Posts: 122
Joined: Thu Aug 28, 2008 4:42 am
Location: Sydney, Australia

Re: how to get login username

Post by yyi »

=getusernamefromserver("server name") for poor guys like me stuck on an old version. :roll:
Yeon
Alan Kirk
Site Admin
Posts: 6644
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: how to get login username

Post by Alan Kirk »

yyi wrote:=getusernamefromserver("server name") for poor guys like me stuck on an old version. :roll:
Where are you getting that function name from, and in what context are you using it?
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
User avatar
yyi
Community Contributor
Posts: 122
Joined: Thu Aug 28, 2008 4:42 am
Location: Sydney, Australia

Re: how to get login username

Post by yyi »

formula in excel :- get user id currently logged in (< v9.1)
not in TM1 help files, just found it on a sheet somewhere.
Yeon
Alan Kirk
Site Admin
Posts: 6644
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: how to get login username

Post by Alan Kirk »

yyi wrote:formula in excel :- get user id currently logged in (< v9.1)
not in TM1 help files, just found it on a sheet somewhere.
Interesting; no mention of it in the release notes. (Colour me surprised :roll: )

It looks like it applies to Excel only, not T.I.; though iesak didn't indicate the context in which the function was required.

It post-dates 8.2 (the function yields a Name error in 8.2.12), though it's available in a 9.0 test version that I'm running. So it may have appeared in 8.3, 8.4 or 9.0.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply