connection: "orchard-business-reviews"
label: "Label Review"

include: "*.view.lkml"

week_start_day: friday

fiscal_month_offset: -9

explore: LABEL_REVIEW_ACCOUNTING_NON_RELEASE_LEVEL {
  label: "Accounting Non Release Level"
  case_sensitive: no
  hidden: yes

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

  join: dt_label_review_accounting_non_release_level_country_rank {
    view_label: "Rank"
    relationship: many_to_one
    sql_on: ${LABEL_REVIEW_ACCOUNTING_NON_RELEASE_LEVEL.Label_id} = ${dt_label_review_accounting_non_release_level_country_rank.label_id} and ${LABEL_REVIEW_ACCOUNTING_NON_RELEASE_LEVEL.Country_name} = ${dt_label_review_accounting_non_release_level_country_rank.country_name}  ;;

  }

  join: dt_label_review_accounting_non_release_level_country_store_rank {
    view_label: "Rank"
    relationship: many_to_one
    sql_on: ${LABEL_REVIEW_ACCOUNTING_NON_RELEASE_LEVEL.Label_id} = ${dt_label_review_accounting_non_release_level_country_store_rank.label_id} and ${LABEL_REVIEW_ACCOUNTING_NON_RELEASE_LEVEL.Country_name} = ${dt_label_review_accounting_non_release_level_country_store_rank.country_name} and ${LABEL_REVIEW_ACCOUNTING_NON_RELEASE_LEVEL.Store_name} = ${dt_label_review_accounting_non_release_level_country_store_rank.store_name}  ;;

  }

}

explore: LABEL_REVIEW_ACCOUNTING_RELEASE_LEVEL {
  label: "Accounting Release Level"
  case_sensitive: no
  hidden: yes

  join: dt_label_review_accounting_release_level_country_rank {
    view_label: "Rank"
    relationship: many_to_one
    sql_on: ${LABEL_REVIEW_ACCOUNTING_RELEASE_LEVEL.Label_id} = ${dt_label_review_accounting_release_level_country_rank.label_id} and ${LABEL_REVIEW_ACCOUNTING_RELEASE_LEVEL.Transaction_country_name} = ${dt_label_review_accounting_release_level_country_rank.transaction_country_name}  ;;

  }

  join: dt_label_review_accounting_release_level_country_artist_rank {
    view_label: "Rank"
    relationship: many_to_one
    sql_on: ${LABEL_REVIEW_ACCOUNTING_RELEASE_LEVEL.Label_id} = ${dt_label_review_accounting_release_level_country_artist_rank.label_id} and ${LABEL_REVIEW_ACCOUNTING_RELEASE_LEVEL.Transaction_country_name} = ${dt_label_review_accounting_release_level_country_artist_rank.transaction_country_name} AND ${LABEL_REVIEW_ACCOUNTING_RELEASE_LEVEL.Artist_name} = ${dt_label_review_accounting_release_level_country_artist_rank.artist_name}  ;;

  }

  join: dt_label_review_accounting_release_level_country_release_ran {
    view_label: "Rank"
    relationship: many_to_one
    sql_on: ${LABEL_REVIEW_ACCOUNTING_RELEASE_LEVEL.Label_id} = ${dt_label_review_accounting_release_level_country_release_ran.label_id} and ${LABEL_REVIEW_ACCOUNTING_RELEASE_LEVEL.Transaction_country_name} = ${dt_label_review_accounting_release_level_country_release_ran.transaction_country_name} AND ${LABEL_REVIEW_ACCOUNTING_RELEASE_LEVEL.Release_name} = ${dt_label_review_accounting_release_level_country_release_ran.release_name}  ;;

  }

}


explore: LABEL_REVIEW_ANALYTICS_AMAZON {
  label: "Label Review Analytics Amazon"
  case_sensitive: no
  hidden: yes

}

explore: LABEL_REVIEW_ANALYTICS_APPLE {
  label: "Label Review Analytics Apple"
  case_sensitive: no
  hidden: yes

}

explore: LABEL_REVIEW_ANALYTICS_FIRST_MONTH_STREAMS {
  label: "Label Review Analytics First Month Streams"
  case_sensitive: no
  hidden: yes

}

explore: INTELLIGENCE_DBT_PROD_LABEL_REVIEWS_LABEL_REVIEW_ANALYTICS_PANDORA {
  label: "Label Review Analytics Pandora"
  case_sensitive: no
  hidden: yes

}

explore: intelligence_dbt_prod_label_reviews_label_review_analytics_spotify {
  label: "Label Review Analytics Spotify"
  case_sensitive: no
  hidden: yes

}

explore: intelligence_dbt_prod_label_reviews_label_review_editorial_playlist_placements {
  label: "Label Review Editorial Playlist Placements"
  case_sensitive: no
  hidden: yes

}

explore: intelligence_dbt_prod_label_reviews_label_review_market_share {
  label: "Label Review Market Share"
  case_sensitive: no
  hidden: yes
}

explore: label_review_analytics_all_stores {
  label: "Label Review Analytics All Stores"
  case_sensitive: no
  hidden: yes
}

explore: label_review_physical {
  label: "Label Review Physical"
  case_sensitive: no
  hidden: yes
}
# comment