Cannot extend an explore joined to a view which uses bind_all_filters

Here’s the problem I’m running into.  I have a view that uses bind_all_filters and looks like this:

view: top_customer_view {
derived_table: {
explore_source: base_data {
bind_all_filters: yes
column: customer {}
column: customer_rank {}
}
}

dimension: customer {
primary_key: yes
hidden: yes
}

dimension: customer_rank {
hidden: yes
type: number
}

dimension: top_customers {
type: string
sql: iff(${customer_rank} <= 10, ${customer}, 'Other') ;;
}
}

And it’s being used in the explore from which it is derived like this:

explore: base_data {
join: top_customer_view {
relationship: many_to_one
sql_on: ${base_data.customer} = ${top_customer_view.customer} ;;
}
}

So far so good. As documented the view using bind_all_filters is joined back to the explore from which it is derived.

However, now I’d like to us base_data and top_customers in a new explore so I tried to extend base_data:

explore: base_data_extended {
extends: [base_data]
}

But this then fails with:

Cannot use native derived table "top_customer_view" with "bind_all_filters" outside of its source explore

Is there any way to accomplish this?  I’d like to have multiple explores which extend and reuse the base_data explore, but this seems to not play nice with bind_all_filters.

2 0 128
0 REPLIES 0
Top Labels in this Space
Top Solution Authors