label: "KNR Models"
connection: "knr-looker"

# =========================================================================
# INCLUDES: Local Salesforce & Contributor Views
# =========================================================================
include: "/views/performer_salesforce_society.view.lkml"
include: "/views/performer_salesforce_contributor.view.lkml"
include: "/views/nr_contributor.view.lkml"

# =========================================================================
# INCLUDES: Imported Abacus Views via Manifest Dependency
# =========================================================================
include: "//abacus-looker/**/*.view.lkml"

fiscal_month_offset: -9

# =========================================================================
# EXPLORE: ABACUS FACT SALES WITH SALESFORCE PERFORMERS
# =========================================================================
explore: vw_abacus_fact_sales_nr {
  label: "ABACUS Fact Sales NR Performer - Salesforce Join"
  view_label: "Fact Sales NR"
  case_sensitive: no
  hidden: no

  # -----------------------------------------------------------------------
  # Native Abacus Joins
  # -----------------------------------------------------------------------
  join: facts_prod_dim_country {
    view_label: "Transaction Country"
    sql_on: ${vw_abacus_fact_sales_nr.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: "Store"
    sql_on: ${vw_abacus_fact_sales_nr.store_id} = ${facts_prod_dim_store.store_id} ;;
    relationship: many_to_one
    fields: [store_name]
  }

  join: facts_prod_dim_transactiontype {
    view_label: "Transaction"
    sql_on: ${vw_abacus_fact_sales_nr.transaction_type} = ${facts_prod_dim_transactiontype.abbreviation} ;;
    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
    ]
  }

  join: orch_app_ar_royalty_statement_period {
    view_label: "Statement Period"
    sql_on: ${vw_abacus_fact_sales_nr.statement_period_id} = ${orch_app_ar_royalty_statement_period.statement_period_id} ;;
    relationship: many_to_one
    fields: [
      statement_year,
      statement_quarter,
      statement_month,
      statement_month_num,
      statement_month_name,
      statement_period_status,
      statement_period_name,
      closed_date_date,
      closed_date_year,
      closed_date_quarter,
      closed_date_month,
      closed_date_month_name,
      closed_date_month_num,
      closed_date_week,
      closed_date_week_of_year,
      closed_date_fiscal_year,
      closed_date_fiscal_quarter,
      closed_date_fiscal_quarter_of_year,
      closed_date_fiscal_month_num
    ]
  }

  join: orch_app_ar_royalty_accounting_period {
    view_label: "Accounting"
    sql_on: ${vw_abacus_fact_sales_nr.accounting_period_id} = ${orch_app_ar_royalty_accounting_period.accounting_period_id} ;;
    relationship: many_to_one
    fields: [
      closed_date_date,
      closed_date_year,
      closed_date_quarter,
      closed_date_month,
      closed_date_month_name,
      closed_date_month_num,
      closed_date_week,
      closed_date_fiscal_year,
      closed_date_fiscal_month_num,
      closed_date_fiscal_quarter,
      closed_date_fiscal_quarter_of_year,
      accounting_period_name,
      accounting_period_status
    ]
  }

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

  join: royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales {
    view_label: "ABACUS Contract"
    relationship: many_to_one
    sql_on: ${vw_abacus_fact_sales_nr.contract_id}= ${royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales.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: orch_app_ar_prod_royalty_accounting_exchange_rate {
    view_label: "USD Exchange Rate"
    type: left_outer
    relationship: many_to_one
    sql_on: ${vw_abacus_fact_sales_nr.statement_period_id}= ${orch_app_ar_prod_royalty_accounting_exchange_rate.statement_period_id} and
            ${vw_abacus_fact_sales_nr.sale_currency_code}=${orch_app_ar_prod_royalty_accounting_exchange_rate.from_currency_code} and
            ${orch_app_ar_prod_royalty_accounting_exchange_rate.to_currency_code} = 'USD';;
    fields: [from_currency_code, to_currency_code, rate]
  }

  # -----------------------------------------------------------------------
  # Salesforce & Contributor Extensions
  # -----------------------------------------------------------------------
  join: nr_contributor {
    view_label: "NR Contributor"
    type: left_outer
    relationship: many_to_one
    sql_on: ${vw_abacus_fact_sales_nr.contributor_id} = ${nr_contributor.id} ;;
  }

  join: performer_salesforce_contributor {
    view_label: "Salesforce Performer Contributor"
    type: left_outer
    relationship: one_to_one
    sql_on: ${nr_contributor.id} = ${performer_salesforce_contributor.contributor_uuid_c} ;;
  }

  join: performer_salesforce_society {
    view_label: "Salesforce Performer Society"
    type: left_outer
    relationship: one_to_many
    sql_on: ${performer_salesforce_contributor.id} = ${performer_salesforce_society.contributor_c} ;;
  }
}