view: int_dbt_prod_agg_line_model {
sql_table_name: INTELLIGENCE.DBT_PROD.AGG_LINE_MODEL ;;

  dimension_group: activity_date {
    view_label: "Date"                                                             #Label name containing Dimensions and measure
    label: "Activity"
    description: "Date of consumption of a track"
    type: time
    sql: ${TABLE}.ACTIVITY_DATE ;;
    timeframes: [year,
      quarter,
      month,
      week,
      date,
      day_of_year,
      day_of_week,
      week_of_year,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }

  dimension: label_no {
    view_label: "Label"
    hidden: yes
    label: "Label no"
    type: string
    sql: ${TABLE}.label_no ;;
  }

  dimension: distributor {
    view_label: "Label"
    label: "Distributor"
    description: "Always Orchard"
    type: string
    sql: ${TABLE}.distributor ;;
  }

  dimension: track_ex_id {
    view_label: "Track"
    label: "Track ex id"
    hidden: yes
    type: string
    sql: ${TABLE}.track_ex_id ;;
  }
  dimension: track_name {
    view_label: "Track"
    label: "Track Name"
    description: "Name of the track as reported by the store"
    type: string
    sql: ${TABLE}.track_name ;;
  }
  dimension: isrc {
    view_label: "Track"
    label: "ISRC"
    description: "Unique alphanumeric code assigned to each track"
    type: string
    sql: ${TABLE}.isrc ;;
  }
  dimension: track_product_no {
    view_label: "Track"
    label: "Track Product Number"
    type: string
    description: "Combination of UPC and ISRC"
    sql: ${TABLE}.track_product_no ;;
  }
  dimension: track_grid {
    view_label: "Track"
    label: "Track Grid"
    type: string
    hidden: yes
    sql: ${TABLE}.track_grid ;;
  }

  dimension: artist_ex_id{
    view_label: "Artist"
    label: "Artist ex ID"
    description: "Unique ID assigned to artist by store"
    type: string
    sql: ${TABLE}.atrist_ex_id ;;
  }

  dimension: artist_name{
    view_label: "Artist"
    label: "Artist Name"
    description: "Artist names as reported by the store"
    type: string
    sql: ${TABLE}.artist_name ;;
  }

  dimension: album_disc_no{
    view_label: "Album"
    label: "Album Disc Number"
    hidden: yes
    type: string
    sql: ${TABLE}.album_disc_no ;;
  }
  dimension: album_track_no{
    view_label: "Album"
    label: "Album Track Number"
    type: string
    hidden: yes
    sql: ${TABLE}.album_track_no ;;
  }
  dimension: album_ex_id{
    view_label: "Album"
    label: "Album Ex ID"
    description: "Unique code assigned to each UPC by the store"
    type: string
    sql: ${TABLE}.album_ex_id ;;
  }
  dimension: album_name{
    view_label: "Album"
    label: "Album Name"
    description: "Release name as reported by store"
    type: string
    sql: ${TABLE}.album_name ;;
  }

  dimension: UPC{
    view_label: "Album"
    label: "UPC"
    description: "Stands for Unique product Code. Numeric assigned to every release"
    type: string
    sql: ${TABLE}.UPC ;;
  }
  dimension: label_id{
    view_label: "Label"
    label: "Label_id"
    description: "ID of the label associated with the track"
    type: string
    sql: ${TABLE}.label_id ;;
  }
  dimension: album_grid{
    view_label: "Album"
    label: "Album Grid"
    hidden: yes
    type: string
    sql: ${TABLE}.album_grid ;;
  }

  dimension: country{
    view_label: "Country"
    description: "Country of consumption"
    label: "Country"
    type: string
    sql: ${TABLE}.country ;;
  }
  dimension: catalog_no{
    view_label: "Catalog"
    label: "Catalog Number"
    type: string
    hidden: yes
    sql: ${TABLE}.catalog_no ;;
  }
  dimension: package_no{
    view_label: "Package"
    label: "Package Number"
    hidden: yes
    type: string
    sql: ${TABLE}.package_no ;;
  }
  dimension: place_category{
    view_label: "Place"
    label: "Place Category"
    description: "Track was consumed from: App, App Web etc "
    type: string
    sql: ${TABLE}.place_category ;;
  }
  dimension: app_place_category{
    view_label: "App Place Category"
    label: "App Place Category"
    description: "Source of stream (Favourites, recents etc)"
    type: string
    sql: ${TABLE}.app_place_category ;;
  }

  measure: streams{
    view_label: "Streams"
    label: "Streams"
    description: "Number of streams"
    type: sum
    sql: ${TABLE}.streams ;;
  }
}