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

include: "/views/royalty_accounting_prod_vw_contract_history.view.lkml"
include: "/views/royalty_accounting_prod_vw_contract_term_history.view.lkml"
include: "/views/royalty_accounting_prod_vw_contract_term_condition_history.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_payment_hold.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/royalty_accounting_prod_vw_fact_contract_history.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_fact_contract_history {
  label: "ABACUS Fact Contract History"
  view_label: "ABACUS Fact Contract History"
  case_sensitive: no
  hidden: yes

  join: facts_prod_identity {
    view_label: "Last Modified By Name"
    relationship: many_to_one
    sql_on: ${royalty_accounting_prod_vw_fact_contract_history.last_modified_by_combined}= ${facts_prod_identity.id};;
    fields: [name, email]
  }

  join: royalty_accounting_prod_vw_dim_abacus_contract {
    view_label: "ABACUS Contract Term History"
    relationship: many_to_one
    sql_on: ${royalty_accounting_prod_vw_dim_abacus_contract.contract_id}= ${royalty_accounting_prod_vw_fact_contract_history.contract_id};;
    fields: [contract_type]
  }

  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};;
  }

}