UserName (MDX)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

MDX Function Reference (MDX)