5 Replies Latest reply on Jun 26, 2016 5:33 AM by Russell Christopher

    Dynamic SQL Based on User ID?

    Todd Moses

      Is it possible from within Tableau, to create a custom SQL data source using Dynamic SQL that takes the NT-USER-ID of the computer running the report into account when executing?

       

      Ultimately, I want to create one data source for my users, and point a "template" workbook at it for them to create their own reports.

       

      This template workbook needs to restrict which fields would be available for a user to use in their reports.

       

      Rather than creating/maintaining ten different workbooks for ten different users, I was curious if I could create one workbook, and manipulate the SQL dynamically in the data source based on their ID.

       

      Thank you.

      -Todd