Fact Account

view: fact_account {
  sql_table_name: reporting.fact_account ;;

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

  dimension: transaction_flag {
    label: "TRANSACTION Flag"
    sql: ${TABLE}.transaction_flag ;;
  }

  dimension: transaction_lx_code {
    label: "TRANSACTION LX Code"
    sql: ${TABLE}.transaction_lx_code ;;
  }

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

  dimension: amount_tier {
    type: tier
    sql: ${amount} ;;
  }

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

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

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

  dimension: dim_account_id {
    type: int
    hidden: yes
    sql: ${TABLE}.dim_account_id ;;
  }

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

  dimension: dim_loan_id {
    type: int
    hidden: yes
    sql: ${TABLE}.dim_loan_id ;;
  }

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

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

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

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

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

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

  dimension: loan_id {
    type: int
    hidden: yes
    sql: ${TABLE}.loan_id ;;
  }

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
  }

  measure: total_amount {
    type: sum
    sql: ${amount} ;;
  }

  measure: average_amount {
    type: average
    sql: ${amount} ;;
  }
}

- view: fact_account
  sql_table_name: reporting.fact_account
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.fact_account_id
  - dimension: transaction_flag
    label: TRANSACTION Flag
    sql: ${TABLE}.transaction_flag
  - dimension: transaction_lx_code
    label: TRANSACTION LX Code
    sql: ${TABLE}.transaction_lx_code
  - dimension: amount
    type: number
    sql: ${TABLE}.amount
  - dimension: amount_tier
    type: tier
    sql: ${amount}
  - dimension: bank_code
    sql: ${TABLE}.bank_code
  - dimension: co_code
    sql: ${TABLE}.co_code
  - dimension: cr_gl
    sql: ${TABLE}.cr_gl
  - dimension: dim_account_id
    type: int
    hidden: true
    sql: ${TABLE}.dim_account_id
  - dimension: dim_branch_id
    type: int
    sql: ${TABLE}.dim_branch_id
  - dimension: dim_loan_id
    type: int
    hidden: true
    sql: ${TABLE}.dim_loan_id
  - dimension: disbursement_receipt_code
    sql: ${TABLE}.disbursement_receipt_code
  - dimension: doc_type
    sql: ${TABLE}.doc_type
  - dimension: dr_gl
    sql: ${TABLE}.dr_gl
  - dimension: dummy_transaction
    type: yesno
    sql: ${TABLE}.dummy_transaction
  - dimension: jrn_gl_number
    sql: ${TABLE}.jrn_gl_number
  - dimension: jrn_seq_numb
    type: int
    sql: ${TABLE}.jrn_seq_numb
  - dimension: loan_id
    type: int
    hidden: true
    sql: ${TABLE}.loan_id
  - dimension: ltran_account_number
    sql: ${TABLE}.ltran_account_number
  - dimension: ltran_seq_numb
    type: number
    sql: ${TABLE}.ltran_seq_numb
  - dimension: pl_report_flag
    type: yesno
    sql: ${TABLE}.pl_report_flag
  - dimension: print_description
    sql: ${TABLE}.print_description
  - dimension: rec_type
    sql: ${TABLE}.rec_type
  - dimension: reference_number
    type: number
    sql: ${TABLE}.reference_number
  - dimension: trx
    sql: ${TABLE}.trx
  - dimension: vendor_name
    sql: ${TABLE}.vendor_name
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_date
  - dimension_group: transaction
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.transaction_date
  - measure: count
    type: count
  - measure: total_amount
    type: sum
    sql: ${amount}
  - measure: average_amount
    type: average
    sql: ${amount}