label: "Core Models"
connection: "looker_high_performance"
include: "*.view.lkml"

fiscal_month_offset: -9

explore: facts_prod_fact_sales {
  label: "Accounting"
  view_label: "Accounting"
  case_sensitive: no

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

  join: dt_rolling_date_windows_accounting {
    view_label: "Date"
    sql_on: ${facts_prod_fact_sales.activity_period_id} = ${dt_rolling_date_windows_accounting.periodid} ;;
    type: inner
    relationship: many_to_one
  }

  join: facts_prod_dim_artist {
    view_label: "Artist"
    sql_on: ${facts_prod_fact_sales.artist_id} = ${facts_prod_dim_artist.artist_id} ;;
    relationship: many_to_one
  }

  join: artist_country {
    from: facts_prod_dim_country
    view_label: "Artist"
    sql_on: ${facts_prod_dim_artist.country_id} = ${artist_country.country_id} ;;
    relationship: many_to_one
    fields: [country_name]
  }

  join: artist_territory_group {
    from: int_prod_territory_grouping
    view_label: "Artist"
    sql_on: ${facts_prod_dim_artist.country_id} = ${artist_territory_group.countryid} ;;
    relationship: many_to_one
  }

  join: facts_prod_dim_country {
    view_label: "Transaction Country"
    sql_on: ${facts_prod_fact_sales.country_id} = ${facts_prod_dim_country.country_id} ;;
    relationship: many_to_one
    fields: [country_name, country_code, continent_name, us_vs_row]
  }

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

  join: payout_currency {
    from: facts_prod_dim_currency
    view_label: "Payout Currency"
    sql_on: ${facts_prod_fact_sales.payout_currency_id} = ${payout_currency.currency_id} ;;
    relationship: many_to_one
  }

  join: facts_prod_dim_genre {
    view_label: "Release"
    sql_on: ${facts_prod_fact_sales.genre_id} = ${facts_prod_dim_genre.genre_id} ;;
    relationship: many_to_one
  }

  join: facts_prod_dim_imprint {
    view_label: "Release"
    sql_on: ${facts_prod_fact_sales.imprint_id} = ${facts_prod_dim_imprint.imprint_id} ;;
    relationship: many_to_one
  }

  join: facts_prod_dim_label {
    view_label: "Label"
    sql_on: ${facts_prod_fact_sales.label_id} = ${facts_prod_dim_label.label_id} ;;
    relationship: many_to_one
  }

  join: dt_has_local_carveout {
    view_label: "Label"
    sql_on:${facts_prod_dim_label.label_id} = ${dt_has_local_carveout.vendor_id} ;;
    relationship: one_to_one
  }

  join: dt_label_is_physical {
    sql_on:${facts_prod_dim_label.label_id} = ${dt_label_is_physical.vendor_id} ;;
    relationship: one_to_one
    }

  join: int_prod_vw_restrictions_label_territory {
    view_label: "Label"
    sql_on:${facts_prod_dim_label.label_id}=${int_prod_vw_restrictions_label_territory.label_id};;
    relationship:one_to_many
  }

  join: int_prod_vw_restrictions_label_store {
    view_label: "Label"
    sql_on:${facts_prod_dim_label.label_id}=${int_prod_vw_restrictions_label_store.label_id};;
    relationship:one_to_many
  }

  join: int_prod_vw_restrictions_label_substore {
    view_label: "Label"
    sql_on:${facts_prod_dim_label.label_id}=${int_prod_vw_restrictions_label_substore.label_id};;
    relationship:one_to_many
  }

 join: facts_prod_dim_subaccount {
    view_label: "Subaccount"
    sql_on: ${facts_prod_fact_sales.subaccount_id}=${facts_prod_dim_subaccount.subaccountid} ;;
    relationship: many_to_one
  }

  join: subaccount_country {
    from: facts_prod_dim_country
    view_label: "Subaccount"
    sql_on: ${facts_prod_dim_subaccount.country_id} = ${subaccount_country.country_id} ;;
    relationship: many_to_one
    fields: [country_name]
  }

  join: int_prod_vw_restrictions_subaccount_store {
    view_label: "Subaccount"
    sql_on: ${facts_prod_dim_subaccount.subaccountid} = ${int_prod_vw_restrictions_subaccount_store.subaccount_id} ;;
    relationship: one_to_many
  }

  join: int_prod_vw_restrictions_subaccount_substore {
    view_label: "Subaccount"
    sql_on: ${facts_prod_dim_subaccount.subaccountid} = ${int_prod_vw_restrictions_subaccount_substore.subaccount_id} ;;
    relationship: one_to_many
  }

  join: int_prod_vw_restrictions_subaccount_territory {
    view_label: "Subaccount"
    sql_on: ${facts_prod_dim_subaccount.subaccountid} = ${int_prod_vw_restrictions_subaccount_territory.subaccount_id} ;;
    relationship: one_to_many
  }

  join: label_country {
    from: facts_prod_dim_country
    view_label: "Label"
    sql_on: ${facts_prod_dim_label.country_id} = ${label_country.country_id} ;;
    relationship: many_to_one
    fields: [country_name,continent_name]
  }

  join: label_territory_group {
    from: int_prod_territory_grouping
    view_label: "Label"
    sql_on: ${orch_app_ar_vendor.country} = ${label_territory_group.countryid} ;;
    relationship: many_to_one
  }

  join: dt_label_size {
    relationship: one_to_one
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${dt_label_size.labelid} ;;
  }

#  join: dt_country_gross_revenue_rank {
#    relationship:one_to_one
#    sql_on: ${facts_prod_dim_country.countryid} = ${dt_country_gross_revenue.countrid} ;;
#  }

  join: dt_country_gross_revenue_rank {
    relationship: one_to_one
    sql_on: ${facts_prod_dim_country.country_id} = ${dt_country_gross_revenue_rank.country_id};;
  }

  join: int_prod_vw_deleted_labels {
    relationship: one_to_one
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_prod_vw_deleted_labels.label_id} ;;
  }

  join: orch_app_ar_vendor {
    view_label: "Label"
    relationship: one_to_one
    sql_on: ${facts_prod_dim_label.label_id} = ${orch_app_ar_vendor.vendor_id} ;;
    fields: [label_identifier,is_owned]
  }

  join: dt_perf_rights_territory_label {
    sql_on: ${orch_app_ar_vendor.vendor_id} = ${dt_perf_rights_territory_label.vendor_id} ;;
    relationship:one_to_one
  }

  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_genre {
    from: orch_app_ar_genre
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${orch_app_ar_vendor.genre} = ${label_genre.genre_id} ;;
    type: left_outer
  }

#  join: active_label {
#    from: int_prod_vw_active_vendor_contract
#    relationship: one_to_one
#    sql_on: ${orch_app_ar_vendor.vendor_id} = ${active_label.vendor_id} and ${orch_app_ar_vendor_contract.id} = ${active_label.vendor_contract_id} ;;
#    fields: [active_label]
#  }

  join: label_manager {
    from: orch_app_ar_orchadmin_users
    view_label: "Label"
    relationship: many_to_one
    sql_on: ${orch_app_ar_vendor.assigned_to} = ${label_manager.id} ;;
  }

  join: orch_app_ar_vendor_contract {
    view_label: "Label Contract"
    relationship: one_to_many
    sql_on: ${facts_prod_fact_sales.label_id} = ${orch_app_ar_vendor_contract.vendor_id} ;;
    fields: [cont_start, cont_end, has_sync_rights, sync_commission_split]
  }

  join: active_contract {
    from: int_prod_vw_active_vendor_contract
    relationship: one_to_one
    sql_on: ${orch_app_ar_vendor_contract.id} = ${active_contract.vendor_contract_id} ;;
    fields: [active_contract]
  }

  join: closer {
    from: orch_app_ar_orchadmin_users
    view_label: "Label Contract"
    relationship: many_to_one
    sql_on: ${orch_app_ar_vendor_contract.orchrep_name} = ${closer.id} ;;
  }

  join: accounting_period {
    from: facts_prod_dim_period
    view_label: "Date"
    sql_on: ${facts_prod_fact_sales.accounting_period_id} = ${accounting_period.period_id} ;;
    relationship: many_to_one
    fields: [
      accounting_date,
      accounting_month,
      accounting_month_num,
      accounting_month_name,
      accounting_quarter,
      accounting_quarter_of_year,
      accounting_year,
      accounting_fiscal_month_num,
      accounting_fiscal_quarter,
      accounting_fiscal_quarter_of_year,
      accounting_fiscal_year
    ]
  }

  join: activity_period {
    from: facts_prod_dim_period
    view_label: "Date"
    sql_on: ${facts_prod_fact_sales.activity_period_id} = ${activity_period.period_id} ;;
    relationship: many_to_one
    fields: [
      activity_date,
      activity_month,
      activity_month_num,
      activity_month_name,
      activity_quarter,
      activity_quarter_of_year,
      activity_year,
      activity_fiscal_month_num,
      activity_fiscal_quarter,
      activity_fiscal_quarter_of_year,
      activity_fiscal_year
    ]
  }

  join: facts_prod_dim_release {
    view_label: "Release"
    sql_on: ${facts_prod_fact_sales.release_id} = ${facts_prod_dim_release.upc} ;;
    relationship: many_to_one
  }

  join: orch_app_ar_releases {
    view_label: "Release"
    relationship: one_to_one
    sql_on: ${facts_prod_dim_release.product_id} = ${orch_app_ar_releases.release_id} ;;
    fields: [
      format,
      vendor_catalog_number,
      release_date,
      release_week,
      release_month,
      release_year,
      sale_start_date,
      sale_start_week,
      sale_start_month,
      sale_start_year,
      number_of_releases,
      is_active,
      display_upc,
      product_code,
      p_line,
      c_line
    ]
  }

  join: dt_bits_per_sample {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${dt_bits_per_sample.upc} ;;
    relationship: one_to_one
  }


  join: int_prod_vw_deleted_releases {
    view_label: "Release"
    relationship: one_to_one
    sql_on: ${orch_app_ar_releases.upc} = ${int_prod_vw_deleted_releases.upc} ;;
  }

  join: int_prod_vw_restrictions_release_store {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.release_id} = ${int_prod_vw_restrictions_release_store.release_id} ;;
    relationship: one_to_many
  }

  join: int_prod_vw_restrictions_release_substore {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.release_id} = ${int_prod_vw_restrictions_release_substore.release_id} ;;
    relationship: one_to_many
  }

  join: int_prod_vw_restrictions_release_territory {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.release_id} = ${int_prod_vw_restrictions_release_territory.release_id} ;;
    relationship: one_to_many
  }

  join: int_prod_vw_bits_per_sample {
    view_label: "Release"
    sql_on: ${orch_app_ar_releases.upc}=${int_prod_vw_bits_per_sample.upc} ;;
    relationship: one_to_one
  }

  join: orch_app_ar_release_subgenre {
    relationship: one_to_one
    sql_on: ${orch_app_ar_releases.release_id} = ${orch_app_ar_release_subgenre.release_id} ;;
    fields: []
  }

  join: orch_app_ar_subgenre {
    view_label: "Release"
    relationship: many_to_one
    sql_on: ${orch_app_ar_release_subgenre.subgenre_id} = ${orch_app_ar_subgenre.subgenre_id} ;;
  }

  join: orch_app_ar_product_type {
    view_label: "Release"
    sql_on: ${facts_prod_dim_release.product_type_id} = ${orch_app_ar_product_type.product_type_id} ;;
    relationship: many_to_one
  }

  join: orch_app_ar_distribution_format {
    view_label: "Release"
    relationship: many_to_one
    sql_on: ${orch_app_ar_releases.distribution_format_id} = ${orch_app_ar_distribution_format.distribution_format_id} ;;
  }



  join: orch_app_ar_project {
    view_label: "Project"
    relationship: many_to_one
    sql_on: ${orch_app_ar_releases.project_id} = ${orch_app_ar_project.project_id} ;;
  }

  join: orch_app_ar_mkt_priority {
    view_label: "Marketing Information"
    relationship: one_to_many
    sql_on: ${orch_app_ar_releases.release_id} = ${orch_app_ar_mkt_priority.release_id} ;;
  }

  join: market_country {
    from: dt_flatten_country_region
    view_label: "Marketing Information"
    relationship: many_to_one
    sql_on: ${orch_app_ar_mkt_priority.country_id} = ${market_country.country_region_id} ;;
  }

  join: dt_flatten_marketing_info {
    view_label: "Marketing Information"
    relationship: one_to_one
    sql_on: ${orch_app_ar_releases.release_id} = ${dt_flatten_marketing_info.release_id} ;;
  }

  join: facts_prod_dim_store {
    view_label: "Store"
    sql_on: ${facts_prod_fact_sales.store_id} = ${facts_prod_dim_store.store_id} ;;
    relationship: many_to_one
  }

  join: facts_prod_dim_track {
    view_label: "Track"
    sql_on: ${facts_prod_fact_sales.track_id} = ${facts_prod_dim_track.track_id} ;;
    relationship: many_to_one
    fields: [isrc_ex_da, track_name_ex_da]
  }

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

  join: orch_app_ar_language {
    view_label: "Track"
    relationship: many_to_one
    sql_on: ${orch_app_ar_track.meta_language}=${orch_app_ar_language.language_code} ;;
    fields: [language]
    }

  join: facts_prod_registry {
    view_label: "Track"
    relationship: one_to_many
    sql_on: ${orch_app_ar_track.tuid} = ${facts_prod_registry.tuid} ;;
  }

  join: int_prod_vw_track_artists {
    view_label: "Track"
    relationship: one_to_many
    sql_on: ${orch_app_ar_track.tuid} = ${int_prod_vw_track_artists.track_id} ;;
  }

  join: facts_prod_dim_transactiontype {
    view_label: "Transaction Type"
    sql_on: ${facts_prod_fact_sales.transaction_type_id} = ${facts_prod_dim_transactiontype.transaction_type_id} ;;
    relationship: many_to_one
  }

  join: int_prod_transaction_type_group {
    view_label: "Transaction Type"
    relationship: one_to_one
    sql_on: ${facts_prod_dim_transactiontype.transaction_type_id} = ${int_prod_transaction_type_group.transactiontypeid} ;;
  }

  join: dt_max_accountingperiodid {
    type: cross
    relationship: many_to_one
  }

  join: int_prod_vw_release_delivery_history {
    view_label: "Release"
    relationship: one_to_one
    sql_on: ${orch_app_ar_releases.upc} = ${int_prod_vw_release_delivery_history.upc} ;;
    type: inner
  }

  join: int_dev_smoore_o_o {
    view_label: "Accounting"
    relationship:  one_to_one
    sql_on: ${facts_prod_dim_track.isrc} = ${int_dev_smoore_o_o.isrc}
    AND ${facts_prod_dim_track.upc} = ${int_dev_smoore_o_o.upc};;
  }

  join: orch_app_sm_field_manager {
    view_label: "GRAS Registration"
    relationship:  many_to_one
    sql_on: zeroifnull(${facts_prod_fact_sales.subaccount_id}) = zeroifnull(${orch_app_sm_field_manager.subaccount_id})
    and ${facts_prod_fact_sales.label_id} = ${orch_app_sm_field_manager.vendor_id};;
  }

  join: orch_app_ar_service_type {
    view_label: "Label Contract"
    relationship: many_to_one
    sql_on: ${orch_app_ar_vendor_contract.service_type_id} = ${orch_app_ar_service_type.id} ;;
  }

  join: orch_app_ph_vendor_payment_hold {
    view_label: "Vendor Payment Hold"
    sql_on: ${facts_prod_dim_label.label_id} = ${orch_app_ph_vendor_payment_hold.vendor_id} ;;
    relationship:  one_to_one
  }
}