view: int_dbt_prod_amprofon_track_cert {
 sql_table_name: INTELLIGENCE.DBT_PROD.AMPROFON_TRACK_CERTIFICATION ;;

  dimension: isrc {
    label: "ISRC"
    type: string
    sql: ${TABLE}.isrc ;;
    view_label: "Track"
  }

  dimension: trackname {
    label: "Track Name"
    type: string
    sql: ${TABLE}.trackname ;;
    view_label: "Track"
  }

  dimension: labelid {
    label: "Label ID"
    type: string
    sql: ${TABLE}.labelid ;;
    view_label: "Label"
  }

  dimension: label_name {
    label: "Label Name"
    type: string
    sql: ${TABLE}.label_name ;;
    view_label: "Label"
  }

  dimension: label_manager {
    label: "Primary Relationship Manager"
    type: string
    sql: ${TABLE}.label_manager ;;
    view_label: "Label"
  }

  dimension: artistid {
    label: "Artist ID"
    type: number
    sql: ${TABLE}.artistid ;;
    view_label: "Artist"
  }

  dimension: artistname {
    label: "Artist Name"
    type: string
    sql: ${TABLE}.artistname ;;
    view_label: "Artist"
  }

  dimension: brand_name {
    type: string
    full_suggestions: no
    sql: ${TABLE}.brand_name ;;
    view_label: "Label"
    description: "Name of the company to which the label belongs. Can be awal, orchard, sme"
  }

  dimension: service_tier_name {
    type: string
    full_suggestions: no
    sql: ${TABLE}.service_tier_name ;;
    view_label: "Label"
    description: "Client tier the label falls into as per the tiers."
  }

  measure: auido_streams {
    label: "Audio Streams"
    type: sum
    sql: ${TABLE}.audio_streams ;;
    view_label: "Amprofon"
  }

  measure: video_streams {
    label: "Video Streams"
    type: sum
    sql: ${TABLE}.video_streams ;;
    view_label: "Amprofon"
  }

  measure: downloads {
    label: "Downloads"
    type: sum
    sql: ${TABLE}.downloads ;;
    view_label: "Amprofon"
  }

  measure: audio_units {
    label: "Audio Units"
    type: sum
    sql: ${TABLE}.audio_units ;;
    view_label: "Amprofon"
    value_format: "#,##0"
  }

  measure: video_units {
    label: "Video Units"
    type: sum
    sql: ${TABLE}.video_units ;;
    view_label: "Amprofon"
    value_format: "#,##0"
  }

  measure: download_units {
    label: "Download units"
    type: sum
    sql: ${TABLE}.download_units ;;
    view_label: "Amprofon"
    value_format: "#,##0"
  }

  measure: award_sales_units {
    label: "Award Sales Units"
    description: "Sum of Download, Audio and Video units"
    type: sum
    value_format: "#,##0"
    sql: ${TABLE}.award_sales_units ;;
    view_label: "Amprofon"
  }

}