data.ml
LKML Ecommerce supplies

Quantity Discount

Quantity Discount model for ecommerce supplies.

inferred

Blocks

quantity_discount.view.lkml · 48 lines
inferred 
view: quantity_discount {
  sql_table_name: QuantityDiscount ;;

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

  dimension: discount_type {
    type: yesno
    sql: ${TABLE}.DiscountType ;;
  }

  dimension: display_order {
    type: int
    sql: ${TABLE}.DisplayOrder ;;
  }

  dimension: extension_data {
    sql: ${TABLE}.ExtensionData ;;
  }

  dimension: name {
    sql: ${TABLE}.Name ;;
  }

  dimension: quantity_discount_guid {
    sql: ${TABLE}.QuantityDiscountGUID ;;
  }

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

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

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}
quantity_discount.view.lookml · 39 lines
source-preserved 
- view: quantity_discount
  sql_table_name: QuantityDiscount
  fields:
  - dimension: quantity_discount_id
    type: int
    primary_key: true
    sql: ${TABLE}.QuantityDiscountID
  - dimension: discount_type
    type: yesno
    sql: ${TABLE}.DiscountType
  - dimension: display_order
    type: int
    sql: ${TABLE}.DisplayOrder
  - dimension: extension_data
    sql: ${TABLE}.ExtensionData
  - dimension: name
    sql: ${TABLE}.Name
  - dimension: quantity_discount_guid
    sql: ${TABLE}.QuantityDiscountGUID
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.CreatedOn
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.UpdatedOn
  - measure: count
    type: count
    drill_fields:
    - detail*

Contents

  • quantity_discount.view.lkml
  • quantity_discount.view.lookml