label: "Data Squad - Store Availability"
connection: "datasquad-looker"
include: "dt_store_availability_analytics.view.lkml"
include: "dt_store_availability_tiktok.view.lkml"
include: "dt_store_availability_analytics_sme.view.lkml"
include: "dt_store_availability_shazam.view.lkml"
include: "prod_store_avail_store_avail_availability.view.lkml"
include: "orch_app_ar_artist_info.view.lkml"
include: "orch_app_ar_releases.view.lkml"
include: "orch_app_ar_vendor.view.lkml"
include: "facts_prod_dim_store.view.lkml"
include: "dt_store_availability_analytics_reduced.view.lkml"
include: "dt_store_availability_tiktok_reduced.view.lkml"

explore: dt_store_availability_analytics {
  label: "Store Availability: Analytics"
  hidden: yes
}

explore: dt_store_availability_tiktok {
  label: "Store Availability: TikTok"
  hidden: yes
}

explore: dt_store_availability_analytics_sme_updated {
  label: "Store Availability: SME Analytics"
  hidden: yes
}

explore: dt_store_availability_shazam {
  label: "Store Availability: Shazam"
  hidden: yes
}

explore: dt_store_availability_analytics_reduced {
  label: "Store Availability: Analytics"
  description: "The same dt_store_availability_analytics, but amended due to DS-5546."
  hidden: yes
}

explore: dt_store_availability_tiktok_reduced {
  label: "Store Availability: TikTok"
  description: "The same dt_store_availability_tiktok, but amended due to DS-5546."
  hidden: yes
}

explore: prod_store_avail_store_avail_availability {
  label: "Store Availability Links"
  view_label: "Store Availability"
  hidden: yes
  fields: [ALL_FIELDS*,
    -prod_store_avail_store_avail_availability.display_upc,
    -prod_store_avail_store_avail_availability.product_id,
    -prod_store_avail_store_avail_availability.store_id
  ]

  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${prod_store_avail_store_avail_availability.product_id} = ${orch_app_ar_releases.release_id} ;;
    relationship: many_to_one
    type: inner
    fields: [
      upc,
      display_upc,
      format,
      is_active,
      imprint_name,
      project_id,
      release_name,
      release_date,release_week,release_month,release_year,
      sale_start_date,sale_start_week,sale_start_month,sale_start_year,
      preorder_date,preorder_week,preorder_month,preorder_year,
      vendor_catalog_number,
      version
    ]
  }

  join: orch_app_ar_artist_info {
    view_label: "Artist"
    sql_on: ${orch_app_ar_releases.artist_id} = ${orch_app_ar_artist_info.artist_id} ;;
    relationship: many_to_one
    type: inner
  }

  join: orch_app_ar_vendor {
    view_label: "Label"
    sql_on: ${orch_app_ar_artist_info.vendor_id} = ${orch_app_ar_vendor.vendor_id} ;;
    relationship: many_to_one
    type: inner
    fields: [vendor_id,label_name,created_date,label_identifier,is_owned,priority,status,count_labels]
  }

  join: facts_prod_dim_store {
    view_label: "Store"
    sql_on: ${prod_store_avail_store_avail_availability.store_id} = ${facts_prod_dim_store.store_id} ;;
    relationship: many_to_one
    type: inner
    fields: [store_id, store_name, count_stores]
  }
}