I built a bunch of tiles that I thought needed to do cross-filtering on.
To do this, all the tiles have to be built from the same explore.
As such, I built some of the tiles off of “indirect explores”. (for example, if I have customer and orders, I built an orders-based tile off of the customer explore that has a join to orders, instead of just building it off the orders explore).
I have discovered that this adds a join to customer on the produced sql, which I don’t want for performance, plus I don’t really need to do cross-filtering in this instance.
Is there anyway to overtly tell what explore a tile is built on? Can I change the explore the tile is built on?