data.ml
LKML Car manufacture

Billing Period

Billing Period model for car manufacture.

inferred

Blocks

billing_period.view.lkml · 85 lines
inferred 
view: billing_period {
  sql_table_name: unite_db_stage.billing_period ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}
billing_period.view.lookml · 84 lines
source-preserved 
- view: billing_period
  sql_table_name: unite_db_stage.billing_period
  fields:
  - dimension: billing_period_id
    type: int
    primary_key: true
    sql: ${TABLE}.billing_period_id
  - dimension: billing_period_being_frozen
    type: yesno
    sql: ${TABLE}.billing_period_being_frozen
  - dimension: billing_period_interest_rate
    type: number
    sql: ${TABLE}.billing_period_interest_rate
  - dimension: billing_period_name
    sql: ${TABLE}.billing_period_name
  - dimension: billing_period_report_created
    type: yesno
    sql: ${TABLE}.billing_period_report_created
  - dimension: billing_period_report_should_be_regenerated
    type: yesno
    sql: ${TABLE}.billing_period_report_should_be_regenerated
  - dimension: billing_report_id
    type: int
    sql: ${TABLE}.billing_report_id
  - dimension_group: billing_period_end
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.billing_period_end_time
  - dimension_group: billing_period_invoice
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.billing_period_invoice_date
  - dimension_group: billing_period_last_downloaded
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.billing_period_last_downloaded
  - dimension_group: billing_period_payment_due
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.billing_period_payment_due_date
  - dimension_group: billing_period_report_creation
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.billing_period_report_creation_time
  - dimension_group: billing_period_report_freeze
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.billing_period_report_freeze_time
  - dimension_group: billing_period_start
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.billing_period_start_time
  - measure: count
    type: count
    drill_fields:
    - detail*

Contents

  • billing_period.view.lkml
  • billing_period.view.lookml