Positionarrest

view: positionarrest {
  sql_table_name: POSITIONARREST ;;

  dimension: accaccruedinterests {
    type: number
    sql: ${TABLE}.ACCACCRUEDINTERESTS ;;
  }

  dimension: accountarrest {
    type: int
    sql: ${TABLE}.ACCOUNTARREST ;;
  }

  dimension: accountingusage {
    type: number
    sql: ${TABLE}.ACCOUNTINGUSAGE ;;
  }

  dimension: accountrealized {
    type: number
    sql: ${TABLE}.ACCOUNTREALIZED ;;
  }

  dimension: accountunrealized {
    type: number
    sql: ${TABLE}.ACCOUNTUNREALIZED ;;
  }

  dimension: accountvalue {
    type: number
    sql: ${TABLE}.ACCOUNTVALUE ;;
  }

  dimension: amount {
    type: number
    sql: ${TABLE}.AMOUNT ;;
  }

  dimension: assetflow {
    type: number
    sql: ${TABLE}.ASSETFLOW ;;
  }

  dimension: assetlocalflow {
    type: number
    sql: ${TABLE}.ASSETLOCALFLOW ;;
  }

  dimension: baseaccruedinterests {
    type: number
    sql: ${TABLE}.BASEACCRUEDINTERESTS ;;
  }

  dimension: basecostpershare {
    type: number
    sql: ${TABLE}.BASECOSTPERSHARE ;;
  }

  dimension: basecosttotal {
    type: number
    sql: ${TABLE}.BASECOSTTOTAL ;;
  }

  dimension: basedeposit {
    type: number
    sql: ${TABLE}.BASEDEPOSIT ;;
  }

  dimension: basedividend {
    type: number
    sql: ${TABLE}.BASEDIVIDEND ;;
  }

  dimension: baseexposure {
    type: number
    sql: ${TABLE}.BASEEXPOSURE ;;
  }

  dimension: baseinitinvestment {
    type: number
    sql: ${TABLE}.BASEINITINVESTMENT ;;
  }

  dimension: baserealized {
    type: number
    sql: ${TABLE}.BASEREALIZED ;;
  }

  dimension: baseunrealized {
    type: number
    sql: ${TABLE}.BASEUNREALIZED ;;
  }

  dimension: basevalue {
    type: number
    sql: ${TABLE}.BASEVALUE ;;
  }

  dimension: bombasevalue {
    type: number
    sql: ${TABLE}.BOMBASEVALUE ;;
  }

  dimension: bomvalue {
    type: number
    sql: ${TABLE}.BOMVALUE ;;
  }

  dimension: cashflow {
    type: number
    sql: ${TABLE}.CASHFLOW ;;
  }

  dimension: cashflowperiod {
    type: number
    sql: ${TABLE}.CASHFLOWPERIOD ;;
  }

  dimension: closeaccamount {
    type: number
    sql: ${TABLE}.CLOSEACCAMOUNT ;;
  }

  dimension: closebaseamount {
    type: number
    sql: ${TABLE}.CLOSEBASEAMOUNT ;;
  }

  dimension: closespotname {
    sql: ${TABLE}.CLOSESPOTNAME ;;
  }

  dimension: closetransamount {
    type: number
    sql: ${TABLE}.CLOSETRANSAMOUNT ;;
  }

  dimension: closetranskey {
    type: int
    sql: ${TABLE}.CLOSETRANSKEY ;;
  }

  dimension: closetransprice {
    type: number
    sql: ${TABLE}.CLOSETRANSPRICE ;;
  }

  dimension: closetransspot {
    type: number
    sql: ${TABLE}.CLOSETRANSSPOT ;;
  }

  dimension: dividend {
    type: number
    sql: ${TABLE}.DIVIDEND ;;
  }

  dimension: equalizationfactor {
    type: number
    sql: ${TABLE}.EQUALIZATIONFACTOR ;;
  }

  dimension: evalratio {
    type: number
    sql: ${TABLE}.EVALRATIO ;;
  }

  dimension: fxaccrealized {
    type: number
    sql: ${TABLE}.FXACCREALIZED ;;
  }

  dimension: fxaccunrealized {
    type: number
    sql: ${TABLE}.FXACCUNREALIZED ;;
  }

  dimension: fxbaseunrealized {
    type: number
    sql: ${TABLE}.FXBASEUNREALIZED ;;
  }

  dimension: lastnav {
    type: number
    sql: ${TABLE}.LASTNAV ;;
  }

  dimension: lastnavsource {
    type: int
    sql: ${TABLE}.LASTNAVSOURCE ;;
  }

  dimension: lastnavstatus {
    sql: ${TABLE}.LASTNAVSTATUS ;;
  }

  dimension: lastspot {
    type: number
    sql: ${TABLE}.LASTSPOT ;;
  }

  dimension: lastspotname {
    sql: ${TABLE}.LASTSPOTNAME ;;
  }

  dimension: levgross {
    type: number
    sql: ${TABLE}.LEVGROSS ;;
  }

  dimension: levlong {
    type: number
    sql: ${TABLE}.LEVLONG ;;
  }

  dimension: levnet {
    type: number
    sql: ${TABLE}.LEVNET ;;
  }

  dimension: levshort {
    type: number
    sql: ${TABLE}.LEVSHORT ;;
  }

  dimension: localaccruedinterests {
    type: number
    sql: ${TABLE}.LOCALACCRUEDINTERESTS ;;
  }

  dimension: localcashflow {
    type: number
    sql: ${TABLE}.LOCALCASHFLOW ;;
  }

  dimension: localcashflowperiod {
    type: number
    sql: ${TABLE}.LOCALCASHFLOWPERIOD ;;
  }

  dimension: localcostpershare {
    type: number
    sql: ${TABLE}.LOCALCOSTPERSHARE ;;
  }

  dimension: localcosttotal {
    type: number
    sql: ${TABLE}.LOCALCOSTTOTAL ;;
  }

  dimension: localdeposit {
    type: number
    sql: ${TABLE}.LOCALDEPOSIT ;;
  }

  dimension: localexposure {
    type: number
    sql: ${TABLE}.LOCALEXPOSURE ;;
  }

  dimension: localinitinvestment {
    type: number
    sql: ${TABLE}.LOCALINITINVESTMENT ;;
  }

  dimension: localpnlvardtd {
    type: number
    sql: ${TABLE}.LOCALPNLVARDTD ;;
  }

  dimension: localpnlvarmtd {
    type: number
    sql: ${TABLE}.LOCALPNLVARMTD ;;
  }

  dimension: localpnlvarq {
    type: number
    sql: ${TABLE}.LOCALPNLVARQ ;;
  }

  dimension: localpnlvarsi {
    type: number
    sql: ${TABLE}.LOCALPNLVARSI ;;
  }

  dimension: localpnlvarsmtd {
    type: number
    sql: ${TABLE}.LOCALPNLVARSMTD ;;
  }

  dimension: localpnlvarwtd {
    type: number
    sql: ${TABLE}.LOCALPNLVARWTD ;;
  }

  dimension: localpnlvarytd {
    type: number
    sql: ${TABLE}.LOCALPNLVARYTD ;;
  }

  dimension: localrealized {
    type: number
    sql: ${TABLE}.LOCALREALIZED ;;
  }

  dimension: localrordivisor {
    type: number
    sql: ${TABLE}.LOCALRORDIVISOR ;;
  }

  dimension: localrordivisordtd {
    type: number
    sql: ${TABLE}.LOCALRORDIVISORDTD ;;
  }

  dimension: localrordivisorq {
    type: number
    sql: ${TABLE}.LOCALRORDIVISORQ ;;
  }

  dimension: localrordivisorsi {
    type: number
    sql: ${TABLE}.LOCALRORDIVISORSI ;;
  }

  dimension: localrordivisorsmtd {
    type: number
    sql: ${TABLE}.LOCALRORDIVISORSMTD ;;
  }

  dimension: localrordivisorwtd {
    type: number
    sql: ${TABLE}.LOCALRORDIVISORWTD ;;
  }

  dimension: localrordivisorytd {
    type: number
    sql: ${TABLE}.LOCALRORDIVISORYTD ;;
  }

  dimension: localrordtd {
    type: number
    sql: ${TABLE}.LOCALRORDTD ;;
  }

  dimension: localrormtd {
    type: number
    sql: ${TABLE}.LOCALRORMTD ;;
  }

  dimension: localrorq {
    type: number
    sql: ${TABLE}.LOCALRORQ ;;
  }

  dimension: localrorsi {
    type: number
    sql: ${TABLE}.LOCALRORSI ;;
  }

  dimension: localrorsmtd {
    type: number
    sql: ${TABLE}.LOCALRORSMTD ;;
  }

  dimension: localrorwtd {
    type: number
    sql: ${TABLE}.LOCALRORWTD ;;
  }

  dimension: localrorytd {
    type: number
    sql: ${TABLE}.LOCALRORYTD ;;
  }

  dimension: localunrealized {
    type: number
    sql: ${TABLE}.LOCALUNREALIZED ;;
  }

  dimension: localvalue {
    type: number
    sql: ${TABLE}.LOCALVALUE ;;
  }

  dimension: newbaseptd {
    type: number
    sql: ${TABLE}.NEWBASEPTD ;;
  }

  dimension: newlocalptd {
    type: number
    sql: ${TABLE}.NEWLOCALPTD ;;
  }

  dimension: oldbaseptd {
    type: number
    sql: ${TABLE}.OLDBASEPTD ;;
  }

  dimension: oldlocalptd {
    type: number
    sql: ${TABLE}.OLDLOCALPTD ;;
  }

  dimension: openaccamount {
    type: number
    sql: ${TABLE}.OPENACCAMOUNT ;;
  }

  dimension: openbaseamount {
    type: number
    sql: ${TABLE}.OPENBASEAMOUNT ;;
  }

  dimension: openlinkedop {
    type: int
    sql: ${TABLE}.OPENLINKEDOP ;;
  }

  dimension: openquantity {
    type: number
    sql: ${TABLE}.OPENQUANTITY ;;
  }

  dimension: openspotname {
    sql: ${TABLE}.OPENSPOTNAME ;;
  }

  dimension: opentransamount {
    type: number
    sql: ${TABLE}.OPENTRANSAMOUNT ;;
  }

  dimension: opentranskey {
    type: int
    sql: ${TABLE}.OPENTRANSKEY ;;
  }

  dimension: opentransprice {
    type: number
    sql: ${TABLE}.OPENTRANSPRICE ;;
  }

  dimension: opentransspot {
    type: number
    sql: ${TABLE}.OPENTRANSSPOT ;;
  }

  dimension: pnlvardtd {
    type: number
    sql: ${TABLE}.PNLVARDTD ;;
  }

  dimension: pnlvarmtd {
    type: number
    sql: ${TABLE}.PNLVARMTD ;;
  }

  dimension: pnlvarq {
    type: number
    sql: ${TABLE}.PNLVARQ ;;
  }

  dimension: pnlvarsi {
    type: number
    sql: ${TABLE}.PNLVARSI ;;
  }

  dimension: pnlvarsmtd {
    type: number
    sql: ${TABLE}.PNLVARSMTD ;;
  }

  dimension: pnlvarwtd {
    type: number
    sql: ${TABLE}.PNLVARWTD ;;
  }

  dimension: pnlvarytd {
    type: number
    sql: ${TABLE}.PNLVARYTD ;;
  }

  dimension: poarefkey {
    type: int
    sql: ${TABLE}.POAREFKEY ;;
  }

  dimension: poaseedid {
    type: int
    sql: ${TABLE}.POASEEDID ;;
  }

  dimension: position {
    type: int
    sql: ${TABLE}.POSITION ;;
  }

  dimension: positiontype {
    type: int
    sql: ${TABLE}.POSITIONTYPE ;;
  }

  dimension: quantity {
    type: number
    sql: ${TABLE}.QUANTITY ;;
  }

  dimension: realflow {
    type: number
    sql: ${TABLE}.REALFLOW ;;
  }

  dimension: reallocalflow {
    type: number
    sql: ${TABLE}.REALLOCALFLOW ;;
  }

  dimension: rordivisor {
    type: number
    sql: ${TABLE}.RORDIVISOR ;;
  }

  dimension: rordivisordtd {
    type: number
    sql: ${TABLE}.RORDIVISORDTD ;;
  }

  dimension: rordivisorq {
    type: number
    sql: ${TABLE}.RORDIVISORQ ;;
  }

  dimension: rordivisorsi {
    type: number
    sql: ${TABLE}.RORDIVISORSI ;;
  }

  dimension: rordivisorsmtd {
    type: number
    sql: ${TABLE}.RORDIVISORSMTD ;;
  }

  dimension: rordivisorwtd {
    type: number
    sql: ${TABLE}.RORDIVISORWTD ;;
  }

  dimension: rordivisorytd {
    type: number
    sql: ${TABLE}.RORDIVISORYTD ;;
  }

  dimension: rordtd {
    type: number
    sql: ${TABLE}.RORDTD ;;
  }

  dimension: rormtd {
    type: number
    sql: ${TABLE}.RORMTD ;;
  }

  dimension: rorq {
    type: number
    sql: ${TABLE}.RORQ ;;
  }

  dimension: rorsi {
    type: number
    sql: ${TABLE}.RORSI ;;
  }

  dimension: rorsmtd {
    type: number
    sql: ${TABLE}.RORSMTD ;;
  }

  dimension: rorwtd {
    type: number
    sql: ${TABLE}.RORWTD ;;
  }

  dimension: rorytd {
    type: number
    sql: ${TABLE}.RORYTD ;;
  }

  dimension: security {
    type: int
    sql: ${TABLE}.SECURITY ;;
  }

  dimension: securitycur {
    sql: ${TABLE}.SECURITYCUR ;;
  }

  dimension: special_ {
    type: int
    sql: ${TABLE}.SPECIAL_ ;;
  }

  dimension: spotrealized {
    type: number
    sql: ${TABLE}.SPOTREALIZED ;;
  }

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

  dimension: switchratios {
    sql: ${TABLE}.SWITCHRATIOS ;;
  }

  dimension: switchtrans {
    type: int
    sql: ${TABLE}.SWITCHTRANS ;;
  }

  dimension: weight {
    type: number
    sql: ${TABLE}.WEIGHT ;;
  }

  dimension: weightedperfcap {
    type: number
    sql: ${TABLE}.WEIGHTEDPERFCAP ;;
  }

  dimension: weightedperffx {
    type: number
    sql: ${TABLE}.WEIGHTEDPERFFX ;;
  }

  dimension: weightedperfhedge {
    type: number
    sql: ${TABLE}.WEIGHTEDPERFHEDGE ;;
  }

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [openspotname, closespotname, lastspotname]
  }

  measure: sum_weight {
    type: sum
    value_format: "0.00%"
    sql: ${weight} ;;
  }

  measure: sum_localvalue {
    type: sum
    sql: ${localvalue} ;;
  }

  measure: sum_basevalue {
    type: sum
    sql: ${basevalue} ;;
  }

  measure: sum_pnlvarmtd {
    type: sum
    sql: ${pnlvarmtd} ;;
  }

  measure: sum_pnlvarytd {
    type: sum
    sql: ${pnlvarytd} ;;
  }
}

- view: positionarrest
  sql_table_name: POSITIONARREST
  fields:
  - dimension: accaccruedinterests
    type: number
    sql: ${TABLE}.ACCACCRUEDINTERESTS
  - dimension: accountarrest
    type: int
    sql: ${TABLE}.ACCOUNTARREST
  - dimension: accountingusage
    type: number
    sql: ${TABLE}.ACCOUNTINGUSAGE
  - dimension: accountrealized
    type: number
    sql: ${TABLE}.ACCOUNTREALIZED
  - dimension: accountunrealized
    type: number
    sql: ${TABLE}.ACCOUNTUNREALIZED
  - dimension: accountvalue
    type: number
    sql: ${TABLE}.ACCOUNTVALUE
  - dimension: amount
    type: number
    sql: ${TABLE}.AMOUNT
  - dimension: assetflow
    type: number
    sql: ${TABLE}.ASSETFLOW
  - dimension: assetlocalflow
    type: number
    sql: ${TABLE}.ASSETLOCALFLOW
  - dimension: baseaccruedinterests
    type: number
    sql: ${TABLE}.BASEACCRUEDINTERESTS
  - dimension: basecostpershare
    type: number
    sql: ${TABLE}.BASECOSTPERSHARE
  - dimension: basecosttotal
    type: number
    sql: ${TABLE}.BASECOSTTOTAL
  - dimension: basedeposit
    type: number
    sql: ${TABLE}.BASEDEPOSIT
  - dimension: basedividend
    type: number
    sql: ${TABLE}.BASEDIVIDEND
  - dimension: baseexposure
    type: number
    sql: ${TABLE}.BASEEXPOSURE
  - dimension: baseinitinvestment
    type: number
    sql: ${TABLE}.BASEINITINVESTMENT
  - dimension: baserealized
    type: number
    sql: ${TABLE}.BASEREALIZED
  - dimension: baseunrealized
    type: number
    sql: ${TABLE}.BASEUNREALIZED
  - dimension: basevalue
    type: number
    sql: ${TABLE}.BASEVALUE
  - dimension: bombasevalue
    type: number
    sql: ${TABLE}.BOMBASEVALUE
  - dimension: bomvalue
    type: number
    sql: ${TABLE}.BOMVALUE
  - dimension: cashflow
    type: number
    sql: ${TABLE}.CASHFLOW
  - dimension: cashflowperiod
    type: number
    sql: ${TABLE}.CASHFLOWPERIOD
  - dimension: closeaccamount
    type: number
    sql: ${TABLE}.CLOSEACCAMOUNT
  - dimension: closebaseamount
    type: number
    sql: ${TABLE}.CLOSEBASEAMOUNT
  - dimension: closespotname
    sql: ${TABLE}.CLOSESPOTNAME
  - dimension: closetransamount
    type: number
    sql: ${TABLE}.CLOSETRANSAMOUNT
  - dimension: closetranskey
    type: int
    sql: ${TABLE}.CLOSETRANSKEY
  - dimension: closetransprice
    type: number
    sql: ${TABLE}.CLOSETRANSPRICE
  - dimension: closetransspot
    type: number
    sql: ${TABLE}.CLOSETRANSSPOT
  - dimension: dividend
    type: number
    sql: ${TABLE}.DIVIDEND
  - dimension: equalizationfactor
    type: number
    sql: ${TABLE}.EQUALIZATIONFACTOR
  - dimension: evalratio
    type: number
    sql: ${TABLE}.EVALRATIO
  - dimension: fxaccrealized
    type: number
    sql: ${TABLE}.FXACCREALIZED
  - dimension: fxaccunrealized
    type: number
    sql: ${TABLE}.FXACCUNREALIZED
  - dimension: fxbaseunrealized
    type: number
    sql: ${TABLE}.FXBASEUNREALIZED
  - dimension: lastnav
    type: number
    sql: ${TABLE}.LASTNAV
  - dimension: lastnavsource
    type: int
    sql: ${TABLE}.LASTNAVSOURCE
  - dimension: lastnavstatus
    sql: ${TABLE}.LASTNAVSTATUS
  - dimension: lastspot
    type: number
    sql: ${TABLE}.LASTSPOT
  - dimension: lastspotname
    sql: ${TABLE}.LASTSPOTNAME
  - dimension: levgross
    type: number
    sql: ${TABLE}.LEVGROSS
  - dimension: levlong
    type: number
    sql: ${TABLE}.LEVLONG
  - dimension: levnet
    type: number
    sql: ${TABLE}.LEVNET
  - dimension: levshort
    type: number
    sql: ${TABLE}.LEVSHORT
  - dimension: localaccruedinterests
    type: number
    sql: ${TABLE}.LOCALACCRUEDINTERESTS
  - dimension: localcashflow
    type: number
    sql: ${TABLE}.LOCALCASHFLOW
  - dimension: localcashflowperiod
    type: number
    sql: ${TABLE}.LOCALCASHFLOWPERIOD
  - dimension: localcostpershare
    type: number
    sql: ${TABLE}.LOCALCOSTPERSHARE
  - dimension: localcosttotal
    type: number
    sql: ${TABLE}.LOCALCOSTTOTAL
  - dimension: localdeposit
    type: number
    sql: ${TABLE}.LOCALDEPOSIT
  - dimension: localexposure
    type: number
    sql: ${TABLE}.LOCALEXPOSURE
  - dimension: localinitinvestment
    type: number
    sql: ${TABLE}.LOCALINITINVESTMENT
  - dimension: localpnlvardtd
    type: number
    sql: ${TABLE}.LOCALPNLVARDTD
  - dimension: localpnlvarmtd
    type: number
    sql: ${TABLE}.LOCALPNLVARMTD
  - dimension: localpnlvarq
    type: number
    sql: ${TABLE}.LOCALPNLVARQ
  - dimension: localpnlvarsi
    type: number
    sql: ${TABLE}.LOCALPNLVARSI
  - dimension: localpnlvarsmtd
    type: number
    sql: ${TABLE}.LOCALPNLVARSMTD
  - dimension: localpnlvarwtd
    type: number
    sql: ${TABLE}.LOCALPNLVARWTD
  - dimension: localpnlvarytd
    type: number
    sql: ${TABLE}.LOCALPNLVARYTD
  - dimension: localrealized
    type: number
    sql: ${TABLE}.LOCALREALIZED
  - dimension: localrordivisor
    type: number
    sql: ${TABLE}.LOCALRORDIVISOR
  - dimension: localrordivisordtd
    type: number
    sql: ${TABLE}.LOCALRORDIVISORDTD
  - dimension: localrordivisorq
    type: number
    sql: ${TABLE}.LOCALRORDIVISORQ
  - dimension: localrordivisorsi
    type: number
    sql: ${TABLE}.LOCALRORDIVISORSI
  - dimension: localrordivisorsmtd
    type: number
    sql: ${TABLE}.LOCALRORDIVISORSMTD
  - dimension: localrordivisorwtd
    type: number
    sql: ${TABLE}.LOCALRORDIVISORWTD
  - dimension: localrordivisorytd
    type: number
    sql: ${TABLE}.LOCALRORDIVISORYTD
  - dimension: localrordtd
    type: number
    sql: ${TABLE}.LOCALRORDTD
  - dimension: localrormtd
    type: number
    sql: ${TABLE}.LOCALRORMTD
  - dimension: localrorq
    type: number
    sql: ${TABLE}.LOCALRORQ
  - dimension: localrorsi
    type: number
    sql: ${TABLE}.LOCALRORSI
  - dimension: localrorsmtd
    type: number
    sql: ${TABLE}.LOCALRORSMTD
  - dimension: localrorwtd
    type: number
    sql: ${TABLE}.LOCALRORWTD
  - dimension: localrorytd
    type: number
    sql: ${TABLE}.LOCALRORYTD
  - dimension: localunrealized
    type: number
    sql: ${TABLE}.LOCALUNREALIZED
  - dimension: localvalue
    type: number
    sql: ${TABLE}.LOCALVALUE
  - dimension: newbaseptd
    type: number
    sql: ${TABLE}.NEWBASEPTD
  - dimension: newlocalptd
    type: number
    sql: ${TABLE}.NEWLOCALPTD
  - dimension: oldbaseptd
    type: number
    sql: ${TABLE}.OLDBASEPTD
  - dimension: oldlocalptd
    type: number
    sql: ${TABLE}.OLDLOCALPTD
  - dimension: openaccamount
    type: number
    sql: ${TABLE}.OPENACCAMOUNT
  - dimension: openbaseamount
    type: number
    sql: ${TABLE}.OPENBASEAMOUNT
  - dimension: openlinkedop
    type: int
    sql: ${TABLE}.OPENLINKEDOP
  - dimension: openquantity
    type: number
    sql: ${TABLE}.OPENQUANTITY
  - dimension: openspotname
    sql: ${TABLE}.OPENSPOTNAME
  - dimension: opentransamount
    type: number
    sql: ${TABLE}.OPENTRANSAMOUNT
  - dimension: opentranskey
    type: int
    sql: ${TABLE}.OPENTRANSKEY
  - dimension: opentransprice
    type: number
    sql: ${TABLE}.OPENTRANSPRICE
  - dimension: opentransspot
    type: number
    sql: ${TABLE}.OPENTRANSSPOT
  - dimension: pnlvardtd
    type: number
    sql: ${TABLE}.PNLVARDTD
  - dimension: pnlvarmtd
    type: number
    sql: ${TABLE}.PNLVARMTD
  - dimension: pnlvarq
    type: number
    sql: ${TABLE}.PNLVARQ
  - dimension: pnlvarsi
    type: number
    sql: ${TABLE}.PNLVARSI
  - dimension: pnlvarsmtd
    type: number
    sql: ${TABLE}.PNLVARSMTD
  - dimension: pnlvarwtd
    type: number
    sql: ${TABLE}.PNLVARWTD
  - dimension: pnlvarytd
    type: number
    sql: ${TABLE}.PNLVARYTD
  - dimension: poarefkey
    type: int
    sql: ${TABLE}.POAREFKEY
  - dimension: poaseedid
    type: int
    sql: ${TABLE}.POASEEDID
  - dimension: position
    type: int
    sql: ${TABLE}.POSITION
  - dimension: positiontype
    type: int
    sql: ${TABLE}.POSITIONTYPE
  - dimension: quantity
    type: number
    sql: ${TABLE}.QUANTITY
  - dimension: realflow
    type: number
    sql: ${TABLE}.REALFLOW
  - dimension: reallocalflow
    type: number
    sql: ${TABLE}.REALLOCALFLOW
  - dimension: rordivisor
    type: number
    sql: ${TABLE}.RORDIVISOR
  - dimension: rordivisordtd
    type: number
    sql: ${TABLE}.RORDIVISORDTD
  - dimension: rordivisorq
    type: number
    sql: ${TABLE}.RORDIVISORQ
  - dimension: rordivisorsi
    type: number
    sql: ${TABLE}.RORDIVISORSI
  - dimension: rordivisorsmtd
    type: number
    sql: ${TABLE}.RORDIVISORSMTD
  - dimension: rordivisorwtd
    type: number
    sql: ${TABLE}.RORDIVISORWTD
  - dimension: rordivisorytd
    type: number
    sql: ${TABLE}.RORDIVISORYTD
  - dimension: rordtd
    type: number
    sql: ${TABLE}.RORDTD
  - dimension: rormtd
    type: number
    sql: ${TABLE}.RORMTD
  - dimension: rorq
    type: number
    sql: ${TABLE}.RORQ
  - dimension: rorsi
    type: number
    sql: ${TABLE}.RORSI
  - dimension: rorsmtd
    type: number
    sql: ${TABLE}.RORSMTD
  - dimension: rorwtd
    type: number
    sql: ${TABLE}.RORWTD
  - dimension: rorytd
    type: number
    sql: ${TABLE}.RORYTD
  - dimension: security
    type: int
    sql: ${TABLE}.SECURITY
  - dimension: securitycur
    sql: ${TABLE}.SECURITYCUR
  - dimension: special_
    type: int
    sql: ${TABLE}.SPECIAL_
  - dimension: spotrealized
    type: number
    sql: ${TABLE}.SPOTREALIZED
  - dimension: status
    sql: ${TABLE}.STATUS
  - dimension: switchratios
    sql: ${TABLE}.SWITCHRATIOS
  - dimension: switchtrans
    type: int
    sql: ${TABLE}.SWITCHTRANS
  - dimension: weight
    type: number
    sql: ${TABLE}.WEIGHT
  - dimension: weightedperfcap
    type: number
    sql: ${TABLE}.WEIGHTEDPERFCAP
  - dimension: weightedperffx
    type: number
    sql: ${TABLE}.WEIGHTEDPERFFX
  - dimension: weightedperfhedge
    type: number
    sql: ${TABLE}.WEIGHTEDPERFHEDGE
  - dimension_group: closedate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.CLOSEDATE
  - dimension_group: expirationdate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.EXPIRATIONDATE
  - dimension_group: intinvestdate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.INTINVESTDATE
  - dimension_group: lastnavdate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.LASTNAVDATE
  - dimension_group: lastnavpostdate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.LASTNAVPOSTDATE
  - dimension_group: lastspotdate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.LASTSPOTDATE
  - dimension_group: opendate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.OPENDATE
  - measure: count
    type: count
    drill_fields:
    - openspotname
    - closespotname
    - lastspotname
  - measure: sum_weight
    type: sum
    value_format: '0.00%'
    sql: ${weight}
  - measure: sum_localvalue
    type: sum
    sql: ${localvalue}
  - measure: sum_basevalue
    type: sum
    sql: ${basevalue}
  - measure: sum_pnlvarmtd
    type: sum
    sql: ${pnlvarmtd}
  - measure: sum_pnlvarytd
    type: sum
    sql: ${pnlvarytd}