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

include: "/views/dt_abacus_batch_adjustments.view.lkml"
include: "/views/dt_abacus_batch_adjustments_expenses_prod.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/facts_prod_identity.view.lkml"
include: "/views/orch_app_ar_royalty_statement_period.view.lkml"
include: "/views/dt_abacus_batch_adjustments_expenses_qa.view.lkml"
include: "/views/orch_app_ar_royalty_accounting_run_controller.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/dt_abacus_batch_adjustments_expenses_uat.view.lkml"

fiscal_month_offset: -9

explore: dt_abacus_batch_adjustments {
  label: "ABACUS Batch Adjustments and Expenses"
  view_label: "ABACUS Batch Adjustments and Expenses"
  case_sensitive: no
  hidden: yes

  join: royalty_accounting_prod_vw_dim_abacus_account {
    view_label: "ABACUS Account"
    relationship: many_to_one
    sql_on: ${dt_abacus_batch_adjustments.worksheet_adjustment_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: ${royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales.contract_id}= ${dt_abacus_batch_adjustments.worksheet_adjustment_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_royalty_statement_period {
    view_label: "Activity Statement Period"
    sql_on: ${dt_abacus_batch_adjustments.activity_statement_period_id} = ${orch_app_ar_royalty_statement_period.statement_period_id} ;;
    relationship: many_to_one
    fields: [
      statement_period_id,
      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
    ]
  }

}


explore: dt_abacus_batch_adjustments_expenses_qa {
  label: "ABACUS Batch Adjustments and Expenses QA"
  view_label: "ABACUS Batch Adjustments and Expenses QA"
  case_sensitive: no
  hidden: yes

  join: royalty_accounting_prod_vw_dim_abacus_account {
    view_label: "ABACUS Account"
    relationship: many_to_one
    sql_on: ${dt_abacus_batch_adjustments_expenses_qa.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: ${royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales.contract_id}= ${dt_abacus_batch_adjustments_expenses_qa.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_royalty_statement_period {
    view_label: "Activity Statement Period"
    sql_on: ${dt_abacus_batch_adjustments_expenses_qa.activity_period} = ${orch_app_ar_royalty_statement_period.statement_period_id} ;;
    relationship: many_to_one
    fields: [
      statement_period_id,
      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: int_dbt_prod_awal_tier_groups {
    view_label: "Orchard/AWAL Tiers"
    relationship: many_to_one
    sql_on: ${dt_abacus_batch_adjustments_expenses_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_batch_adjustments_expenses_qa.account_id}= ${int_dbt_prod_abacus_awal_client_segments.account_id};;
  }

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

  }

  join: statement_period {
    view_label: "Statement Period"
    from:  orch_app_ar_royalty_statement_period
    sql_on: ${dt_abacus_batch_adjustments_expenses_qa.statement_period} = ${statement_period.statement_period_id} ;;
    relationship: many_to_one
    fields: [
      statement_period_id,
      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: facts_prod_identity {
    view_label: "Approved By Name/Email"
    relationship: many_to_one
    sql_on: ${dt_abacus_batch_adjustments_expenses_qa.approved_by}= ${facts_prod_identity.id};;
    fields: [name, email]
  }

  join: facts_prod_identity_term_created {
    view_label: "Applied By Name/Email"
    from:  facts_prod_identity
    type: left_outer
    relationship: many_to_one
    sql_on: ${dt_abacus_batch_adjustments_expenses_qa.applied_by}= ${facts_prod_identity_term_created.id};;
    fields: [name, email]
  }


}



explore: dt_abacus_batch_adjustments_expenses_prod {
  label: "ABACUS Batch Adjustments and Expenses PROD"
  view_label: "ABACUS Batch Adjustments and Expenses PROD"
  case_sensitive: no
  hidden: yes

  join: royalty_accounting_prod_vw_dim_abacus_account {
    view_label: "ABACUS Account"
    relationship: many_to_one
    sql_on: ${dt_abacus_batch_adjustments_expenses_prod.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: ${royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales.contract_id}= ${dt_abacus_batch_adjustments_expenses_prod.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_royalty_statement_period {
    view_label: "Activity Statement Period"
    sql_on: ${dt_abacus_batch_adjustments_expenses_prod.activity_period} = ${orch_app_ar_royalty_statement_period.statement_period_id} ;;
    relationship: many_to_one
    fields: [
      statement_period_id,
      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: int_dbt_prod_awal_tier_groups {
    view_label: "Orchard/AWAL Tiers"
    relationship: many_to_one
    sql_on: ${dt_abacus_batch_adjustments_expenses_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_batch_adjustments_expenses_prod.account_id}= ${int_dbt_prod_abacus_awal_client_segments.account_id};;
  }

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

  }

  join: statement_period {
    view_label: "Statement Period"
    from:  orch_app_ar_royalty_statement_period
    sql_on: ${dt_abacus_batch_adjustments_expenses_prod.statement_period} = ${statement_period.statement_period_id} ;;
    relationship: many_to_one
    fields: [
      statement_period_id,
      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: facts_prod_identity {
    view_label: "Approved By Name/Email"
    relationship: many_to_one
    sql_on: ${dt_abacus_batch_adjustments_expenses_prod.approved_by}= ${facts_prod_identity.id};;
    fields: [name, email]
  }

  join: facts_prod_identity_term_created {
    view_label: "Applied By Name/Email"
    from:  facts_prod_identity
    type: left_outer
    relationship: many_to_one
    sql_on: ${dt_abacus_batch_adjustments_expenses_prod.applied_by}= ${facts_prod_identity_term_created.id};;
    fields: [name, email]
  }


}





explore: dt_abacus_batch_adjustments_expenses_uat {
  label: "ABACUS Batch Adjustments and Expenses UAT"
  view_label: "ABACUS Batch Adjustments and Expenses UAT"
  case_sensitive: no
  hidden: yes

  join: royalty_accounting_prod_vw_dim_abacus_account {
    view_label: "ABACUS Account"
    relationship: many_to_one
    sql_on: ${dt_abacus_batch_adjustments_expenses_uat.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: ${royalty_accounting_prod_vw_dim_abacus_contract_abacus_fact_sales.contract_id}= ${dt_abacus_batch_adjustments_expenses_uat.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_royalty_statement_period {
    view_label: "Activity Statement Period"
    sql_on: ${dt_abacus_batch_adjustments_expenses_uat.activity_period} = ${orch_app_ar_royalty_statement_period.statement_period_id} ;;
    relationship: many_to_one
    fields: [
      statement_period_id,
      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: int_dbt_prod_awal_tier_groups {
    view_label: "Orchard/AWAL Tiers"
    relationship: many_to_one
    sql_on: ${dt_abacus_batch_adjustments_expenses_uat.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_batch_adjustments_expenses_uat.account_id}= ${int_dbt_prod_abacus_awal_client_segments.account_id};;
  }

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

  }

  join: statement_period {
    view_label: "Statement Period"
    from:  orch_app_ar_royalty_statement_period
    sql_on: ${dt_abacus_batch_adjustments_expenses_uat.statement_period} = ${statement_period.statement_period_id} ;;
    relationship: many_to_one
    fields: [
      statement_period_id,
      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: facts_prod_identity {
    view_label: "Approved By Name/Email"
    relationship: many_to_one
    sql_on: ${dt_abacus_batch_adjustments_expenses_uat.approved_by}= ${facts_prod_identity.id};;
    fields: [name, email]
  }

  join: facts_prod_identity_term_created {
    view_label: "Applied By Name/Email"
    from:  facts_prod_identity
    type: left_outer
    relationship: many_to_one
    sql_on: ${dt_abacus_batch_adjustments_expenses_uat.applied_by}= ${facts_prod_identity_term_created.id};;
    fields: [name, email]
  }


}