I am trying to use the new bind_all_filters option for a NDT. The NDT is used to dimensionalize some measures so that I can tier them for a histogram. The NDT is joined to the source explore. I found the bind_all_filters gives me a great performance boost but I found that I cannot do things like filter on the tiers. I get and error and the SQL cannot be rendered saying:
A LookML model issue prevented this query from running.
There was a problem building the derived table for view “live_video_histogram”. Circular dependency detected from derived table to source explore “live_video”.
If I remove the bind all filters everything is fine.I get the same error if I try to drill in on the histogram count result which is basically doing a similar thing running a query with a filter on the histogram tier…