1 Reply Latest reply on Jan 15, 2014 8:57 AM by Robert Morton

    SQL Server UDF and username function

    lOZ SSS

      I would like to build a source query that calls a SQL Server user defined function (UDF) and passes in the tableau username function as an parameter to the UDF. 

       

      select  * from SQLServerUDF (USERNAME())

       

      Is this possible?

       

      I have read about how you can use the tableau username function with data source filters to add / modify the
      where clause.  However, this scenario is a bit different since I want to use the function as a parameter to a UDF.

        

      Also FYI - I can’t use the SQL username function since the workbook will run under the tableau service
      account once published to Tableau Server.

       

      Thanks