connection: "snowflake_via_lookerappadmin"

include: "orch_app_ar_acct_period.view.lkml"
include: "orch_app_ar_vendor.view.lkml"
include: "royalty_accounting_prod_vw_abacus_fact_sales_publishing.view.lkml"
include: "dt_revenue_by_songwriter.view.lkml"
#include: "publishing_revenue_analytics.dashboard"

explore: royalty_accounting_prod_vw_abacus_fact_sales_publishing {
  hidden: yes
  label: "Publishing"
  view_label: "Publishing Data"


  join: orch_app_ar_vendor {
    sql_on: ${royalty_accounting_prod_vw_abacus_fact_sales_publishing.account_id} = ${orch_app_ar_vendor.vendor_id};;
    relationship: many_to_one
    view_label: "Account"
  }

  join: orch_app_ar_acct_period {
    sql_on: ${royalty_accounting_prod_vw_abacus_fact_sales_publishing.period_id} = ${orch_app_ar_acct_period.Id};;
    relationship: many_to_one
    view_label: "Period"
  }
}

explore: dt_revenue_by_songwriter {
  hidden: yes
  label: "Revenue by Songwriter"
  view_label: "Publishing Data"

  # access_filter: {
  #   field: dt_revenue_by_songwriter.vendor_id  #Filtered on vendor id from the view to avoid join on orch_app_ar_vendor
  #   user_attribute: label_id
  # }


  join: orch_app_ar_vendor {
    sql_on: ${dt_revenue_by_songwriter.vendor_id} = ${orch_app_ar_vendor.vendor_id};;
    relationship: many_to_one
    view_label: "Account"
  }
}