view: int_dbt_prod_amprofon_album_cert {
  sql_table_name: INTELLIGENCE.DBT_PROD.AMPROFON_ALBUM_CERTIFICATION ;;

  dimension: upc {
    label: "UPC"
    type: string
    sql: ${TABLE}.upc ;;
    view_label: "Release"
  }

  dimension: release_name {
    label: "Release Name"
    type: string
    sql: ${TABLE}.release_name ;;
    view_label: "Release"
  }

  dimension_group: release {
    type: time
    view_label: "Release"
    description: "Original date of release"
    timeframes: [date, day_of_week, week_of_year, week, month, year]
    sql: ${TABLE}.release_date ;;
    convert_tz: no
  }

  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: 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"
  }

}