connection: "snowflake_via_lookerappadmin"
label: "Weekly Streaming Overview"

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



explore: int_prod_streaming_totals_last_sales_week{
  hidden: yes
  label: "Weekly Sales Analytics"
  view_label: "Sales Analytics"
  join: orch_app_ar_vendor {
    relationship: many_to_one
    view_label: "Label"
    sql_on: ${int_prod_streaming_totals_last_sales_week.labelid} = ${orch_app_ar_vendor.vendor_id} ;;
  }

  join: orch_app_ar_artist_info {
    relationship: many_to_one
    view_label: "Artist"
    sql_on: ${int_prod_streaming_totals_last_sales_week.artistid} = ${orch_app_ar_artist_info.artist_id} ;;
  }

  join: orch_app_ar_releases {
    relationship: many_to_one
    view_label: "Release"
    sql_on: ${int_prod_streaming_totals_last_sales_week.releaseid}=${orch_app_ar_releases.upc} ;;
  }

  join: orch_app_ar_genre {
    view_label: "Release"
    sql_on: ${orch_app_ar_genre.genre_id}=${orch_app_ar_releases.release_genre_id} ;;
    relationship: one_to_many
  }

  join: facts_prod_dim_track {
    relationship: many_to_one
    view_label: "Track"
    sql_on: ${int_prod_streaming_totals_last_sales_week.trackid}=${facts_prod_dim_track.track_id} ;;
  }

  join: orch_app_ar_track {
    relationship: one_to_one
    view_label: "Track"
    sql_on: ${facts_prod_dim_track.track_unique_id}=${orch_app_ar_track.tuid} ;;
  }

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

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

  join: orch_app_ar_owner {
    view_label: "Owner"
    relationship: many_to_one
    sql_on: ${orch_app_ar_vendor.owner} = ${orch_app_ar_owner.owner_abbreviation} ;;
  }

  join: label_country {
    from: orch_app_ar_country
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${orch_app_ar_vendor.country} = ${label_country.id} ;;
    fields: [name]
  }
}

explore: int_prod_streaming_totals_last_sales_week_isrc_level{
  hidden: yes
  label: "Weekly Sales Analytics-ISRC Level"
  view_label: "Sales Analytics"


  join: orch_app_ar_vendor {
    relationship: many_to_one
    view_label: "Label"
    sql_on: ${int_prod_streaming_totals_last_sales_week_isrc_level.labelid} = ${orch_app_ar_vendor.vendor_id} ;;
  }

  join: orch_app_ar_artist_info {
    relationship: many_to_one
    view_label: "Artist"
    sql_on: ${int_prod_streaming_totals_last_sales_week_isrc_level.artistid} = ${orch_app_ar_artist_info.artist_id} ;;
  }


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

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

  join: orch_app_ar_owner {
    view_label: "Owner"
    relationship: many_to_one
    sql_on: ${orch_app_ar_vendor.owner} = ${orch_app_ar_owner.owner_abbreviation} ;;
  }

  join: label_country {
    from: orch_app_ar_country
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${orch_app_ar_vendor.country} = ${label_country.id} ;;
    fields: [name]
  }
}