connection: "looker_high_performance"

include: "*.view.lkml"         # include all views in this project
# include: "*.dashboard.lookml"  # include all dashboards in this project

label: "Basic Models"

explore: fact_sales_market_share_joined_view {
  label: "Market Share"

  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
  }
}

explore: facts_prod_fact_market_share {
    label: "Market Share (New)"
    hidden: no
    fields: [
      ALL_FIELDS*,
      -facts_prod_fact_market_share.country_code
    ]
    case_sensitive: no

    join: facts_prod_dim_country {
      view_label: "Country"
      sql_on: ${facts_prod_fact_market_share.country_code} = ${facts_prod_dim_country.country_code} ;;
      relationship: many_to_one
    }

    join: int_prod_territory_grouping {
      view_label: "Country"
      sql_on:${facts_prod_dim_country.country_id}=${int_prod_territory_grouping.countryid} ;;
      relationship: many_to_one
    }


    join: dt_rolling_date_windows_market_share {
      view_label: "Date"
      sql_on: ${facts_prod_fact_market_share.activity_month544_month} = ${dt_rolling_date_windows_market_share.period} ;;
      relationship: many_to_one
      type: inner
    }

  }