Security

view: security {
  sql_table_name: SECURITY ;;

  dimension: active {
    type: number
    sql: ${TABLE}.ACTIVE ;;
  }

  dimension: alias {
    sql: ${TABLE}.ALIAS ;;
  }

  dimension: analyst {
    type: int
    sql: ${TABLE}.ANALYST ;;
  }

  dimension: autocalculated {
    type: number
    sql: ${TABLE}.AUTOCALCULATED ;;
  }

  dimension: bloomberg {
    sql: ${TABLE}.BLOOMBERG ;;
  }

  dimension: bulksize {
    type: number
    sql: ${TABLE}.BULKSIZE ;;
  }

  dimension: classid {
    type: int
    sql: ${TABLE}.CLASSID ;;
  }

  dimension: coanalyst {
    type: int
    sql: ${TABLE}.COANALYST ;;
  }

  dimension: comments {
    sql: ${TABLE}.COMMENTS ;;
  }

  dimension: country {
    type: int
    sql: ${TABLE}.COUNTRY ;;
  }

  dimension: currency_ {
    sql: ${TABLE}.CURRENCY_ ;;
  }

  dimension: cusip {
    sql: ${TABLE}.CUSIP ;;
  }

  dimension: defaultcolor {
    type: int
    sql: ${TABLE}.DEFAULTCOLOR ;;
  }

  dimension: description_ {
    sql: ${TABLE}.DESCRIPTION_ ;;
  }

  dimension: extid {
    sql: ${TABLE}.EXTID ;;
  }

  dimension: father {
    type: int
    sql: ${TABLE}.FATHER ;;
  }

  dimension: fatherflags {
    type: int
    sql: ${TABLE}.FATHERFLAGS ;;
  }

  dimension: fathertype {
    sql: ${TABLE}.FATHERTYPE ;;
  }

  dimension: flag0 {
    type: int
    sql: ${TABLE}.FLAG0 ;;
  }

  dimension: flag1 {
    type: int
    sql: ${TABLE}.FLAG1 ;;
  }

  dimension: flag2 {
    type: int
    sql: ${TABLE}.FLAG2 ;;
  }

  dimension: flag3 {
    type: int
    sql: ${TABLE}.FLAG3 ;;
  }

  dimension: flag4 {
    type: int
    sql: ${TABLE}.FLAG4 ;;
  }

  dimension: flags4_eyes {
    type: int
    sql: ${TABLE}.FLAGS4EYES ;;
  }

  dimension: flatcomments {
    sql: ${TABLE}.FLATCOMMENTS ;;
  }

  dimension: inceptionvalue {
    type: number
    sql: ${TABLE}.INCEPTIONVALUE ;;
  }

  dimension: inherits {
    type: int
    sql: ${TABLE}.INHERITS ;;
  }

  dimension: isin {
    sql: ${TABLE}.ISIN ;;
  }

  dimension: issuer {
    type: int
    sql: ${TABLE}.ISSUER ;;
  }

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

  dimension: navtype {
    sql: ${TABLE}.NAVTYPE ;;
  }

  dimension: offshorename {
    sql: ${TABLE}.OFFSHORENAME ;;
  }

  dimension: offshorevehicule {
    type: number
    sql: ${TABLE}.OFFSHOREVEHICULE ;;
  }

  dimension: oldsubtype {
    sql: ${TABLE}.OLDSUBTYPE ;;
  }

  dimension: quotationtype {
    type: int
    sql: ${TABLE}.QUOTATIONTYPE ;;
  }

  dimension: quoteprovider {
    type: int
    sql: ${TABLE}.QUOTEPROVIDER ;;
  }

  dimension: ratings {
    type: int
    sql: ${TABLE}.RATINGS ;;
  }

  dimension: ratingstype {
    type: int
    sql: ${TABLE}.RATINGSTYPE ;;
  }

  dimension: ric {
    sql: ${TABLE}.RIC ;;
  }

  dimension: securityoptions {
    type: int
    sql: ${TABLE}.SECURITYOPTIONS ;;
  }

  dimension: securityseedid {
    type: int
    sql: ${TABLE}.SECURITYSEEDID ;;
  }

  dimension: serverpath {
    type: int
    sql: ${TABLE}.SERVERPATH ;;
  }

  dimension: sponsor {
    type: int
    sql: ${TABLE}.SPONSOR ;;
  }

  dimension: status {
    sql: ${TABLE}.STATUS ;;
  }

  dimension: stockexchange {
    type: int
    sql: ${TABLE}.STOCKEXCHANGE ;;
  }

  dimension: stockmarket {
    type: int
    sql: ${TABLE}.STOCKMARKET ;;
  }

  dimension: subtype {
    type: int
    sql: ${TABLE}.SUBTYPE ;;
  }

  dimension: symbol {
    sql: ${TABLE}.SYMBOL ;;
  }

  dimension: synchro {
    type: number
    sql: ${TABLE}.SYNCHRO ;;
  }

  dimension: telekurs {
    sql: ${TABLE}.TELEKURS ;;
  }

  dimension: underlying {
    type: int
    sql: ${TABLE}.UNDERLYING ;;
  }

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}

- view: security
  sql_table_name: SECURITY
  fields:
  - dimension: active
    type: number
    sql: ${TABLE}.ACTIVE
  - dimension: alias
    sql: ${TABLE}.ALIAS
  - dimension: analyst
    type: int
    sql: ${TABLE}.ANALYST
  - dimension: autocalculated
    type: number
    sql: ${TABLE}.AUTOCALCULATED
  - dimension: bloomberg
    sql: ${TABLE}.BLOOMBERG
  - dimension: bulksize
    type: number
    sql: ${TABLE}.BULKSIZE
  - dimension: classid
    type: int
    sql: ${TABLE}.CLASSID
  - dimension: coanalyst
    type: int
    sql: ${TABLE}.COANALYST
  - dimension: comments
    sql: ${TABLE}.COMMENTS
  - dimension: country
    type: int
    sql: ${TABLE}.COUNTRY
  - dimension: currency_
    sql: ${TABLE}.CURRENCY_
  - dimension: cusip
    sql: ${TABLE}.CUSIP
  - dimension: defaultcolor
    type: int
    sql: ${TABLE}.DEFAULTCOLOR
  - dimension: description_
    sql: ${TABLE}.DESCRIPTION_
  - dimension: extid
    sql: ${TABLE}.EXTID
  - dimension: father
    type: int
    sql: ${TABLE}.FATHER
  - dimension: fatherflags
    type: int
    sql: ${TABLE}.FATHERFLAGS
  - dimension: fathertype
    sql: ${TABLE}.FATHERTYPE
  - dimension: flag0
    type: int
    sql: ${TABLE}.FLAG0
  - dimension: flag1
    type: int
    sql: ${TABLE}.FLAG1
  - dimension: flag2
    type: int
    sql: ${TABLE}.FLAG2
  - dimension: flag3
    type: int
    sql: ${TABLE}.FLAG3
  - dimension: flag4
    type: int
    sql: ${TABLE}.FLAG4
  - dimension: flags4_eyes
    type: int
    sql: ${TABLE}.FLAGS4EYES
  - dimension: flatcomments
    sql: ${TABLE}.FLATCOMMENTS
  - dimension: inceptionvalue
    type: number
    sql: ${TABLE}.INCEPTIONVALUE
  - dimension: inherits
    type: int
    sql: ${TABLE}.INHERITS
  - dimension: isin
    sql: ${TABLE}.ISIN
  - dimension: issuer
    type: int
    sql: ${TABLE}.ISSUER
  - dimension: name
    sql: ${TABLE}.NAME
  - dimension: navtype
    sql: ${TABLE}.NAVTYPE
  - dimension: offshorename
    sql: ${TABLE}.OFFSHORENAME
  - dimension: offshorevehicule
    type: number
    sql: ${TABLE}.OFFSHOREVEHICULE
  - dimension: oldsubtype
    sql: ${TABLE}.OLDSUBTYPE
  - dimension: quotationtype
    type: int
    sql: ${TABLE}.QUOTATIONTYPE
  - dimension: quoteprovider
    type: int
    sql: ${TABLE}.QUOTEPROVIDER
  - dimension: ratings
    type: int
    sql: ${TABLE}.RATINGS
  - dimension: ratingstype
    type: int
    sql: ${TABLE}.RATINGSTYPE
  - dimension: ric
    sql: ${TABLE}.RIC
  - dimension: securityoptions
    type: int
    sql: ${TABLE}.SECURITYOPTIONS
  - dimension: securityseedid
    type: int
    sql: ${TABLE}.SECURITYSEEDID
  - dimension: serverpath
    type: int
    sql: ${TABLE}.SERVERPATH
  - dimension: sponsor
    type: int
    sql: ${TABLE}.SPONSOR
  - dimension: status
    sql: ${TABLE}.STATUS
  - dimension: stockexchange
    type: int
    sql: ${TABLE}.STOCKEXCHANGE
  - dimension: stockmarket
    type: int
    sql: ${TABLE}.STOCKMARKET
  - dimension: subtype
    type: int
    sql: ${TABLE}.SUBTYPE
  - dimension: symbol
    sql: ${TABLE}.SYMBOL
  - dimension: synchro
    type: number
    sql: ${TABLE}.SYNCHRO
  - dimension: telekurs
    sql: ${TABLE}.TELEKURS
  - dimension: underlying
    type: int
    sql: ${TABLE}.UNDERLYING
  - dimension_group: confirmationdate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.CONFIRMATIONDATE
  - dimension_group: expirationdate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.EXPIRATIONDATE
  - dimension_group: inceptiondate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.INCEPTIONDATE
  - dimension_group: listingdate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.LISTINGDATE
  - dimension_group: quotationdate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.QUOTATIONDATE
  - measure: count
    type: count
    drill_fields:
    - detail*