view: int_dbt_prod_lmcp_fact_analytics_last_3_weeks {
  sql_table_name:"INTELLIGENCE"."DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."FACT_ANALYTICS_LAST_3_WEEKS";;


  dimension: Artistid{
    label:"Artist ID"
    type: number
    sql:${TABLE}.Artistid;;
  }
  dimension: Dayid{
    label:"Day ID"
    type: number
    sql:${TABLE}.Dayid;;
  }
  dimension: Labelid{
    label:"Label ID"
    type: number
    sql:${TABLE}.Labelid;;
  }
  dimension: Storeid{
    label:"Store ID"
    type: number
    sql:${TABLE}.Storeid;;
  }
  dimension: Genreid{
    label:"Genre ID"
    type: number
    sql:${TABLE}.Genreid;;
  }
  dimension: Releaseid{
    label:"Release ID"
    type: number
    sql:${TABLE}.Releaseid;;
  }
  dimension: Trackid{
    label:"Track ID"
    type: number
    sql:${TABLE}.Trackid;;
  }
  dimension: Countryid{
    label:"Country ID"
    type: number
    sql:${TABLE}.Countryid;;
  }
  dimension: Transactiontypeid{
    label:"Transactiontype ID"
    type: number
    sql:${TABLE}.Transactiontypeid;;
  }
  dimension: Zipid{
    label:"Zip ID"
    type: number
    sql:${TABLE}.Zipid;;
  }
  dimension: Catalogid{
    label:"Catalog ID"
    type: number
    sql:${TABLE}.Catalogid;;
  }
  dimension: Isrcid{
    label:"Isrc ID"
    type: number
    sql:${TABLE}.Isrcid;;
  }
  dimension: Imprintid{
    label:"Imprint ID"
    type: number
    sql:${TABLE}.Imprintid;;
  }
  dimension: Currencyid{
    label:"Currency ID"
    type: number
    sql:${TABLE}.Currencyid;;
  }
  dimension: Storeuserid{
    label:"Store user ID(number)"
    type: number
    sql:${TABLE}.Storeuserid;;
  }
  dimension_group: Processeddaytime{
    label:"Processed day time"
    type: time
    sql:${TABLE}.Processeddaytime;;
    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]
  }
  measure: Royalty{
    label:"Royalty"
    type: sum
    sql:${TABLE}.Royalty;;
  }
  measure: Royaltydollar{
    label:"Royalty dollar"
    type: sum
    sql:${TABLE}.Royaltydollar;;
  }
  measure: Units{
    label:"Units"
    type: sum
    sql:${TABLE}.Units;;
  }
  measure: Paidunits{
    label:"Paid units"
    type: sum
    sql:${TABLE}.Paidunits;;
  }
  measure: Freeunits{
    label:"Free units"
    type: sum
    sql:${TABLE}.Freeunits;;
  }
  dimension: Uuid{
    label:"Uuid"
    type: string
    sql:${TABLE}.Uuid;;
  }
  dimension: Subaccountid{
    label:"Subaccount ID"
    type: number
    sql:${TABLE}.Subaccountid;;
  }
  dimension_group: Download_activity_date{
    label:"Download activity date"
    type: time
    sql:${TABLE}.Download_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: Formatid{
    label:"Format ID"
    type: number
    sql:${TABLE}.Formatid;;
  }
  dimension: Listenduration{
    label:"Listen duration"
    type: number
    sql:${TABLE}.Listenduration;;
  }
  dimension: Playlistid{
    label:"Playlist ID"
    type: number
    sql:${TABLE}.Playlistid;;
  }
  dimension: Sourcetypeid{
    label:"Source type ID"
    type: number
    sql:${TABLE}.Sourcetypeid;;
  }
  dimension: Containertypeid{
    label:"Container type ID"
    type: number
    sql:${TABLE}.Containertypeid;;
  }
  dimension_group: Reportdate{
    label:"Report date"
    type: time
    sql:${TABLE}.Reportdate;;
    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: Stagingrawid{
    label:"Staging raw ID"
    type: number
    sql:${TABLE}.Stagingrawid;;
  }
  dimension: Feedid{
    label:"Feed ID"
    type: number
    sql:${TABLE}.Feedid;;
  }
  dimension: Userid{
    label:"User ID"
    type: number
    sql:${TABLE}.Userid;;
  }
  dimension: Storeuserid_varchar{
    label:"Store user ID(string)"
    type: string
    sql:${TABLE}.Storeuserid_varchar;;
  }
  dimension: Licensorid{
    label:"Licensor ID"
    type: number
    sql:${TABLE}.Licensorid;;
  }
  dimension: Regioncode{
    label:"Region code"
    type: string
    sql:${TABLE}.Regioncode;;
  }
  dimension: Subscriptionpaytierid{
    label:"Subscription pay tier ID"
    type: number
    sql:${TABLE}.Subscriptionpaytierid;;
  }
  dimension: Subscriptiontypeid{
    label:"Subscription type ID"
    type: number
    sql:${TABLE}.Subscriptiontypeid;;
  }
  dimension: Osid{
    label:"Osid"
    type: number
    sql:${TABLE}.Osid;;
  }
  dimension: Deviceid{
    label:"Device ID"
    type: number
    sql:${TABLE}.Deviceid;;
  }

}