We’re trying to make use of the view_label attribute on dimensions/measures to make our explore UI more intuitive. It’s worked super-well for most use-cases, but we’re running into some problems when we want to make an explore that joins to the same view multiple times.
The issue is that even though we specify a new view_label in the explore, the view_label defined in the view still gets used. This means that in the new explore, there’s no way to figure out which variable is which. In the example below, it’s impossible to tell from the UI wether dim1 is from View A or View B because two dim1 dimensions show up under the ‘Separate View’ header.
# Filename: otherview.view.lookml
- view: otherview
fields:
- measure: count
type: count
- dimension: dim1
view_label: 'Separate View'
sql: ${TABLE}.dim1
# Filename: base.model.lookml
- explore: multi_explore
view: base_view
label: 'My Sweet Explore'
view_label: 'Base'
joins:
- join: other_view_1
from: other_view
view_label: 'View A'
relationship: one_to_one
sql_on: ${base_view.a_other_id} = ${other_view.id}
- join: other_view_2
from: other_view
view_label: 'View B'
relationship: one_to_one
sql_on: ${base_view.b_other_id} = ${other_view.id}