view: int_dbt_prod_aria_album_cert_accounting {
  sql_table_name: INTELLIGENCE.DBT_PROD.ARIA_ALBUM_CERTIFICATION_ACCOUNTING ;;

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

  dimension: display_upc {
    label: " Display UPC"
    type: string
    sql: ${TABLE}.display_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: 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: ad_supported_units {
    label: "Ad Supported Units"
    type: sum
    sql: ${TABLE}.ad_supported_units ;;
    view_label: "Aria"
    value_format: "#,##0"
  }

  measure: subscription_units {
    label: "Subscription Units"
    type: sum
    sql: ${TABLE}.subscription_units ;;
    view_label: "Aria"
    value_format: "#,##0"
  }

  measure: ad_supported_streams {
    label: "Ad-Supported Streams"
    type: sum
    sql: ${TABLE}.ad_supported_streams ;;
    view_label: "Aria"
  }

  measure: subscription_streams {
    label: "Subscription Streams"
    type: sum
    sql: ${TABLE}.subscription_streams ;;
    view_label: "Aria"
  }

  measure: album_downloads {
    label: "Album Downloads"
    type: sum
    sql: ${TABLE}.album_downloads ;;
    view_label: "Aria"
  }

  measure: track_equivalent_units {
    label: "Track Equivalent Units"
    type: sum
    sql: ${TABLE}.track_equivalent_units ;;
    view_label: "Aria"
  }

  measure: physical_sales {
    label: "Physical Sales"
    type: sum
    sql: ${TABLE}.physical_sales ;;
    view_label: "Aria"
  }

  measure: sea_streaming_score {
    label: "SEA Score"
    description: "Avg of ad supported and subscription units adding downloads and track eq units"
    type: sum
    value_format: "#,##0"
    sql: ${TABLE}.sea_streaming_score ;;
    view_label: "Aria"
  }
}