label: "Publishing"
connection: "publishing-looker" #create a connection to service publishing reporting exclusively.

include: "/views/publishing_app_change_log.view.lkml"
include: "/views/publishing_metadata.view.lkml"
include: "/views/publishing_metadata_simplified.view.lkml"
include: "/views/royalty_accounting_qa_fact_sale_publishing.view.lkml"
include: "/views/royalty_accounting_prod_vw_abacus_fact_sales_publishing.view.lkml"
include: "/views/royalty_accounting_prod_vw_abacus_fact_sales_publishing_unpivoted.view.lkml"
include: "/views/orch_app_ar_vendor.view.lkml"
include: "/views/orch_app_ar_acct_period.view.lkml"
include: "/views/unified_publishing_master_royalties.view.lkml"
include: "/views/int_dbt_prod_publishing_metadata_standard.view.lkml"

fiscal_month_offset: -9

explore: publishing_metadata {
  label: "Publishing Metadata"
  view_label: "Publishing Metadata"
  case_sensitive: no
  hidden: no

  join: publishing_app_change_log {
    relationship: many_to_many #this needs a double check
    sql_on: ${publishing_app_change_log.PubSongID} = ${publishing_metadata.pub_song_id} and ${publishing_app_change_log.changed_on} > ${publishing_metadata.delivery_date_date} ;;
  }

}

explore: royalty_accounting_prod_vw_abacus_fact_sales_publishing {
  label: "Publishing Accounting"
  view_label: "Publishing Accounting"
  case_sensitive: no
  hidden: no

  join: publishing_metadata_simplified {
    relationship: many_to_one
    view_label: "Publishing Metadata"
    sql_on: ${royalty_accounting_prod_vw_abacus_fact_sales_publishing.external_song_id} = ${publishing_metadata_simplified.pub_song_id} and ${royalty_accounting_prod_vw_abacus_fact_sales_publishing.account_id} = ${publishing_metadata_simplified.label_id};;
  }

  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: royalty_accounting_prod_vw_abacus_fact_sales_publishing_unpivoted {
  label: "Publishing Accounting (Unpivoted)"
  view_label: "Publishing Accounting (Unpivoted)"
  case_sensitive: no
  hidden: no

  join: publishing_metadata_simplified {
    relationship: many_to_one
    view_label: "Publishing Metadata"
    sql_on: ${royalty_accounting_prod_vw_abacus_fact_sales_publishing_unpivoted.external_song_id} = ${publishing_metadata_simplified.pub_song_id} and ${royalty_accounting_prod_vw_abacus_fact_sales_publishing_unpivoted.account_id} = ${publishing_metadata_simplified.label_id};;
  }

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

explore: unified_publishing_master_royalties {
  label: "Unified Publishing Master Royalties"
  view_label: "Unified Publishing Master Royalties"
  case_sensitive: no
  hidden: no

  join: publishing_metadata_simplified {
      relationship: many_to_one
      view_label: "Publishing Metadata"
      sql_on: ${unified_publishing_master_royalties.pub_song_id} = ${publishing_metadata_simplified.pub_song_id} and ${unified_publishing_master_royalties.label_id} = ${publishing_metadata_simplified.label_id};;
    }

  }

explore:  publishing_metadata_simplified {
  label: "Publishing Metadata Rollup"
  view_label: "Publishing Metadata"
  case_sensitive: no
  hidden: no
}

explore:  int_dbt_prod_publishing_metadata_standard {
  label: "Publishing Metadata Standard"
  view_label: "Publishing Metadata"
  case_sensitive: no
  hidden: no
}