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

include: "/views/ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD.view.lkml"
include: "/views/orch_app_ar_royalty_accounting_sales_file.view.lkml"
include: "/views/facts_prod_dim_store.view.lkml"
include: "/views/facts_prod_dim_country.view.lkml"
include: "/views/facts_prod_dim_transactiontype.view.lkml"
include: "/views/facts_prod_dim_label.view.lkml"
include: "/views/orch_app_ar_artist_info.view.lkml"
include: "/views/facts_prod_dim_track.view.lkml"
include: "/views/orch_app_ar_royalty_statement_period.view.lkml"
include: "/views/royalty_accounting_prod_stmt_db_sales_distro.view.lkml"
include: "/views/orch_app_ar_royalty_accounting_period.view.lkml"
include: "/views/orch_app_ar_releases.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/int_dbt_seed_right_type_groupings.view.lkml"
include: "/views/dt_dim_track.view.lkml"

fiscal_month_offset: -9

explore: ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD {
  label: "ABACUS Unallocated Sales by Statement Period"
  view_label: "Unallocated Sales"
  case_sensitive: no
  hidden: yes

  join: orch_app_ar_royalty_statement_period {
    view_label: "Statement Period"
    sql_on: ${ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD.STATEMENT_PERIOD_ID} = ${orch_app_ar_royalty_statement_period.statement_period_id} ;;
    relationship: many_to_one
  }

  join: orch_app_ar_royalty_accounting_sales_file {
    view_label: "Earliest Sales File"
    sql_on: ${ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD.EARLIEST_SALES_FILE_ID} = ${orch_app_ar_royalty_accounting_sales_file.sales_file_id} ;;
    relationship: many_to_one
    fields: [sales_file_last_modified, sales_file_name, sales_file_accounting_period_id]
  }

  join: facts_prod_dim_store {
    view_label: "Store"
    sql_on: ${ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD.STORE_ID} = ${facts_prod_dim_store.store_id} ;;
    relationship: many_to_one
    fields: [store_name]
  }

  join: facts_prod_dim_country {
    view_label: "Country"
    sql_on: ${ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD.COUNTRY_ID} = ${facts_prod_dim_country.country_id} ;;
    relationship: many_to_one
    fields: [country_name]
  }

  join: facts_prod_dim_transactiontype {
    view_label: "Transaction Type"
    sql_on: ${ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD.TRANSACTION_TYPE_ID} = ${facts_prod_dim_transactiontype.transaction_type_id} ;;
    relationship: many_to_one
    fields: [description, transaction_premium_free]
  }

  join: facts_prod_dim_label {
    view_label: "OA Label"
    sql_on: ${ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD.LABEL_ID} = ${facts_prod_dim_label.label_id} ;;
    relationship: many_to_one
    fields: [facts_prod_dim_label.label_name]
  }

  join: dt_dim_track {
    view_label: "Track"
    sql_on: ${ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD.ISRC}=${dt_dim_track.isrc}
            and ${ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD.UPC}=${dt_dim_track.upc}
            and ${ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD.TRACK_ID}=${dt_dim_track.cd_track_id} ;;
    relationship: many_to_one
    fields: [track_id, track_unique_id, track_name, track_name_ex_da, isrc, isrc_ex_da, track_version]
  }

  join: orch_app_ar_releases {
    view_label: "Release"
    sql_on: ${ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD.UPC} = ${orch_app_ar_releases.upc} ;;
    relationship: many_to_one
    fields: [release_name, display_upc, manufacturer_upc, format,
      release_date,
      release_week,
      release_month,
      release_year,
      sale_start_date,
      sale_start_week,
      sale_start_month,
      sale_start_year,
      number_of_releases,
      is_active,
      product_code]
  }

  join: int_dbt_prod_awal_tier_groups {
    view_label: "Orchard/AWAL Tiers (OA Label)"
    relationship: many_to_one
    sql_on: ${ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD.LABEL_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 (OA Label)"
    relationship: many_to_one
    sql_on: ${ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD.LABEL_ID}= ${int_dbt_prod_abacus_awal_client_segments.account_id};;
  }

  join: int_dbt_seed_right_type_groupings {
    view_label: "Right Type Groupings"
    relationship: many_to_one
    sql_on: ${ROYALTY_ACCOUNTING_PROD_VW_ABACUS_UNALLOCATED_SALES_DISTRO_STATEMENT_PERIOD.TRANSACTION_TYPE}= ${int_dbt_seed_right_type_groupings.transaction_type};;
  }

  }