Position

view: position {
  sql_table_name: POSITION ;;

  dimension: account {
    type: int
    sql: ${TABLE}.ACCOUNT ;;
  }

  dimension: accountcur {
    sql: ${TABLE}.ACCOUNTCUR ;;
  }

  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: basedeposit {
    type: number
    sql: ${TABLE}.BASEDEPOSIT ;;
  }

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

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

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

  dimension: basepnl {
    type: number
    sql: ${TABLE}.BASEUNREALIZED+${TABLE}.BASEREALIZED ;;
  }

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

  dimension: closeaccountamount {
    type: number
    sql: ${TABLE}.CLOSEACCOUNTAMOUNT ;;
  }

  dimension: closeamount {
    type: number
    sql: ${TABLE}.CLOSEAMOUNT ;;
  }

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

  dimension: closeprice {
    type: number
    sql: ${TABLE}.CLOSEPRICE ;;
  }

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

  dimension: closespotprice {
    type: number
    sql: ${TABLE}.CLOSESPOTPRICE ;;
  }

  dimension: closetransaction {
    type: int
    sql: ${TABLE}.CLOSETRANSACTION ;;
  }

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

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

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

  dimension: fxbaserealized {
    type: number
    sql: ${TABLE}.FXBASEREALIZED ;;
  }

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

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

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

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

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

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

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

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

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

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

  dimension: openaccountamount {
    type: number
    sql: ${TABLE}.OPENACCOUNTAMOUNT ;;
  }

  dimension: openamount {
    type: number
    sql: ${TABLE}.OPENAMOUNT ;;
  }

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

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

  dimension: openprice {
    type: number
    sql: ${TABLE}.OPENPRICE ;;
  }

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

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

  dimension: openspotprice {
    type: number
    sql: ${TABLE}.OPENSPOTPRICE ;;
  }

  dimension: opentransaction {
    type: int
    sql: ${TABLE}.OPENTRANSACTION ;;
  }

  dimension: portfolio {
    type: int
    sql: ${TABLE}.PORTFOLIO ;;
  }

  dimension: positionseedid {
    type: int
    sql: ${TABLE}.POSITIONSEEDID ;;
  }

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

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

  dimension: quantityfactor {
    type: number
    sql: ${TABLE}.QUANTITYFACTOR ;;
  }

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

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

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

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

  dimension: switchouttrans {
    type: int
    sql: ${TABLE}.SWITCHOUTTRANS ;;
  }

  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: weightedperfcontri {
    type: number
    sql: ${TABLE}.WEIGHTEDPERFCAP+${TABLE}.WEIGHTEDPERFFX ;;
  }

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

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

  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: lastspotdate {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.LASTSPOTDATE ;;
  }

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

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

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

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

  measure: total_weightedperfcontri {
    type: sum
    sql: ${weightedperfcontri} ;;
  }

  measure: total_weight {
    type: sum
    drill_fields: [detail*]
    sql: ${weight} ;;
  }

  measure: total_basepnl {
    type: sum
    sql: ${basepnl} ;;
  }
}

- view: position
  sql_table_name: POSITION
  fields:
  - dimension: account
    type: int
    sql: ${TABLE}.ACCOUNT
  - dimension: accountcur
    sql: ${TABLE}.ACCOUNTCUR
  - 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: basedeposit
    type: number
    sql: ${TABLE}.BASEDEPOSIT
  - dimension: baseexposure
    type: number
    sql: ${TABLE}.BASEEXPOSURE
  - dimension: baserealized
    type: number
    sql: ${TABLE}.BASEREALIZED
  - dimension: baseunrealized
    type: number
    sql: ${TABLE}.BASEUNREALIZED
  - dimension: basepnl
    type: number
    sql: ${TABLE}.BASEUNREALIZED+${TABLE}.BASEREALIZED
  - dimension: basevalue
    type: number
    sql: ${TABLE}.BASEVALUE
  - dimension: closeaccountamount
    type: number
    sql: ${TABLE}.CLOSEACCOUNTAMOUNT
  - dimension: closeamount
    type: number
    sql: ${TABLE}.CLOSEAMOUNT
  - dimension: closebaseamount
    type: number
    sql: ${TABLE}.CLOSEBASEAMOUNT
  - dimension: closeprice
    type: number
    sql: ${TABLE}.CLOSEPRICE
  - dimension: closespotname
    sql: ${TABLE}.CLOSESPOTNAME
  - dimension: closespotprice
    type: number
    sql: ${TABLE}.CLOSESPOTPRICE
  - dimension: closetransaction
    type: int
    sql: ${TABLE}.CLOSETRANSACTION
  - dimension: equalizationfactor
    type: number
    sql: ${TABLE}.EQUALIZATIONFACTOR
  - dimension: fxaccrealized
    type: number
    sql: ${TABLE}.FXACCREALIZED
  - dimension: fxaccunrealized
    type: number
    sql: ${TABLE}.FXACCUNREALIZED
  - dimension: fxbaserealized
    type: number
    sql: ${TABLE}.FXBASEREALIZED
  - dimension: fxbaseunrealized
    type: number
    sql: ${TABLE}.FXBASEUNREALIZED
  - dimension: lastnav
    type: number
    sql: ${TABLE}.LASTNAV
  - dimension: lastnavstatus
    sql: ${TABLE}.LASTNAVSTATUS
  - dimension: lastspot
    type: number
    sql: ${TABLE}.LASTSPOT
  - dimension: lastspotname
    sql: ${TABLE}.LASTSPOTNAME
  - dimension: localdeposit
    type: number
    sql: ${TABLE}.LOCALDEPOSIT
  - dimension: localexposure
    type: number
    sql: ${TABLE}.LOCALEXPOSURE
  - dimension: localrealized
    type: number
    sql: ${TABLE}.LOCALREALIZED
  - dimension: localunrealized
    type: number
    sql: ${TABLE}.LOCALUNREALIZED
  - dimension: localvalue
    type: number
    sql: ${TABLE}.LOCALVALUE
  - dimension: openaccountamount
    type: number
    sql: ${TABLE}.OPENACCOUNTAMOUNT
  - dimension: openamount
    type: number
    sql: ${TABLE}.OPENAMOUNT
  - dimension: openbaseamount
    type: number
    sql: ${TABLE}.OPENBASEAMOUNT
  - dimension: openlinkedop
    type: int
    sql: ${TABLE}.OPENLINKEDOP
  - dimension: openprice
    type: number
    sql: ${TABLE}.OPENPRICE
  - dimension: openquantity
    type: number
    sql: ${TABLE}.OPENQUANTITY
  - dimension: openspotname
    sql: ${TABLE}.OPENSPOTNAME
  - dimension: openspotprice
    type: number
    sql: ${TABLE}.OPENSPOTPRICE
  - dimension: opentransaction
    type: int
    sql: ${TABLE}.OPENTRANSACTION
  - dimension: portfolio
    type: int
    sql: ${TABLE}.PORTFOLIO
  - dimension: positionseedid
    type: int
    sql: ${TABLE}.POSITIONSEEDID
  - dimension: positiontype
    type: int
    sql: ${TABLE}.POSITIONTYPE
  - dimension: quantity
    type: number
    sql: ${TABLE}.QUANTITY
  - dimension: quantityfactor
    type: number
    sql: ${TABLE}.QUANTITYFACTOR
  - dimension: security
    type: int
    sql: ${TABLE}.SECURITY
  - dimension: securitycur
    sql: ${TABLE}.SECURITYCUR
  - dimension: special_
    type: number
    sql: ${TABLE}.SPECIAL_
  - dimension: status
    sql: ${TABLE}.STATUS
  - dimension: switchouttrans
    type: int
    sql: ${TABLE}.SWITCHOUTTRANS
  - 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: weightedperfcontri
    type: number
    sql: ${TABLE}.WEIGHTEDPERFCAP+${TABLE}.WEIGHTEDPERFFX
  - dimension_group: closedate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.CLOSEDATE
  - dimension_group: closevaluedate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.CLOSEVALUEDATE
  - 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: lastspotdate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.LASTSPOTDATE
  - dimension_group: opendate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.OPENDATE
  - dimension_group: openvaluedate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.OPENVALUEDATE
  - measure: count
    type: count
    drill_fields:
    - openspotname
    - closespotname
    - lastspotname
  - measure: total_basevalue
    type: sum
    sql: ${basevalue}
  - measure: total_weightedperfcontri
    type: sum
    sql: ${weightedperfcontri}
  - measure: total_weight
    type: sum
    drill_fields:
    - detail*
    sql: ${weight}
  - measure: total_basepnl
    type: sum
    sql: ${basepnl}