connection: "abacus-looker"

# datagroup: abacus-looker_default_datagroup {
#   # sql_trigger: SELECT MAX(id) FROM etl_log;;
#   max_cache_age: "1 hour"
# }

# persist_with: abacus-looker_default_datagroup


label: "ABACUS"

include: "/views/royalty_accounting_uat_vw_dim_abacus_contract.view.lkml"
include: "/views/royalty_accounting_uat_vw_dim_abacus_account.view.lkml"
include: "/views/dt_abacus_transaction_level_uat_report.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/orch_app_prod_royalty_accounting_contract_reserve.view.lkml"
include: "/views/facts_prod_dim_transactiontype.view.lkml"


fiscal_month_offset: -9

explore: dt_abacus_transaction_level_uat_report {
  label: "ABACUS Transaction level UAT Report"
  view_label: "ABACUS Txn Level"
  case_sensitive: no
  hidden: yes

  join: royalty_accounting_uat_vw_dim_abacus_account {
    view_label: "ABACUS Account"
    relationship: many_to_one
    sql_on: ${dt_abacus_transaction_level_uat_report.labelid}= ${royalty_accounting_uat_vw_dim_abacus_account.account_id};;
  }


  join: int_dbt_prod_awal_tier_groups {
    view_label: "Orchard/AWAL Tiers"
    relationship: many_to_one
    sql_on: ${royalty_accounting_uat_vw_dim_abacus_account.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: ${royalty_accounting_uat_vw_dim_abacus_account.account_id}= ${int_dbt_prod_abacus_awal_client_segments.account_id};;
  }

  join: facts_prod_dim_transactiontype {
    view_label: "Transaction Type"
    sql_on: ${dt_abacus_transaction_level_uat_report.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: royalty_accounting_uat_vw_dim_abacus_contract {
    view_label: "ABACUS Contract"
    relationship: many_to_one
    sql_on: ${royalty_accounting_uat_vw_dim_abacus_contract.account_id}= ${royalty_accounting_uat_vw_dim_abacus_account.account_id};;
  }
}