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

include: "/views/royalty_accounting_prod_vw_contract_denormalized.view.lkml"
include: "/views/royalty_accounting_prod_vw_dim_abacus_contract.view.lkml"
include: "/views/royalty_accounting_prod_vw_dim_abacus_account.view.lkml"
include: "/views/orch_app_ar_royalty_accounting_run_controller.view.lkml"
include: "/views/facts_prod_dim_release.view.lkml"
include: "/views/facts_prod_dim_country.view.lkml"
include: "/views/facts_prod_dim_store.view.lkml"
include: "/views/facts_prod_dim_transactiontype.view.lkml"
include: "/views/facts_prod_dim_track_clean_mv.view.lkml"
include: "/views/facts_prod_dim_label.view.lkml"
include: "/views/orch_app_ar_royalty_accounting_contract_term.view.lkml"
include: "/views/orch_app_ar_royalty_accounting_contract_term_condition.view.lkml"
include: "/views/facts_prod_identity.view.lkml"
include: "/views/dt_abacus_contract_lifecycle_prod.view.lkml"

fiscal_month_offset: -9

explore: royalty_accounting_prod_vw_contract_denormalized {
  label: "ABACUS Contract Denormalized"
  view_label: "Contract Denormalized"
  case_sensitive: no
  hidden: yes

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

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

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

  join: orch_app_ar_royalty_accounting_run_controller {
    view_label: "Run Controller"
    relationship: many_to_one
    sql_on: ${royalty_accounting_prod_vw_contract_denormalized.run_controller_id}= ${orch_app_ar_royalty_accounting_run_controller.run_controller_id};;

  }

  join: facts_prod_dim_release {
    view_label: "Products by Label Contract Term"
    relationship: many_to_one
    sql_on: ${royalty_accounting_prod_vw_contract_denormalized.term_label_id}= ${facts_prod_dim_release.label_id};;
    fields: [compilation, project_id, release_name, product_id, upc]
  }

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

  join: facts_prod_dim_store {
    view_label: "Contract Term Condition Store"
    sql_on: ${royalty_accounting_prod_vw_contract_denormalized.store_id} = ${facts_prod_dim_store.store_id} ;;
    relationship: many_to_one
    fields: [store_name]
  }

  join: facts_prod_dim_transactiontype {
    view_label: "Contract Term Condition Transaction"
    sql_on: ${royalty_accounting_prod_vw_contract_denormalized.transaction_type_id} = ${facts_prod_dim_transactiontype.transaction_type_id} ;;
    relationship: many_to_one
    fields: [facts_prod_dim_transactiontype.description, facts_prod_dim_transactiontype.transaction_premium_free,
      facts_prod_dim_transactiontype.transaction_type_group, facts_prod_dim_transactiontype.transaction_type_id, facts_prod_dim_transactiontype.abbreviation]
  }

  join: dim_track_by_isrc{
    from: facts_prod_dim_track_clean_mv
    view_label: "Tracks by ISRC Contract Term"
    sql_on: ${royalty_accounting_prod_vw_contract_denormalized.term_isrc}=${dim_track_by_isrc.isrc}
      and ${royalty_accounting_prod_vw_contract_denormalized.term_upc}=${dim_track_by_isrc.upc} ;;
    relationship: many_to_one
  }

  join: dim_track_by_product{
    from: facts_prod_dim_track_clean_mv
    view_label: "Tracks by Product Contract Term"
    sql_on: ${royalty_accounting_prod_vw_contract_denormalized.term_label_id}=${dim_track_by_product.labelid}
      and ${royalty_accounting_prod_vw_contract_denormalized.term_upc}=${dim_track_by_product.upc}
      AND ${royalty_accounting_prod_vw_contract_denormalized.term_isrc} is NULL
      AND ${royalty_accounting_prod_vw_contract_denormalized.term_type}='product';;
    relationship: many_to_one
  }

  join: dim_track_by_label{
    from: facts_prod_dim_track_clean_mv
    view_label: "Tracks by Label Contract Term"
    sql_on: ${royalty_accounting_prod_vw_contract_denormalized.term_label_id}=${dim_track_by_label.labelid}
    and ${royalty_accounting_prod_vw_contract_denormalized.term_type}='label'
    AND ${royalty_accounting_prod_vw_contract_denormalized.term_upc} is NULL
    AND ${royalty_accounting_prod_vw_contract_denormalized.term_isrc} is NULL;;
    relationship: many_to_one
  }

  join: facts_prod_dim_label {
    view_label: "Contract Term OA Label"
    sql_on: ${facts_prod_dim_label.label_id}=${facts_prod_dim_release.label_id} ;;
    relationship: many_to_one
    fields: [label_name, label_id]
  }

  join: orch_app_ar_royalty_accounting_contract_term {
    view_label: "Contract Term"
    relationship: many_to_one
    sql_on: ${royalty_accounting_prod_vw_contract_denormalized.contract_term_id}= ${orch_app_ar_royalty_accounting_contract_term.contract_term_id};;
    fields: [last_modified_by, last_modified, created_by, created_at, deleted_by, deleted_at, is_base_term ]
  }

  join: orch_app_ar_royalty_accounting_contract_term_condition {
    view_label: "Contract Term Condition"
    relationship: many_to_one
    sql_on: ${royalty_accounting_prod_vw_contract_denormalized.contract_term_condition_id}= ${orch_app_ar_royalty_accounting_contract_term_condition.contract_term_condition_id};;
    fields: [last_modified_by, last_modified, created_by, created_at, deleted_by, deleted_at]
  }

  join: facts_prod_identity {
    view_label: "Contract Term"
    relationship: many_to_one
    sql_on: ${orch_app_ar_royalty_accounting_contract_term.last_modified_by}= ${facts_prod_identity.id};;
    fields: [name, email]
  }

  join: facts_prod_identity_term_created {
    view_label: "Contract Term Created By Name"
    from:  facts_prod_identity
    type: left_outer
    relationship: many_to_one
    sql_on: ${orch_app_ar_royalty_accounting_contract_term.created_by}= ${facts_prod_identity_term_created.id};;
    fields: [name, email]
  }

}