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

include: "/views/royalty_accounting_prod_vw_dim_abacus_contract.view.lkml"
include: "/views/royalty_accounting_prod_vw_dim_abacus_account.view.lkml"
include: "/views/dt_abacus_tap_advances.view.lkml"
include: "/views/orch_app_ar_royalty_accounting_run_controller.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/dt_abacus_contract_lifecycle_prod.view.lkml"
include: "/views/royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales.view.lkml"
include: "/views/facts_prod_identity.view.lkml"
include: "/views/orch_app_ar_vendor_closer.view.lkml"
include: "/views/orch_app_ar_orchadmin_users.view.lkml"
include: "/views/facts_prod_dim_label.view.lkml"
include: "/views/facts_prod_dim_country.view.lkml"

fiscal_month_offset: -9

explore: dt_abacus_tap_advances {
  label: "ABACUS TAP Advances"
  view_label: "ABACUS TAP Advances"
  case_sensitive: no
  hidden: yes

  join: royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales {
    view_label: "ABACUS Contract"
    relationship: many_to_one
    sql_on:  TRY_TO_NUMBER(${royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales.contract_id})=  ${dt_abacus_tap_advances.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_abacus_fact_sales.contract_id};;
  }

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

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

  }

  join: facts_prod_identity {
    view_label: "Advances Created By"
    relationship: many_to_one
    sql_on: ${dt_abacus_tap_advances.created_by}= ${facts_prod_identity.id};;
    fields: [name , email]
  }

  join: orch_app_ar_vendor_closer {
    view_label: "ABACUS Contract"
    sql_on: ${royalty_accounting_prod_vw_dim_abacus_account.account_id} = ${orch_app_ar_vendor_closer.vendor_id};;
    relationship: many_to_many
    fields: []
  }

  join: closer {
    from: orch_app_ar_orchadmin_users
    view_label: "ABACUS Contract"
    sql_on: ${orch_app_ar_vendor_closer.orchadmin_user_id} = ${closer.id};;
    relationship: many_to_many
    fields: [orchadmin_user, email, closer_list]
  }

  join: facts_prod_dim_label {
    view_label: "OA Label"
    sql_on: ${orch_app_ar_vendor_closer.vendor_id} = ${facts_prod_dim_label.label_id} ;;
    relationship: many_to_one
    fields: []
  }

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


}