UserLastName

Returns the last name of the currently logged in user.

  • Returned Output: Text
  • Library: PQL \ Common \ Identity
  • Version: 2018.00.000
  • Compatibility:
    • Can be combined with and other PQL function throughout the application.
    • It CANNOT be used with MDX or VBA functions. But it can be used on MDX-based content in other parts of the application.

Syntax

UserLastName()

Comments
  • The function returns a text string of the user's last name
  • The function takes no inputs
  • The function is often used to customize the way queries or formula's operate based on the user that is currently running a report or dashboard. It can also be used in driving member level security for data models - allowing a data model to be customized for each user logging into the application.
Different Function types
  • The other "identity" functions can be used to secure and customize the analytics experience. For more see the UserName function.

Examples

This example shows how to use the function to build a personalized welcome message for the logged in User "Avi Perez".

"Hi " + UserfirstName() + " " + UserLastName() + ". Welcome to your analytics Sales Dashboard."

The natural language template allows us to formulaically build out the message using a combination of the user's recorded first and last names. This can be driven from Present, Publish or Illustrate dynamic text functionality, as shown below.