connection: "looker_high_performance"

include: "*.view.lkml"

# This model has been created as a temporary placeholder for Sim Livre to have access to the client facing market share model whilst we determine if they should have access to the Market Share (New) explore, which shows Orchard level data.

label: "Basic Models"

explore: fact_sales_market_share_joined_view {
  label: "Market Share (Client)"

  access_filter: {
    field: dim_label.label_id
    user_attribute: label_id
  }

#  always_filter: {
#    filters: {
#      field: fact_sales_market_share_joined_view.fact_sales_country_id
#      value: "13"
#    }
#  }

   join: dim_country {
     view_label: "Territory"
     sql_on: ${dim_country.country_id}=${fact_sales_market_share_joined_view.fact_sales_country_id} ;;
     relationship: many_to_one
   }

  join: dim_store {
    view_label: "Store"
    sql_on: ${dim_store.store_id}=${fact_sales_market_share_joined_view.fact_sales_store_id} ;;
    relationship: many_to_one
  }

  join: dim_label {
    view_label: "Label"
    sql_on: ${dim_label.label_id}=${fact_sales_market_share_joined_view.labelid} ;;
    relationship: many_to_one
  }
}