UserName (MDX)

Returns the domain name and user name of the current connection.

Syntax

UserName [ ( ) ]

Remarks

The returned value is a string with the following format:

domain-name\user-name

Example

The following example returns the user name of the user that is executing the query.

WITH MEMBER Measures.x AS UserName
SELECT Measures.x ON COLUMNS
FROM [Adventure Works]

See Also

Reference

MDX Function Reference (MDX)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

17 July 2006
Changed content:
  • Updated syntax and arguments to improve clarity.
  • Added updated examples.
  • Last updated on