label: "Core Models"
connection: "snowflake_via_lookerappadmin"
include: "*.view.lkml"

fiscal_month_offset: -9


explore: facts_prod_fact_market_share {
  label: "Market Share"
  hidden: no
  fields: [
    ALL_FIELDS*,
    -facts_prod_fact_market_share.country_code
  ]
  case_sensitive: no

  join: facts_prod_dim_country {
    view_label: "Country"
    sql_on: ${facts_prod_fact_market_share.country_code} = ${facts_prod_dim_country.country_code} ;;
    relationship: many_to_one
  }

  join: int_prod_territory_grouping {
    view_label: "Country"
    sql_on:${facts_prod_dim_country.country_id}=${int_prod_territory_grouping.countryid} ;;
    relationship: many_to_one
  }


  join: dt_rolling_date_windows_market_share {
    view_label: "Date"
    sql_on: ${facts_prod_fact_market_share.activity_month544_month} = ${dt_rolling_date_windows_market_share.period} ;;
    relationship: many_to_one
    type: inner
  }

}

include: "dt_fact_sales_market_share.view.lkml"
include: "facts_prod_dim_store.view.lkml"
include: "facts_prod_dim_label.view.lkml"
include: "int_dbt_prod_awal_tier_groups.view.lkml"



  explore: dt_fact_sales_market_share {
    group_label: "Blended Models"
    label: "Accounting / Market Share"
    case_sensitive: no
    hidden: yes

    join: orch_app_ar_vendor {
      view_label: "Label"
      sql_on: ${dt_fact_sales_market_share.labelid} = ${orch_app_ar_vendor.vendor_id} ;;
      relationship: many_to_one
      fields: [
        label_name,
        vendor_id,
        created_date,
        label_identifier,
        is_owned,
        priority,
        status,
        count_labels
      ]
    }

    join: orch_app_ar_owner {
      view_label: "Owner"
      sql_on: ${orch_app_ar_vendor.owner} = ${orch_app_ar_owner.owner_abbreviation} ;;
      relationship: many_to_one
    }

    join: facts_prod_dim_country {
      view_label: "Country"
      sql_on: ${dt_fact_sales_market_share.country_code} = ${facts_prod_dim_country.country_code} ;;
      relationship: many_to_one
    }

    join: facts_prod_dim_store {
      view_label: "Store"
      sql_on: ${dt_fact_sales_market_share.storeid} = ${facts_prod_dim_store.store_id} ;;
      relationship: many_to_one
      fields: [store_id, store_name, count_stores]
    }

    join: int_dbt_prod_awal_tier_groups {
      view_label: "Orchard/AWAL Tiers"
      relationship: many_to_one
      sql_on: ${dt_fact_sales_market_share.labelid}= ${int_dbt_prod_awal_tier_groups.label_id};;
      fields: [brand_name,parent_company,service_tier_name, owner, is_distributor]
    }
  }


include: "dt_fact_sales_market_share_artist_level.view.lkml"
include: "facts_prod_dim_store.view.lkml"
include: "facts_prod_dim_label.view.lkml"
include: "int_dbt_prod_awal_tier_groups.view.lkml"



explore: dt_fact_sales_market_share_artist_level {
  group_label: "Blended Models"
  label: "Accounting / Market Share Artist Level"
  case_sensitive: no
  hidden: yes

  join: orch_app_ar_vendor {
    view_label: "Label"
    sql_on: ${dt_fact_sales_market_share_artist_level.labelid} = ${orch_app_ar_vendor.vendor_id} ;;
    relationship: many_to_one
    fields: [
      label_name,
      created_date,
      label_identifier,
      is_owned,
      priority,
      status,
      count_labels
    ]
  }



  join: orch_app_ar_owner {
    view_label: "Owner"
    sql_on: ${orch_app_ar_vendor.owner} = ${orch_app_ar_owner.owner_abbreviation} ;;
    relationship: many_to_one
  }

  join: facts_prod_dim_country {
    view_label: "Country"
    sql_on: ${dt_fact_sales_market_share_artist_level.country_code} = ${facts_prod_dim_country.country_code} ;;
    relationship: many_to_one
  }

  join: facts_prod_dim_store {
    view_label: "Store"
    sql_on: ${dt_fact_sales_market_share_artist_level.storeid} = ${facts_prod_dim_store.store_id} ;;
    relationship: many_to_one
    fields: [store_id, store_name, count_stores]
  }

  join: int_dbt_prod_awal_tier_groups {
    view_label: "Orchard/AWAL Tiers"
    relationship: many_to_one
    sql_on: ${dt_fact_sales_market_share_artist_level.labelid}= ${int_dbt_prod_awal_tier_groups.label_id};;
    fields: [brand_name,parent_company,service_tier_name, owner, is_distributor]
  }
}


include: "dt_market_share_change.view.lkml"

explore: dt_market_share_change {
  label: "Market Share Change"
  hidden: yes
  case_sensitive: no

  persist_for: "24 hours"
}