I don't know, but the query is in the logs.
Thanks Alex! Just didn't have time to check right off. Would the answer be consistent? Would there ever be cases when it might get processed in the query but other circumstances where the data engine would decide to do it locally?
1 of 1 people found this helpful
Clueless on that as well. Sorry.
If the ad-hoc group is simple then it may be expressed in a query, but if the ad-hoc group has a large number of values assigned to various buckets then it may be too complex for the database to handle inside a query. Instead Tableau may opt to create a temporary table to represent the organization of members in the ad-hoc group, and you will see queries that are expressed as a join against that temporary table. If this is not possible (for example, on a data source which does not support temporary tables or for user accounts which do not have temp table permissions), then Tableau may resort to modelling the ad-hoc groups in a Data Engine extract built in memory.
I hope this helps,