When you create the extract, Tableau will execute the stored procedure and pass the value of the parameter at the time.
Changing the parameter after the extract won't cause the extract to be re-generated, thus the extract will still contain the same data until the next time you generate the extract.
Thanks for your reply.
In other words, a parametrized SP cannot be used as an extract because the data can always change.
There's nothing wrong with using a parameter with a stored procedure and an extract - I use them all the time. You just need to be aware of the fact that changing the parameter does not re-generate the extract.
If this needs to be something controlled at run time, why not generate the SP for all data types and use a quick filter instead?
because tableau doesn't support the type of filtering I need. A list of terms to filter a field by, for example .google., .bing., .yahoo. all at once.
Sure it does, you just need to think a little differently.
How complex are your list of terms?
In the attached example,
- FilterByKeyword will allow the user to filter by a keyword of their choice
- FilterByKeywordItem allows you to predefine a list of keywords available for single selection
- FilterByGroup allows you to define groupings using IF statements within calculated fields (see the KeywordGroupingFilter)
KeywordGrouping.twbx 18.0 KB
Thanks for your help! None of these work for what I need.
What I need is to freely type in a set of keywords by which to to filter, delimited by a separator, ie, comma.
The FilterByKeyword is close, but it only allows one term to be entered, I need to freely enter any term or set of terms I want. And not a predefined list of terms.
For example, enter bing, google, tom or www.,yahoo, .com, then filter the report by those terms.
If you really want to break free of the Stored Procedure approach, you could setup multiple parameters i.e. Keyword1, Keyword2, Keyword3 and set the filter to use an OR condition i.e. Contains([Domain],[keyword1]) or Contains([Domain],[keyword2]) or Contains([Domain],[keyword3]) etc..
The reality of this is going to be bound by how many keywords a user need to filter on at any given time.
You could use the SUBSTR and FIND functions to split your string but that's going to get ugly quickly and I wouldn't really consider it a viable option.
Yup that's what I thought too. I'll keep my current solution. Thanks for you help though.
This would be a nice feature for tableau to have.