I have a document that will be used by various groups around my organization, and depending on the project they are working on, they need to see different subsets of data. My requirement is to have Tableau prompt the users for some values when they open the document. Those values will be passed into the stored procedure that creates the data source for their document.
Has anyone done this, or know of some examples I can look at for guidance?
Also, ideally, the user prompts would allow the user to choose values from a text list, which then passes an ID to the stored procedure, so the user doesn't have to know the ID numbers of the categories they choose.
You might try the developer area as this sounds like something that would likely go the route of the Developer Forums to create the data set outside Tableau entirely before inputting the data to Tableau.
Let us know how it goes as this sounds very interesting.