data.ml
LKML Analytics marketing

Shipment

Shipment model for analytics marketing.

inferred

Blocks

shipment.view.lkml · 93 lines
inferred 
view: shipment {
  sql_table_name: public.shipment ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [project.project_id, project.project_name]
  }

  measure: shipment_extended_gross_dollar_amount_total {
    type: sum
    drill_fields: [customer.customer_name, product.product_name, shipment.shipment_extended_gross_dollar_amount_total]
    sql: ${TABLE}.shipment_extended_gross_dollar_amount ;;
  }

  measure: shipment_line_quantity_total {
    type: sum
    sql: ${TABLE}.shipment_line_quantity ;;
  }
}
shipment.view.lookml · 60 lines
source-preserved 
- view: shipment
  sql_table_name: public.shipment
  fields:
  - dimension: sid
    type: int
    sql: ${TABLE}.sid
  - dimension: project_id
    type: int
    sql: ${TABLE}.project_id
  - dimension: customer_sid
    type: int
    sql: ${TABLE}.customer_sid
  - dimension: facility_sid
    type: int
    sql: ${TABLE}.facility_sid
  - dimension: product_sid
    type: int
    sql: ${TABLE}.product_sid
  - dimension: invoice_date_sid
    type: int
    sql: ${TABLE}.invoice_date_sid
  - dimension: requested_ship_date_sid
    type: int
    sql: ${TABLE}.requested_ship_date_sid
  - dimension: actual_ship_date_sid
    type: int
    sql: ${TABLE}.actual_ship_date_sid
  - dimension: shipment_carrier
    sql: ${TABLE}.shipment_carrier
  - dimension: shipment_extended_gross_dollar_amount
    type: number
    sql: ${TABLE}.shipment_extended_gross_dollar_amount
  - dimension: shipment_invoice_number
    sql: ${TABLE}.shipment_invoice_number
  - dimension: shipment_line_number
    sql: ${TABLE}.shipment_line_number
  - dimension: shipment_line_quantity
    type: number
    sql: ${TABLE}.shipment_line_quantity
  - dimension: shipment_order_number
    sql: ${TABLE}.shipment_order_number
  - dimension: shipment_service_level
    sql: ${TABLE}.shipment_service_level
  - dimension: shipment_shipper
    sql: ${TABLE}.shipment_shipper
  - measure: count
    type: count
    drill_fields:
    - project.project_id
    - project.project_name
  - measure: shipment_extended_gross_dollar_amount_total
    type: sum
    drill_fields:
    - customer.customer_name
    - product.product_name
    - shipment.shipment_extended_gross_dollar_amount_total
    sql: ${TABLE}.shipment_extended_gross_dollar_amount
  - measure: shipment_line_quantity_total
    type: sum
    sql: ${TABLE}.shipment_line_quantity

Contents

  • shipment.view.lkml
  • shipment.view.lookml