label: "ABACUS"
connection: "snowflake_via_lookerappadmin"
include: "*.view.lkml"

fiscal_month_offset: -9

# ## abacus accounting explore
# explore: int_dbt_prod_abacus_fact_sales {
#   label: "ABACUS: To be deprecated"
#   view_label: "Accounting"
#   case_sensitive: no
#   hidden: yes

#   join: facts_prod_dim_country {
#     view_label: "Transaction Country"
#     sql_on: ${int_dbt_prod_abacus_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: orch_app_ar_track {
#     view_label: "Track"
#     relationship: many_to_one
#     sql_on: ${orch_app_ar_track.isrc} = ${int_dbt_prod_abacus_fact_sales.isrc}
#     and ${orch_app_ar_track.upc} = ${int_dbt_prod_abacus_fact_sales.upc} ;;
#   }

#   join: orch_app_ar_releases {
#     view_label: "Release"
#     relationship: many_to_one
#     sql_on: ${orch_app_ar_track.upc} = ${orch_app_ar_releases.upc} ;;
#     fields: [
#       format,
#       release_date,
#       release_week,
#       release_name,
#       release_month,
#       release_year,
#       sale_start_date,
#       sale_start_week,
#       sale_start_month,
#       sale_start_year,
#       sale_start_month_num,
#       sale_start_month_name,
#       sale_start_fiscal_month_num,
#       sale_start_fiscal_quarter,
#       sale_start_fiscal_quarter_of_year,
#       sale_start_fiscal_year,
#       number_of_releases,
#       is_active,
#       display_upc,
#       product_code,
#       p_line,
#       c_line,
#       latest_release,
#       not_for_distribution,
#       ingestion_completed_date
#     ]
#   }

#   join: facts_prod_dim_release {
#     view_label: "Release"
#     sql_on: ${orch_app_ar_releases.upc} = ${facts_prod_dim_release.upc} ;;
#     relationship: one_to_one
#     fields: []
#   }

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

#   join: facts_prod_dim_artist {
#     sql_on: ${orch_app_ar_artist_info.artist_id} = ${facts_prod_dim_artist.artist_id} ;;
#     relationship: one_to_one
#     fields: []
#   }

#   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
#     fields: []
#   }

#   join: orch_app_ar_vendor {
#     view_label: "Label"
#     relationship: many_to_one
#     sql_on: ${orch_app_ar_artist_info.vendor_id} = ${orch_app_ar_vendor.vendor_id} ;;
#     fields: [orch_app_ar_vendor.label_name, orch_app_ar_vendor.owner, orch_app_ar_vendor.country,orch_app_ar_vendor.created_date,
#       orch_app_ar_vendor.language, orch_app_ar_vendor.priority, orch_app_ar_vendor.vendor_id, orch_app_ar_vendor.label_identifier]
#   }

#   join: facts_prod_dim_label {
#     sql_on: ${orch_app_ar_vendor.vendor_id} = ${facts_prod_dim_label.label_id} ;;
#     relationship: one_to_one
#     fields: []
#   }

#   join: orch_app_ar_vend_contact {
#     view_label: "Label Info"
#     sql_on: ${facts_prod_dim_label.label_id} = ${orch_app_ar_vend_contact.vendor_id} ;;
#     relationship:  one_to_one
#     fields: []
#   }

#   join: orch_app_ar_contact {
#     view_label: "Label Info"
#     sql_on: ${orch_app_ar_vend_contact.contact_id} = ${orch_app_ar_contact.contact_id} ;;
#     relationship: many_to_one
#     fields: []
#   }

#   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: 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_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} ;;
#     fields: []
#   }

#   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: quarterback_label_manager {
#     from: orch_app_ar_orchadmin_users
#     view_label: "Label"
#     relationship: many_to_one
#     sql_on: ${orch_app_ar_vendor.quarterback_label_manager} = ${quarterback_label_manager.id} ;;
#     fields: []
#   }

#   join: orch_app_ar_vendor_contract {
#     view_label: "Label Contract"
#     relationship: one_to_many
#     sql_on: ${orch_app_ar_vendor.vendor_id} = ${orch_app_ar_vendor_contract.vendor_id} ;;
#     fields: []
#   }

#   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: []
#   }

#   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} ;;
#     fields: []
#   }

#   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
#     fields: []
#   }

#   join: dt_label_is_physical {
#     sql_on:${facts_prod_dim_label.label_id} = ${dt_label_is_physical.vendor_id} ;;
#     relationship: one_to_one
#     fields: []
#   }

#   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: orch_app_ar_subaccount {
#     view_label: "Subaccount"
#     relationship: many_to_one
#     sql_on: ${orch_app_ar_releases.subaccount_id} = ${orch_app_ar_subaccount.subaccount_id}
#     and  ${orch_app_ar_vendor.vendor_id} = ${orch_app_ar_subaccount.vendor_id};;
#   }

#   join: facts_prod_dim_subaccount {
#     sql_on: ${orch_app_ar_subaccount.subaccount_id} = ${facts_prod_dim_subaccount.subaccountid} ;;
#     relationship: one_to_one
#     fields: []
#   }

#   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: payee_currency {
#     from: facts_prod_dim_currency
#     view_label: "Accounting"
#     sql_on: ${int_dbt_prod_abacus_fact_sales.account_payee_currency} = ${payee_currency.currency_code} ;;
#     relationship: many_to_one
#     fields: [currency_name]
#   }

#   join: sale_currency {
#     from: facts_prod_dim_currency
#     view_label: "Accounting"
#     sql_on: ${int_dbt_prod_abacus_fact_sales.sale_currency_code} = ${sale_currency.currency_code} ;;
#     relationship: many_to_one
#     fields: [currency_name]
#   }

#   join: facts_prod_dim_genre {
#     view_label: "Release"
#     sql_on: ${orch_app_ar_releases.release_genre_id} = ${facts_prod_dim_genre.genre_id} ;;
#     relationship: many_to_one
#     fields: []
#   }

#   join: accounting_period {
#     from: facts_prod_dim_period
#     view_label: "Date"
#     sql_on: ${int_dbt_prod_abacus_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: 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} ;;
#     fields: []
#   }

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


#   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} ;;
#     fields: []
#   }

#   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
#     fields: []
#   }

#   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_physical {
#     view_label: "Release"
#     sql_on: ${orch_app_ar_releases.release_id} = ${orch_app_ar_product_physical.release_id} ;;
#     relationship: one_to_one
#     fields: [orch_app_ar_product_physical.display_configuration]
#   }

#   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_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} ;;
#     fields: []
#   }

#   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} ;;
#     fields: []
#   }

#   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} ;;
#     fields: []
#   }

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

#   join: facts_prod_dim_track {
#     view_label: "Track"
#     sql_on: sql_on: ${orch_app_ar_track.tuid} = ${facts_prod_dim_track.track_unique_id};;
#     relationship: many_to_one
#     fields: []
#   }

#   join: dt_track_publishers {
#     relationship: one_to_one
#     sql_on: ${orch_app_ar_track.tuid} = ${dt_track_publishers.tuid} ;;
#     fields: []
#   }

#   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} ;;
#     fields: []
#   }

#   join: dt_isrc_registry {
#     view_label: "Track"
#     relationship: many_to_one
#     sql_on: ${orch_app_ar_track.isrc}=${dt_isrc_registry.isrc} ;;
#     fields: []
#   }

#   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: dt_track_artist_by_type {
#     view_label: "Track"
#     sql_on: ${dt_track_artist_by_type.tuid}=${orch_app_ar_track.tuid} ;;
#     relationship: one_to_one
#     fields: []
#   }

#   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} ;;
#     fields: []
#   }

#   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} ;;
#     fields: []

#   }

#   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
#     fields: []
#   }

#   join: dt_mechanical_clients {
#     view_label: "Label"
#     sql_on: ${facts_prod_dim_label.label_id} = ${dt_mechanical_clients.vendor_id};;
#     relationship: one_to_one
#     fields: []
#   }

#   join: dt_vendor_outstanding_balance {
#     view_label: "Label Accounting"
#     sql_on: ${dt_vendor_outstanding_balance.vendor_id} = ${facts_prod_dim_label.label_id}
#       and ${dt_vendor_outstanding_balance.period_id} = ${int_dbt_prod_abacus_fact_sales.accounting_period_id};;
#     relationship: many_to_one
#     fields: []
#   }


#   join: int_dbt_prod_product_manager_mapping_union {
#     sql_on: ${orch_app_ar_releases.display_upc} = ${int_dbt_prod_product_manager_mapping_union.upc} and ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_product_manager_mapping_union.label_id} ;;
#     relationship: many_to_one
#     view_label: "Product Manager"
#     fields: []
#   }

#   join: int_dbt_prod_awal_tier_groups {
#       view_label: "Orchard/AWAL Tiers"
#       relationship: many_to_one
#       sql_on: ${orch_app_ar_vendor.vendor_id} = ${int_dbt_prod_awal_tier_groups.label_id};;
#       fields: [brand_name,parent_company,service_tier_name, owner, is_distributor]
#   }

# }

# ## abacus adjustments explore
# explore: int_dbt_prod_abacus_adjustments {
#   label: "ABACUS Adjustments"
#   view_label: "Adjustments"
#   case_sensitive: no

#   join: int_dbt_prod_awal_tier_groups {
#     view_label: "Orchard/AWAL Tiers"
#     relationship: many_to_one
#     sql_on: ${int_dbt_prod_abacus_adjustments.account_id} = ${int_dbt_prod_awal_tier_groups.label_id};;
#     fields: [brand_name,parent_company,service_tier_name, owner, is_distributor]
#   }

# }

# ## abacus adjustments explore
# explore: int_dbt_prod_qa_abacus_adjustments {
#   label: "ABACUS QA Adjustments"
#   view_label: "QA Adjustments"
#   case_sensitive: no

#   join: int_dbt_prod_awal_tier_groups {
#     view_label: "Orchard/AWAL Tiers"
#     relationship: many_to_one
#     sql_on: ${int_dbt_prod_qa_abacus_adjustments.account_id} = ${int_dbt_prod_awal_tier_groups.label_id};;
#     fields: [brand_name,parent_company,service_tier_name, owner, is_distributor]
#   }

# }

# ## abacus adjustments explore
# explore: int_dbt_prod_abacus_expenses {
#   label: "ABACUS Expenses"
#   view_label: "Expenses"
#   case_sensitive: no

#   join: int_dbt_prod_awal_tier_groups {
#     view_label: "Orchard/AWAL Tiers"
#     relationship: many_to_one
#     sql_on: ${int_dbt_prod_abacus_expenses.account_id} = ${int_dbt_prod_awal_tier_groups.label_id};;
#     fields: [brand_name,parent_company,service_tier_name, owner, is_distributor]
#   }

# }

# ## abacus adjustments explore
# explore: int_dbt_prod_qa_abacus_expenses {
#   label: "ABACUS QA Expenses"
#   view_label: "QA Expenses"
#   case_sensitive: no

#   join: int_dbt_prod_awal_tier_groups {
#     view_label: "Orchard/AWAL Tiers"
#     relationship: many_to_one
#     sql_on: ${int_dbt_prod_qa_abacus_expenses.account_id} = ${int_dbt_prod_awal_tier_groups.label_id};;
#     fields: [brand_name,parent_company,service_tier_name, owner, is_distributor]
#   }

# }