data.ml
LKML Ecommerce window treatments

Order Employee

Order Employee model for ecommerce window treatments.

inferred

Blocks

order_employee.view.lkml · 48 lines
inferred 
view: order_employee {
  sql_table_name: commission.order_employee ;;

  dimension: sudo_key {
    primary_key: yes
    sql: ${order_id} || ${user_id} ;;
  }

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}
order_employee.view.lookml · 31 lines
source-preserved 
- view: order_employee
  sql_table_name: commission.order_employee
  fields:
  - dimension: sudo_key
    primary_key: true
    sql: ${order_id} || ${user_id}
  - dimension: commissionable
    type: yesno
    sql: ${TABLE}.commissionable
  - dimension: divisor
    type: int
    sql: ${TABLE}.divisor
  - dimension: order_id
    type: int
    sql: ${TABLE}.order_id
  - dimension: override_date
    type: int
    sql: ${TABLE}.override_date
  - dimension: override_user_id
    type: int
    sql: ${TABLE}.override_user_id
  - dimension: showroom_id
    type: int
    sql: ${TABLE}.showroom_id
  - dimension: user_id
    type: int
    sql: ${TABLE}.user_id
  - measure: count
    type: count
    drill_fields:
    - detail*

Contents

  • order_employee.view.lkml
  • order_employee.view.lookml