Application

view: application {
  sql_table_name: applications.application ;;

  dimension: psk {
    type: int
    primary_key: yes
    sql: ${TABLE}.psk ;;
  }

  dimension: allowota {
    type: yesno
    sql: ${TABLE}.allowota ;;
  }

  dimension: apptype {
    type: int
    sql: ${TABLE}.apptype ;;
  }

  dimension: os_for_app {
    sql: CASE
  WHEN apptype in (0,2,4,7) THEN 'iOS'
  WHEN apptype in (3,5,8) THEN 'Android'
  WHEN apptype = 6 THEN 'BlackBerry'
  WHEN apptype in (9,10) then 'Windows'
  ELSE 'WebApp'
END ;;
  }

  dimension: bundleid {
    sql: ${TABLE}.bundleid ;;
  }

  dimension: bundlever {
    sql: ${TABLE}.bundlever ;;
  }

  dimension: detectedformfactor {
    type: number
    sql: ${TABLE}.detectedformfactor ;;
  }

  dimension: displaymessage {
    sql: ${TABLE}.displaymessage ;;
  }

  dimension: formfactor {
    type: number
    sql: ${TABLE}.formfactor ;;
  }

  dimension: formfactor_explained {
    sql: CASE
  WHEN formfactor = 0 THEN 'unknown'
  WHEN formfactor = 1 THEN 'phone'
  WHEN formfactor = 2 THEN 'tablet'
  WHEN formfactor = 3 THEN 'phone+tablet'
END ;;
  }

  dimension: is_adhoc {
    type: yesno
    sql: ${TABLE}.is_adhoc ;;
  }

  dimension: is_app_catalog {
    type: yesno
    sql: ${TABLE}.is_app_catalog ;;
  }

  dimension: is_critical {
    type: yesno
    sql: ${TABLE}.is_critical ;;
  }

  dimension: is_emailconfigprofile {
    type: yesno
    sql: ${TABLE}.is_emailconfigprofile ;;
  }

  dimension: is_formfactoroverridden {
    type: yesno
    sql: ${TABLE}.is_formfactoroverridden ;;
  }

  dimension: is_hybrid {
    type: yesno
    sql: ${TABLE}.is_hybrid ;;
  }

  dimension: longdescription {
    sql: ${TABLE}.longdescription ;;
  }

  dimension: minosver {
    sql: ${TABLE}.minosver ;;
  }

  dimension: name {
    sql: ${TABLE}.name ;;
  }

  dimension: operatingsystem {
    type: number
    sql: ${TABLE}.operatingsystem ;;
  }

  dimension: organization {
    type: int
    sql: ${TABLE}.organization ;;
  }

  dimension: osversion {
    sql: ${TABLE}.osversion ;;
  }

  dimension: platform {
    sql: ${TABLE}.platform ;;
  }

  dimension: required {
    type: yesno
    sql: ${TABLE}.required ;;
  }

  dimension: shortdescription {
    sql: ${TABLE}.shortdescription ;;
  }

  dimension: status {
    type: int
    sql: ${TABLE}.status ;;
  }

  dimension: upgradebundleid {
    sql: ${TABLE}.upgradebundleid ;;
  }

  dimension_group: deleted {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.deleted ;;
  }

  dimension_group: requiredby {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.requiredby ;;
  }

  measure: count {
    type: count
  }

  measure: count_name {
    type: count_distinct
    sql: ${name} ;;
  }
}

- view: application
  sql_table_name: applications.application
  fields:
  - dimension: psk
    type: int
    primary_key: true
    sql: ${TABLE}.psk
  - dimension: allowota
    type: yesno
    sql: ${TABLE}.allowota
  - dimension: apptype
    type: int
    sql: ${TABLE}.apptype
  - dimension: os_for_app
    sql: CASE
  WHEN apptype in (0,2,4,7) THEN 'iOS'
  WHEN apptype in (3,5,8) THEN 'Android'
  WHEN apptype = 6 THEN 'BlackBerry'
  WHEN apptype in (9,10) then 'Windows'
  ELSE 'WebApp'
END
  - dimension: bundleid
    sql: ${TABLE}.bundleid
  - dimension: bundlever
    sql: ${TABLE}.bundlever
  - dimension: detectedformfactor
    type: number
    sql: ${TABLE}.detectedformfactor
  - dimension: displaymessage
    sql: ${TABLE}.displaymessage
  - dimension: formfactor
    type: number
    sql: ${TABLE}.formfactor
  - dimension: formfactor_explained
    sql: CASE
  WHEN formfactor = 0 THEN 'unknown'
  WHEN formfactor = 1 THEN 'phone'
  WHEN formfactor = 2 THEN 'tablet'
  WHEN formfactor = 3 THEN 'phone+tablet'
END
  - dimension: is_adhoc
    type: yesno
    sql: ${TABLE}.is_adhoc
  - dimension: is_app_catalog
    type: yesno
    sql: ${TABLE}.is_app_catalog
  - dimension: is_critical
    type: yesno
    sql: ${TABLE}.is_critical
  - dimension: is_emailconfigprofile
    type: yesno
    sql: ${TABLE}.is_emailconfigprofile
  - dimension: is_formfactoroverridden
    type: yesno
    sql: ${TABLE}.is_formfactoroverridden
  - dimension: is_hybrid
    type: yesno
    sql: ${TABLE}.is_hybrid
  - dimension: longdescription
    sql: ${TABLE}.longdescription
  - dimension: minosver
    sql: ${TABLE}.minosver
  - dimension: name
    sql: ${TABLE}.name
  - dimension: operatingsystem
    type: number
    sql: ${TABLE}.operatingsystem
  - dimension: organization
    type: int
    sql: ${TABLE}.organization
  - dimension: osversion
    sql: ${TABLE}.osversion
  - dimension: platform
    sql: ${TABLE}.platform
  - dimension: required
    type: yesno
    sql: ${TABLE}.required
  - dimension: shortdescription
    sql: ${TABLE}.shortdescription
  - dimension: status
    type: int
    sql: ${TABLE}.status
  - dimension: upgradebundleid
    sql: ${TABLE}.upgradebundleid
  - dimension_group: deleted
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.deleted
  - dimension_group: requiredby
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.requiredby
  - measure: count
    type: count
  - measure: count_name
    type: count_distinct
    sql: ${name}