label: "ABACUS"
connection: "abacus-looker"

include: "/views/dt_abacus_orphaned_products_wo_contract_qa.view.lkml"
include: "/views/royalty_accounting_qa_vw_dim_abacus_account.view.lkml"
include: "/views/royalty_accounting_qa_vw_dim_abacus_contract.view.lkml"
include: "/views/int_dbt_prod_awal_tier_groups.view.lkml"
include: "/views/int_dbt_prod_abacus_awal_client_segments.view.lkml"
include: "/views/facts_prod_dim_artist.view.lkml"
include: "/views/dt_abacus_orphaned_products_existing_contracts_qa.view.lkml"
include: "/views/orch_app_ar_royalty_accounting_contract_term.view.lkml"
include: "/views/dt_abacus_orphaned_products_wo_contract_prod.view.lkml"
include: "/views/dt_abacus_orphaned_products_existing_contracts_prod.view.lkml"
include: "/views/royalty_accounting_prod_vw_dim_abacus_account.view.lkml"
include: "/views/royalty_accounting_prod_vw_dim_abacus_contract.view.lkml"

fiscal_month_offset: -9

explore: dt_abacus_orphaned_products_wo_contract_qa {
  label: "ABACUS Orphaned Products With No Contract QA"
  view_label: "ABACUS Orphaned Products QA"
  case_sensitive: no
  hidden: yes

  join: royalty_accounting_qa_vw_dim_abacus_account {
    view_label: "ABACUS Account"
    sql_on: ${dt_abacus_orphaned_products_wo_contract_qa.account_id}=${royalty_accounting_qa_vw_dim_abacus_account.account_id} ;;
    relationship: many_to_one
  }

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


  join: int_dbt_prod_abacus_awal_client_segments {
    view_label: "Client Segments"
    relationship: many_to_one
    sql_on: ${dt_abacus_orphaned_products_wo_contract_qa.account_id}= ${int_dbt_prod_abacus_awal_client_segments.account_id};;
  }

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




explore: dt_abacus_orphaned_products_existing_contracts_qa {
  label: "ABACUS Orphaned Products QA"
  view_label: "ABACUS Orphaned Products QA"
  case_sensitive: no
  hidden: yes

  join: royalty_accounting_qa_vw_dim_abacus_account {
    view_label: "ABACUS Account"
    sql_on: ${dt_abacus_orphaned_products_existing_contracts_qa.account_id}=${royalty_accounting_qa_vw_dim_abacus_account.account_id} ;;
    relationship: many_to_one
  }

  join: royalty_accounting_qa_vw_dim_abacus_contract {
    view_label: "ABACUS Contract"
    sql_on: ${dt_abacus_orphaned_products_existing_contracts_qa.contract_id}=${royalty_accounting_qa_vw_dim_abacus_contract.contract_id} ;;
    relationship: many_to_one
  }

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

  join: int_dbt_prod_abacus_awal_client_segments {
    view_label: "Client Segments"
    relationship: many_to_one
    sql_on: ${dt_abacus_orphaned_products_existing_contracts_qa.account_id}= ${int_dbt_prod_abacus_awal_client_segments.account_id};;
  }

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

  join: orch_app_ar_royalty_accounting_contract_term {
    view_label: "Contract Term"
    relationship: many_to_one
    sql_on: ${dt_abacus_orphaned_products_existing_contracts_qa.contract_id}= ${orch_app_ar_royalty_accounting_contract_term.contract_id};;
  }
}


explore: dt_abacus_orphaned_products_wo_contract_prod {
  label: "ABACUS Orphaned Products With No Contract Prod"
  view_label: "ABACUS Orphaned Products Prod"
  case_sensitive: no
  hidden: yes

  join: royalty_accounting_prod_vw_dim_abacus_account {
    view_label: "ABACUS Account"
    sql_on: ${dt_abacus_orphaned_products_wo_contract_prod.account_id}=${royalty_accounting_prod_vw_dim_abacus_account.account_id} ;;
    relationship: many_to_one
  }

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


  join: int_dbt_prod_abacus_awal_client_segments {
    view_label: "Client Segments"
    relationship: many_to_one
    sql_on: ${dt_abacus_orphaned_products_wo_contract_prod.account_id}= ${int_dbt_prod_abacus_awal_client_segments.account_id};;
  }

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




explore: dt_abacus_orphaned_products_existing_contracts_prod {
  label: "ABACUS Orphaned Products Prod"
  view_label: "ABACUS Orphaned Products Prod"
  case_sensitive: no
  hidden: yes

  join: royalty_accounting_prod_vw_dim_abacus_account {
    view_label: "ABACUS Account"
    sql_on: ${dt_abacus_orphaned_products_existing_contracts_prod.account_id}=${royalty_accounting_prod_vw_dim_abacus_account.account_id} ;;
    relationship: many_to_one
  }

  join: royalty_accounting_prod_vw_dim_abacus_contract {
    view_label: "ABACUS Contract"
    sql_on: ${dt_abacus_orphaned_products_existing_contracts_prod.contract_id}=${royalty_accounting_prod_vw_dim_abacus_contract.contract_id} ;;
    relationship: many_to_one
  }

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

  join: int_dbt_prod_abacus_awal_client_segments {
    view_label: "Client Segments"
    relationship: many_to_one
    sql_on: ${dt_abacus_orphaned_products_existing_contracts_prod.account_id}= ${int_dbt_prod_abacus_awal_client_segments.account_id};;
  }

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

  join: orch_app_ar_royalty_accounting_contract_term {
    view_label: "Contract Term"
    relationship: many_to_one
    sql_on: ${dt_abacus_orphaned_products_existing_contracts_prod.contract_id}= ${orch_app_ar_royalty_accounting_contract_term.contract_id};;
  }
}