view: all_signed_labels_revenue_columns {
  sql_table_name: "INTELLIGENCE"."DBT_PROD"."ALL_SIGNED_LABELS_REVENUE_COLUMNS" ;;

    dimension: address_city {
      group_label: "Metadata"
      type: string
      sql: ${TABLE}."ADDRESS_CITY" ;;
    }
    dimension: closer {
      group_label: "Metadata"
      type: string
      sql: ${TABLE}."CLOSER" ;;
    }
    dimension: continent {
      group_label: "Metadata"
      type: string
      sql: ${TABLE}."CONTINENT" ;;
    }
    dimension: country {
      group_label: "Metadata"
      type: string
      map_layer_name: countries
      sql: ${TABLE}."COUNTRY" ;;
    }
    dimension: genre {
      group_label: "Metadata"
      type: string
      sql: ${TABLE}."GENRE" ;;
    }
    dimension: is_distributor {
      group_label: "Metadata"
      type: string
      sql: ${TABLE}."IS_DISTRIBUTOR" ;;
    }
    dimension: is_owned {
      group_label: "Metadata"
      type: yesno
      sql: ${TABLE}."IS_OWNED" ;;
    }
    dimension: label_id {
      group_label: "Metadata"
      type: number
      sql: ${TABLE}."LABEL_ID" ;;
    }

    dimension: label_name {
      group_label: "Metadata"
      type: string
      sql: ${TABLE}."LABEL_NAME" ;;
    }

    dimension: label_identifier {
      group_label: "Metadata"
      type: string
      sql: ${TABLE}."LABEL_IDENTIFIER" ;;
    }

    dimension: is_d3{
      group_label: "Metadata"
      type: yesno
      sql: ${TABLE}."LABEL_IDENTIFIER" = 'D3' ;;
    }

    dimension_group: latest_contract_start {
      group_label: "Metadata"
      type: time
      timeframes: [date]
      convert_tz: no
      datatype: date
      sql: ${TABLE}."LATEST_CONTRACT_START_DATE" ;;
    }
    dimension_group: latest_release {
      group_label: "Metadata"
      type: time
      timeframes: [date]
      convert_tz: no
      datatype: date
      sql: ${TABLE}."LATEST_RELEASE" ;;
    }
    dimension: list_contact_and_alt_emails {
      group_label: "Metadata"
      type: string
      sql: ${TABLE}."LIST_CONTACT_AND_ALT_EMAILS" ;;
    }
    dimension: not_within_window_apple_ids {
      group_label: "Metadata"
      type: number
      value_format_name: id
      sql: ${TABLE}."NOT_WITHIN_WINDOW_APPLE_IDS" ;;
    }
    dimension: orchrep_name {
      group_label: "Metadata"
      hidden: yes
      type: number
      sql: ${TABLE}."ORCHREP_NAME" ;;
    }
    dimension_group: original_contract_start {
      group_label: "Metadata"
      type: time
      timeframes: [raw, date, week, month, quarter, year]
      convert_tz: no
      datatype: date
      sql: ${TABLE}."ORIGINAL_CONTRACT_START_DATE" ;;
    }
    dimension: owner {
      group_label: "Metadata"
      type: string
      sql: ${TABLE}."OWNER" ;;
    }
    dimension: performance_rights_split {
      group_label: "Metadata"
      type: number
      value_format: "0.00%"
      sql: ${TABLE}."PERFORMANCE_RIGHTS_SPLIT" ;;
    }
    dimension: priority {
      group_label: "Metadata"
      type: number
      sql: ${TABLE}."PRIORITY" ;;
    }
    dimension: quarterback_label_manager {
      group_label: "Metadata"
      label: "Secondary Label Manager"
      type: string
      sql: ${TABLE}."QUARTERBACK_LABEL_MANAGER" ;;
    }

    dimension: relationship_manager {
      group_label: "Metadata"
      type: string
      sql: ${TABLE}."RELATIONSHIP_MANAGER" ;;
    }
    dimension: releases_last_year {
      group_label: "Release"
      type: number
      sql: ${TABLE}."RELEASES_LAST_YEAR" ;;
    }

  dimension: tracks_last_year {
    group_label: "Release"
    type: number
    sql: ${TABLE}."TRACKS_LAST_YEAR" ;;
  }
    dimension: restrictions_by_country {
      group_label: "Metadata"
      type: string
      sql: ${TABLE}."RESTRICTIONS_BY_COUNTRY" ;;
    }
    dimension: restrictions_by_store {
      group_label: "Metadata"
      type: string
      sql: ${TABLE}."RESTRICTIONS_BY_STORE" ;;
    }
    dimension: service_tier_name {
      group_label: "Metadata"
      type: string
      sql: ${TABLE}."SERVICE_TIER_NAME" ;;
    }
    dimension: sound_exchange_split {
      group_label: "Metadata"
      value_format: "0.00%"
      type: number
      sql: ${TABLE}."SOUND_EXCHANGE_SPLIT" ;;
    }
    dimension: total_releases {
      group_label: "Release"
      type: number
      sql: ${TABLE}."TOTAL_RELEASES" ;;
    }
    dimension: total_tracks {
      group_label: "Release"
      type: number
      sql: ${TABLE}."TOTAL_TRACKS" ;;
    }
    dimension: vendor_name {
      hidden: yes
      type: string
      sql: ${TABLE}."VENDOR_NAME" ;;
    }
    dimension: within_window_apple_ids {
      group_label: "Metadata"
      type: number
      value_format_name: id
      sql: ${TABLE}."WITHIN_WINDOW_APPLE_IDS" ;;
    }
    dimension: youtube_channel_service_tier_name {
      group_label: "Metadata"
      type: string
      sql: ${TABLE}."YOUTUBE_CHANNEL_SERVICE_TIER_NAME" ;;
    }

    dimension: total_marketing_priorities {
      group_label: "Marketing Priorities"
      type: string
      sql: ${TABLE}."TOTAL_PRIORITIES" ;;
    }

    dimension: marketing_priorities_last_24_months {
      group_label: "Marketing Priorities"
      type: string
      sql: ${TABLE}."PRIORITIES_LAST_24_MONTHS" ;;
    }

    dimension_group: accounting_quarter {
      group_label: "Revenue"
      type: time
      timeframes: [quarter]
      convert_tz: no
      datatype: date
      sql: ${TABLE}."ACCOUNTING_QUARTER" ;;
    }

    dimension_group: run_quarter {
      label: "Run Quarter"
      description: "Which quarter's data would you like to view - displayed as first date of quarter"
      group_label: "Run History"
      type: time
      timeframes: [quarter]
      datatype: date
      sql: ${TABLE}."RUN_TIMESTAMP" ;;
    }

    dimension: is_latest_date {
      group_label: "Run History"
      type: yesno
      sql:${TABLE}."RUN_TIMESTAMP" = ${TABLE}."MAX_RUN_TIMESTAMP";;
    }

  dimension: count_youtube_channels {
    group_label: "Youtube Channel"
    label: "Total Youtube Channels"
    type: number
    sql:${TABLE}."COUNT_YOUTUBE_CHANNELS";;
  }


  #Revenue All
  dimension: revenue_q1 {
    type: number
    group_label: "Revenue All"
    sql: ${TABLE}."REVENUE_Q1" ;;
  }
  dimension: revenue_q2 {
    type: number
    group_label: "Revenue All"
    sql: ${TABLE}."REVENUE_Q2" ;;
  }
  dimension: revenue_q3 {
    type: number
    group_label: "Revenue All"
    sql: ${TABLE}."REVENUE_Q3" ;;
  }
  dimension: revenue_q4 {
    type: number
    group_label: "Revenue All"
    sql: ${TABLE}."REVENUE_Q4" ;;
  }
  dimension: revenue_q5 {
    type: number
    group_label: "Revenue All"
    sql: ${TABLE}."REVENUE_Q5" ;;
  }
  dimension: revenue_q6 {
    type: number
    group_label: "Revenue All"
    sql: ${TABLE}."REVENUE_Q6" ;;
  }
  dimension: revenue_q7 {
    type: number
    group_label: "Revenue All"
    sql: ${TABLE}."REVENUE_Q7" ;;
  }

  dimension: revenue_q8 {
    type: number
    group_label: "Revenue All"
    sql: ${TABLE}."REVENUE_Q8" ;;
  }

  dimension: revenue_q9 {
    type: number
    group_label: "Revenue All"
    sql: ${TABLE}."REVENUE_Q9" ;;
  }

   #Spotify

  dimension: revenue_q1_spotify {
    type: number
    group_label: "Revenue Spotify"
    sql: ${TABLE}."REVENUE_Q1_SPOTIFY" ;;
  }
  dimension: revenue_q2_spotify {
    type: number
    group_label: "Revenue Spotify"
    sql: ${TABLE}."REVENUE_Q2_SPOTIFY" ;;
  }
  dimension: revenue_q3_spotify {
    type: number
    group_label: "Revenue Spotify"
    sql: ${TABLE}."REVENUE_Q3_SPOTIFY" ;;
  }
  dimension: revenue_q4_spotify {
    type: number
    group_label: "Revenue Spotify"
    sql: ${TABLE}."REVENUE_Q4_SPOTIFY" ;;
  }
  dimension: revenue_q5_spotify {
    type: number
    group_label: "Revenue Spotify"
    sql: ${TABLE}."REVENUE_Q5_SPOTIFY" ;;
  }
  dimension: revenue_q6_spotify {
    type: number
    group_label: "Revenue Spotify"
    sql: ${TABLE}."REVENUE_Q6_SPOTIFY" ;;
  }
  dimension: revenue_q7_spotify {
    type: number
    group_label: "Revenue Spotify"
    sql: ${TABLE}."REVENUE_Q7_SPOTIFY" ;;
  }
  dimension: revenue_q8_spotify {
    type: number
    group_label: "Revenue Spotify"
    sql: ${TABLE}."REVENUE_Q8_SPOTIFY" ;;
  }

  dimension: revenue_q9_spotify {
    type: number
    group_label: "Revenue Spotify"
    sql: ${TABLE}."REVENUE_Q9_SPOTIFY" ;;
  }


  #Apple

  dimension: revenue_q1_itunes_apple {
    type: number
    group_label: "Revenue Apple"
    sql: ${TABLE}."REVENUE_Q1_ITUNES_APPLE" ;;
  }
  dimension: revenue_q2_itunes_apple {
    type: number
    group_label: "Revenue Apple"
    sql: ${TABLE}."REVENUE_Q2_ITUNES_APPLE" ;;
  }
  dimension: revenue_q3_itunes_apple {
    type: number
    group_label: "Revenue Apple"
    sql: ${TABLE}."REVENUE_Q3_ITUNES_APPLE" ;;
  }
  dimension: revenue_q4_itunes_apple {
    type: number
    group_label: "Revenue Apple"
    sql: ${TABLE}."REVENUE_Q4_ITUNES_APPLE" ;;
  }
  dimension: revenue_q5_itunes_apple {
    type: number
    group_label: "Revenue Apple"
    sql: ${TABLE}."REVENUE_Q5_ITUNES_APPLE" ;;
  }
  dimension: revenue_q6_itunes_apple {
    type: number
    group_label: "Revenue Apple"
    sql: ${TABLE}."REVENUE_Q6_ITUNES_APPLE" ;;
  }
  dimension: revenue_q7_itunes_apple {
    type: number
    group_label: "Revenue Apple"
    sql: ${TABLE}."REVENUE_Q7_ITUNES_APPLE" ;;
  }
  dimension: revenue_q8_itunes_apple {
    type: number
    group_label: "Revenue Apple"
    sql: ${TABLE}."REVENUE_Q8_ITUNES_APPLE" ;;
  }
  dimension: revenue_q9_itunes_apple {
    type: number
    group_label: "Revenue Apple"
    sql: ${TABLE}."REVENUE_Q9_ITUNES_APPLE" ;;
  }



  #YouTube

  dimension: revenue_q1_youtube {
    type: number
    group_label: "Revenue YouTube"
    sql: ${TABLE}."REVENUE_Q1_YOUTUBE" ;;
  }
  dimension: revenue_q2_youtube {
    type: number
    group_label: "Revenue YouTube"
    sql: ${TABLE}."REVENUE_Q2_YOUTUBE" ;;
  }
  dimension: revenue_q3_youtube {
    type: number
    group_label: "Revenue YouTube"
    sql: ${TABLE}."REVENUE_Q3_YOUTUBE" ;;
  }
  dimension: revenue_q4_youtube {
    type: number
    group_label: "Revenue YouTube"
    sql: ${TABLE}."REVENUE_Q4_YOUTUBE" ;;
  }
  dimension: revenue_q5_youtube {
    type: number
    group_label: "Revenue YouTube"
    sql: ${TABLE}."REVENUE_Q5_YOUTUBE" ;;
  }
  dimension: revenue_q6_youtube {
    type: number
    group_label: "Revenue YouTube"
    sql: ${TABLE}."REVENUE_Q6_YOUTUBE" ;;
  }
  dimension: revenue_q7_youtube {
    type: number
    group_label: "Revenue YouTube"
    sql: ${TABLE}."REVENUE_Q7_YOUTUBE" ;;
  }
  dimension: revenue_q8_youtube {
    type: number
    group_label: "Revenue YouTube"
    sql: ${TABLE}."REVENUE_Q8_YOUTUBE" ;;
  }
  dimension: revenue_q9_youtube {
    type: number
    group_label: "Revenue YouTube"
    sql: ${TABLE}."REVENUE_Q9_YOUTUBE" ;;
  }

  #Amazon

  dimension: revenue_q1_amazon {
    type: number
    group_label: "Revenue Amazon"
    sql: ${TABLE}."REVENUE_Q1_AMAZON" ;;
  }
  dimension: revenue_q2_amazon {
    type: number
    group_label: "Revenue Amazon"
    sql: ${TABLE}."REVENUE_Q2_AMAZON" ;;
  }
  dimension: revenue_q3_amazon {
    type: number
    group_label: "Revenue Amazon"
    sql: ${TABLE}."REVENUE_Q3_AMAZON" ;;
  }
  dimension: revenue_q4_amazon {
    type: number
    group_label: "Revenue Amazon"
    sql: ${TABLE}."REVENUE_Q4_AMAZON" ;;
  }
  dimension: revenue_q5_amazon {
    type: number
    group_label: "Revenue Amazon"
    sql: ${TABLE}."REVENUE_Q5_AMAZON" ;;
  }
  dimension: revenue_q6_amazon {
    type: number
    group_label: "Revenue Amazon"
    sql: ${TABLE}."REVENUE_Q6_AMAZON" ;;
  }
  dimension: revenue_q7_amazon {
    type: number
    group_label: "Revenue Amazon"
    sql: ${TABLE}."REVENUE_Q7_AMAZON" ;;
  }
  dimension: revenue_q8_amazon {
    type: number
    group_label: "Revenue Amazon"
    sql: ${TABLE}."REVENUE_Q8_AMAZON" ;;
  }
  dimension: revenue_q9_amazon {
    type: number
    group_label: "Revenue Amazon"
    sql: ${TABLE}."REVENUE_Q9_AMAZON" ;;
  }

#Physical

  dimension: revenue_q1_physical {
    type: number
    group_label: "Revenue Physical"
    sql: ${TABLE}."PHYSICAL_REVENUE_Q1" ;;
  }
  dimension: revenue_q2_physical {
    type: number
    group_label: "Revenue Physical"
    sql: ${TABLE}."PHYSICAL_REVENUE_Q2" ;;
  }
  dimension: revenue_q3_physical {
    type: number
    group_label: "Revenue Physical"
    sql: ${TABLE}."PHYSICAL_REVENUE_Q3" ;;
  }
  dimension: revenue_q4_physical {
    type: number
    group_label: "Revenue Physical"
    sql: ${TABLE}."PHYSICAL_REVENUE_Q4" ;;
  }
  dimension: revenue_q5_physical {
    type: number
    group_label: "Revenue Physical"
    sql: ${TABLE}."PHYSICAL_REVENUE_Q5" ;;
  }
  dimension: revenue_q6_physical {
    type: number
    group_label: "Revenue Physical"
    sql: ${TABLE}."PHYSICAL_REVENUE_Q6" ;;
  }
  dimension: revenue_q7_physical {
    type: number
    group_label: "Revenue Physical"
    sql: ${TABLE}."PHYSICAL_REVENUE_Q7" ;;
  }
  dimension: revenue_q8_physical {
    type: number
    group_label: "Revenue Physical"
    sql: ${TABLE}."PHYSICAL_REVENUE_Q8" ;;
  }
  dimension: revenue_q9_physical {
    type: number
    group_label: "Revenue Physical"
    sql: ${TABLE}."PHYSICAL_REVENUE_Q9" ;;
  }


  #Other

  dimension: revenue_q1_other {
    type: number
    group_label: "Revenue Other"
    sql: ${TABLE}."REVENUE_Q1_OTHER" ;;
  }
  dimension: revenue_q2_other {
    type: number
    group_label: "Revenue Other"
    sql: ${TABLE}."REVENUE_Q2_OTHER" ;;
  }
 dimension: revenue_q3_other {
    type: number
  group_label: "Revenue Other"
    sql: ${TABLE}."REVENUE_Q3_OTHER" ;;
  }
  dimension: revenue_q4_other {
    type: number
    group_label: "Revenue Other"
    sql: ${TABLE}."REVENUE_Q4_OTHER" ;;
  }
  dimension: revenue_q5_other {
    type: number
    group_label: "Revenue Other"
    sql: ${TABLE}."REVENUE_Q5_OTHER" ;;
  }
  dimension: revenue_q6_other {
    type: number
    group_label: "Revenue Other"
    sql: ${TABLE}."REVENUE_Q6_OTHER" ;;
  }
  dimension: revenue_q7_other {
    type: number
    group_label: "Revenue Other"
    sql: ${TABLE}."REVENUE_Q7_OTHER" ;;
  }
  dimension: revenue_q8_other {
    type: number
    group_label: "Revenue Other"
    sql: ${TABLE}."REVENUE_Q8_OTHER" ;;
  }
  dimension: revenue_q9_other {
    type: number
    group_label: "Revenue Other"
    sql: ${TABLE}."REVENUE_Q9_OTHER" ;;
  }
}